View Full Version : answers
- DB2 - Select ... Output Option....
- Is it possible to connect to DB29.1 with a .vbs script?
- Suggest a Book for beginner
- Updating dbm cfg parameters from Application Program
- Updating dbm cfg parameters from Application Program
- DB2 delete performance
- DB2 UDB V9.5 Windows ENCRYPT
- How to setup the IBM Ruby and Python drivers for DB2 on Linux (32/64bit)
- VB.NET create/insert/select From Temp table
- DB2 Stress Testing
- strange problem while reorganizing the table, cannot do anything
- db2ntclp
- backup compress in viper 2
- Pagination in DB2
- Binding db2updv9.bnd failed with sqlcode = -31
- Load failure; SQL0104N
- Cannot Connect in DB2 Control Center
- UPDATE sql
- IBM DB2 JDBC Driver CallableStatement update count
- rownum in DB2?
- DB2 cutting logs frequently
- MDC Design question
- ODBC DSN Connection Error
- Count Unicode characters in DB2 8
- Encryption and key management best practices
- Export from DB2 causes file to be created with permissions of 640
- Cursor variables
- Special Characters
- about the special characters
- load failure - SQL0104N Db2 version 9
- DB2 High Performance Unload + remove unwanted data
- Newbie question : SQL search problem with substituted characters
- UDB XA coordinated transactions with MQ
- Performance Tuning for DB2 DB.
- Questions about number of connection and components to check for the status of DB2
- create / connect hanging on V9.1 FP3a
- Minimum unit of I/O
- Serge: How are those ...
- sql optimization
- Is creating indexes on date cols fo MAX /MIN aggregate functions good?
- cofused about SQL Optimization
- cofusing about sql optimization
- Db2 Create Tablespace Performance Impact
- Insert performance into DB2 using informatica
- DSNREXX and RXD2 from BMC mainview - coding difference
- Important about Novell Certifications
- select in select and concatenate strings
- Pattern Matching using LIKE predicate on a DB2 column using INDEX
- DB2 Session variables (or equivalent)
- Lock Manager Heap
- Question on Error Return Code SQL0902 Reson Code 18
- db2fm -D ; Error: failed to find the default instance. Environment variable not set
- "The statement is too long or too complex".for a simple Alter table statement from CLP
- Where is performance for IBM websites ?
- Converting from char to date/time
- load with cursor VS. Pipe
- db2chgpath msgs logged on db2 V9 client install on linux
- Undo handler across federated system
- Storing Table
- table design
- Tracking a Delete
- MS Query Issue
- db2look option with table create statements only
- help with SP
- Error Evaluating CHECK constraint.
- Stored Procedure - Help Needed
- problem in Refreshing Table
- Export function fails on DB2 v7.1
- Federated DB Bad Query performance
- DB2 9 FP3 - Linux vs Windows engines with AIO or a Db2 universal jdbc driver performanc?
- DB2v8.2 LUW. Unable to drop Foreign Key constraints...
- SQL3107W There is at least one warning message in the message file.
- IF EXISTS in db2
- Hi
- multiple cloumns in single row
- IBM Db2 Certification 700 Exam
- data warehouse center
- purexml
- SQL0440N No authorized routine named error
- Detecting RI datatype mismatches
- reduce large container to small container with same size
- Problem with a user defined function
- How to get aggregate statistics
- Package "NULLID.SYSLN31E 0X5359534C564C3031" was not found
- SYSIBM.SQLSTATISTICS
- How to determine if the Client Install on AIX is Runtime or Admin???
- Revoked System Privlege / Some Object Privlege remains for Public...... Does Public still have any access ?
- Please help me save this query
- CPUSPEED
- Updating across databases
- Does DB2 support Array and Object oriented types like what's in Oracle?
- REORG
- Import Dump file.
- DB2_PARALLEL_IO
- DATA_ENCRYPTION problem
- Online backup fails with sql0911
- Split data to different DB2 subsystems
- archiving log files for no reason
- Error -2147217900 [IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0104
- DB2 as a Web service consumer using SOAPHTTPV
- Weird - Uncommanded schema change in mid script
- db2 biggner
- Anonymous Block in DB2
- Comparing data in two different DB2 tables.
- Restore problem, unknown version of DB2 created the backup
- Get db2 backup size from TSM in Windows environment
- Urgent: some special error in db2diag.log
- ossSetAssertionCallback while install Linux Client
- What's wrong with the following set of commands and why
- Subquery Performance
- Please help to optimize the SQL Query
- Running long statements with Java/C++/CLP
- CTE in function
- start hadr as standby fails with SQL1768N rc=7
- Need help on Joins..
- Unable to connect to the DB visualizer with my tool
- SQL on Fire - Mass Deleting Data.
- How can I connect to a DB without typing my userid and password
- ASNCLP create apply control tables error.
- Corba, Msp
- How to compute storage utilization per schema
- Fixpak for Client running on AIX
- How to compute storage utilization per schema
- Using IBM Rational Build Forge with DB2 Express v9.1
- Yellowfin Release 3.3
- Modifying DB2 Profiles/Config files
- Restore DB problem
- how to use db2 connect server as a gateway to connect to mainframe db2 database
- Updating Java routines UDF on db2 UDB V8 FP10
- Updating Java routines
- Altering column's default in db2 V8
- Altering columns in DB2 V8
- Cursor load giving SQL0668 error
- Problem with SQL Query
- DB2GOV and DB2QP
- v7.2 client talking to a v9.1 database
- What is the min container size for DMS?
- Needed SQL
- DB2 Installation Failure (RC=1618) - Windows XP
- DB2 date display and formatting
- Sqlcode -430
- Logical Reads = CPU Consumption ???
- deleting large amounts of records
- Slow, hanging when deleting large number of records.
- trying to get the functions dependent on a table
- Problem comparing dates with VARCHAR type
- Excessive physical space usage, DB2 9 on Linux
- REORG Table and UTIL_IMPACT_PRIORITY
- Question paper for db2 exam 730
- User abend U1551
- how to express a recursive CTE that returns a balanced hierarchy
- Problem in inserting row
- Duplicate cursor names
- Bash Scripting db2move and db2look
- Reorg Tablespace
- date issue
- Problem logging on to DB2 v9 with non-admin rights
- updating a large table
- SQL30020 on extended ascii characters
- What are the data types available in the IBM DB2 database
- What are the data types available in the IBM DB2 database
- db2 governor failing with connection refused
- Forcing an HJOIN
- db2audit autostart
- Calling AIX shell script from a trigger
- Get unlimited visitors to your website
- Db2 query taking more execution time
- Perforamcne of Dual Logging in DB2 LUW
- Usage of subqueries
- db2 loader problem
- Bind SQL Error PLAN NOT APPLICABLE
- SQL0902C with reason code="32"
- SQL1092N "" does not have the authority
- Can a flat dataset from a DSN1COPY run be used to Load a DB2 table? and other questions...
- 2nd try (renamed): NOT LOGGED DGTTs and the transacgtion log
- IBM DB2 UDB 2005 Reporting Services
- SCD-2
- Merge statement for type 2 dimension
- Sample DB2 Log File
- how to append to the update statement.
- Visual Explain Error (SQL0104N) on Query Rewrite
- small sample web site to test db2 db connectivity
- for update statement
- URGENT : procedure to import data from excel sheet
- Does DB2 allow the user name to contain DBCS/Unicode characters?
- BOM QUERY IN TRIGGER
- DB2 Database 9 and licensing?? -> Connection trouble
- getting very cryptic error while inserting the records
- "update command options using m on" doesn't work
- Trying to install V9fp3
- no Info Integrator, so Linked Server in SQLServer2005...
- Urgent request: Db2 on Z/OS - How can a recovered tocopy tablespace be empty?
- Urgent request: How can a recovered tocopy tablespace be empty?
- How can I resolve a SQL1326N restore problem?
- How can I resolve a "SQL1326N: The file or directory cannot be accessed" restore problem?
- Dynamic Cursor in DB2
- How to return byte array in UDF?
- DB2 Stored Procedure: Setting up a cursor from Java as input parameter
- Defining transactions with DB2 procedural language
- DOS Batch file to run a Stored Procedure
- DB2 Cursor Issue
- V8.2 doesnot support this? SQL20165N An SQL data change statement within a FROM clause is
- AIX and HP-UX db2 v9 ese fixpacks and Control Center
- Help me on DB2 INSERT question
- what is the following error msg means,help me..
- DB2 error -804 Reason Code 06 and 07
- DB2 OLE Driver and Transactions
- DB2 Stored Procedure
- a communication error has occurred
- How to get timestamp to output in format?
- DB2 on NFS mounted install
- DB2 prep bind needed everytime?
- Connecting to DB2 v8 on z/OS from RAD v7 on XP
- Error in Roll-Forward due to corruption in Log Files!!
- Db 2
- DB2 User Monitor. Is it possible?
- DB2 IS (Intent Share) Locks
- "show explained statements history" doesn't work
- Search table with any one or more fields using static sql
- EXPLAIN SQL against DGTTs
- [ HELP ] How to audit select statement on specify table for db2 LUW v8 or v9
- deadlock on a table
- merge statement - why it is failing
- alternate approach to this sql
- DB2 Stored Procedure from SQL Server 2005
- DB2 Memory Usage
- New to DB2: Create table if exists? How?
- Use of Cursor in Trigger?
- Automatic database activation
- How to split the contents of a column
- Copying database 'data' to 'test' on the same instance?
- SQL - Update statement
- Function ffi_db2date
- Starting DB2 UDBv9 Express-C in a Linux environment
- Starting DB2 UDBv9 Express-C in a Linux environment
- Starting DB2 UDBv9 Express-C in a Linux environment
- What are the steps of creating a Cronjob in a Linux environment?
- Problem string with literals
- Improving DELETE performance for a large number of rows
- pricing of Workgroup and ESE
- Too many audit events in Event Viewer
- ADM10502W attention message from Health Center: Automated backup failed
- The database is currently in use.
- Which table should I use to get table entry
- A Killer Email Message - How to Write Killer Email Promos that Get Results
- View the Trigger Source
- How to print from AS/400 IPDS to barcode printer?
- Sequence as column name in DB2 V8 on MVS
- db2Backup API and DB2BACKUP_INCLUDE_LOGS
- IBM Iseries Rumba
- Data Types in Embedded C queries - problems
- ADM5571W
- Embedded SQL Select Statement using CICS
- db2 Incremental backup
- Unable to connect DB2 via db2cc
- DB2 instance
- o check spaces in db2
- db2 COLUMN DEFINITION
- DB2 fixpacks
- recall MQT definitions
- how to execute runstats in stored procedure
- Scheduling a DB2 command to run
- Execute runstats in a stored procedure
- XML storing and management
- count on aggregate function
- restore problem
- getting prevoius day's date in a query?
- How to set application name using sqleseti api call
- DB2 Snapshot log details
- What is wrong with this Redirected restore command - UDBv8.2 fp14 on Linux
- DB2 Tools/tuning to help performance over high network latency sites?
- i can see database in directory, but couldn't connect to it SQL1031N
- DB2 Export error
- How do you kick off a DB2 Script in AIX ?
- Cursor Load
- can space be provided as a value in the column (of database) ?
- To add line breaks in DB2.
- BIRT + Yellowfin + ANN mashup make Advanced Business Intelligence
- URGENT : How to Launch DB2 AS 400 program from PHP trough ODBC ?
- Does count(sum()) function work in ibm iseries navigator ?
- SQL0906N while opening cursor
- db2fmcd in /var/adm/wtmpx
- URGENT: sample WAS application on DB2 SAMPLE
- Connecting to DB2 server from Client machine for Business Objects
- Trigger in DB2
- List if default user ids with default passwords
- Remote database access within MB flow
- About Date & Graphic format
- list of db2 installed products
- if db2 udb can create hash index?
- performance implications of calling PREPARE more than once
- How to revoke the grant option from a user/group
- Default value for pool hit ratio
- DB2 Index on Physical Table Member
- Deep integration w/ DB2 9 in Altova Version 2008
- copying data from one table to another in a single SQL statement
- Need to extract schema only from db2 on old version of AIX
- Calling a cobol sub program from DB2 stored procedure.
- Ask for help about a problem of DB2 health monitor usage
- UDF has schema issues
- Renaming Windows DB2 Server Machine
- Error in java while getting connected to DB2
- DB2 Failover
- 32 & 64 bit Instance on the Same AIX Box
- Blob column from not logged to logged
- AIX doesn't know DB2 is installed
- SQL select not working when starting program is a stored procedure.
- Using .NET to access to a IBM DB2 database
- Encryption of transmissions
- Moving DB from DB2/Oz to DB2 UDB on soloris
- Does DB2 support schema acquirement automatically
- Good Questions for db2/400
- Error ADM1832E
- sql1042C error when I tried to activate a DB
- How to clear Secondary log files
- monitoring
- getting error while calling ADMIN.BACKUPSCHEMA
- getting error while calling ADMIN.COPYSCHEMA
- Bufferppol size...-1
- The setup routines for the iseries Access ODBC Driver could not be found.
- Suggest me Beginners Tutorials for DB2
- stored procedure lock question
- Cursor SQLCURSOR000000491 not open
- Grant on Proc not working
- Why OR extremely slows down the query?
- DB2 & MSCS Node Problem
- Error on DELETE -- whats wrong????
- How to recover the db2diag.log file
- sas9 Z/OS WORK space allocations
- Error in calling remote nested SP
- Arts and entertainment
- Cannot Reorganise any table in the tablespace
- want a code for e-ticketing
- Minimum Req for DB2 Installation
- Can changes done by the trigger be replicated back?
- How to identify the specific DB2 version installed in a system and restore a db to that.
- db2 cursor
- Compatibility of DB2 Express C V9.0 backup to be restored on DB2 ExpressEdition 8.2
- Does anyone use TestBase
- Adding procedures to triggers...
- ORA schema in DB2 r5.1
- DB2 Load Identity Column
- Loading Identity Columns
- db2 luw load chardel
- Stored Procedure
- How to retrieve the field heading
- db2 select & group by
- DB2 V9 Compatibility
- What is wrong with this Script? Problem with DECLARE etc, etc
- Using DFSMS Copy
- SQL Replace Function Problems
- Comparison problems
- Arabic Codepage conversion problem from WIN to Z/OS
- On what parameter does Database Capacity depend
- ADO users
- Arithmetic overflow or other arithmetic exception occurred
- Set maximum number of rows on a table?
- Warning message from notification log
- load a table from an IMS File
- DB2 and PostgreSQL federation
- How many extents are allocated when a table is created
- Can't update admin cfg
- problem in connecting to DB2 V8.1 and WAS V6
- revoking Privilege from One Admin User On Table Owned by Another Admin User
- Can Triggers work in different databases ?
- Index - DB2 tables
- client licensing question
- Error reading recordset from DB2/AS400
- I need help.....Loading from XML to DB2 table
- some help with ODBC or OleDB please
- Need help with some weird date manipulations
- How to run stored procedure in Command Line Processor
- size of the database
- Hi... Insertion in to Global temporary tables in db2
- Dynamic SQL
- trigger with check integer column
- Sqlcode -927
- cpytoimpf failing on V5R4
- Db2 701 Exam
- What is wrong with this SQL? Problem with Long Varchar column at create Table
- Vexing Problem with DB2 UDB Design Advisor? Any Suggestion, please!
- How can REORGCHK and REORG be used together in a Script to select DB2 UDB objects to Reorg?
- If you really want lauf, cklick down on the link:
- DB2ConnectionCorrelator: NF000001.F3C6.070908215236
- VB6 ADO and OUT PARAMETERS
- please help me
- Need Help Urgently! DB2 8.2 on Linux - suddenly unable to connect to any DB
- DB2 V8 FP12 - Merge Statement - Plan Question
- db2 standard backup practices
- Copy Table shows target databases wrong in Control Center
- db2 UDB backup using COMPRESS option
- Clob exception in DB2 CLP
- View Tables of DB2 Database using JDBC
- how to connect to db2 database
- -811 SQLCODE Behaviour !!!
- DB2 database IDE
- instance creation problem
- Can I access DB2 DB with Toad Client
- IOs in DB2
- how to use COALESCE?
- DW Specialist
- Cursors
- Data change table references and SQLCODE -20165
- How to compare several rows in one table???
- space utiilization in a DMS tablespace
- Error While installing DB2 on RHEL5
- DB2 & Oracle source code reusability
- Db2Viper2beta on Windows Server 2k8beta3?
- Can stored procedure have call to subroutines
- join with example
- fetch cursor
- Stored procedures and Global temporary tables
- DB2 DBA 702 Certification exam
- DB2 Logging in Materialised queries
- db2 with cd
- Insert into AS400 table locks bacuase of trigger
- prevval and nextval for a sequence
- Deadlock/timeout error
- Stored Procedures Updates
- Restoring, can't redirect tablespaces
- Sort Performance
- Able to alter or drop a table but cannot create the table, when no permissions are given to that user
- SSIS and DB2 Schemas
- IMPORT with METHOD N
- how to import db2move.lst
- size of the database ?
- DB2mscs command
- Granting DML privileges on all the tables of a schema to a user
- Runstats Utility
- Short circuit boolean eval in trigger WHEN clause?
- Sqlcode +97
- SQL need to be optimized
- Delete/update Sql/400 Stored Procedure Not Working
- History query question
- Basic Cron job not working in UBUNTU
- faster CPU vs more RAM
- waiting on archive
- Create Table sql0204 error
- SQLPRIMARYKEYS corrupted
- IBMDEFAULTBP setting
- "I" is not valid in the context it is used - db2 command line sql
- db2updv8 necessary for FP14 -> FP15?
- oad done on a table with nonrecoverable option on a archive loging enabled Database
- Main differences between DB2 v7 & v8 in a Z/OS env
- Writing a stored procedure in command editor
- Write a cobol program without using session table
- Improving Performance in DB2
- DB2 Not ATOMIC Compund SQLs
- Fixpak installation in db2 udb
- Syntax to Update Timestamp Column
- How to run db2commands in windows cmd prompt
- Reason for DB2 error code Sql0204n
- How do you get load to reject and not truncate data
- DB2 error SQL30081N on AIX version 5.2 / 5.3
- dropped a not null column from a table, error while running stats
- dropped a not null column, having problem in Update
- Definition of empty table
- DB2 Installation Problem
- Executing DB2 commands from Windows command prompt
- The database alias "MONITOR" already exists Can't Not Drop it
- Invalid cfg for DAS tools catalog (or maybe db2fm)?
- Sorting data within inline queries
- Hang on archive
- XSU Java package with DB2
- Tracking DML changes for important tables
- writing output of Stored Procedure to an outputfile
- Restore backup performed on Unix server to a Windows server
- some arbitrary application ids in "db2 list applications"
- tracking DML on important tables
- Automatically disconnecting DB2 clients which are inactive for some time
- Efficiency of DB2 LOAD RESUME vs REPLACE
- fortran db2 on Windows
- OracleXMLQuery class with DB2
- Unresolved external with DB2 v9
- Informix current sessions with database names
- ORDER BY CASE Problem
- db2 CASE statement in ORDER BY clause
- ODBC connection to V7 and V8 databases simultaneously
- Verify File before import
- Java scalar function slow
- .Net Framework Data Provider for DB2?
- Table Functions using Db2 on Z/Os
- INSERT binary data
- Insert using RRN?
- DB2 as web service client?
- Interface tools for DB2
- SQL1032N No start database manager command was issued. SQLSTATE=57019
- TSA binary for Windows
- That works faster in DB2 for creation of an index?
- Adding a not null column to a table with 0 rows
- db2_deinstall command
- How to use DB2 ODBC on z/os with COBOL
- Error comes when insert records
- SQL0440N No authorized routine named "||" of type "FUNCTION" having compatible arguments was found.
- Mainframe file loaded into DB2 table
- Use of SELECT [Fields] INTO [var] in UDFs
- How to find out last REORG timestamp ?
- HADR primary to standby
- ADM1844I - Many Many Warnings in the event viewer... Why ?
- DB2 privileges, Direct and Indirect SYSADM
- How to Handle IF THEN ELSE IN DB2
- Effects of Increasing the locklist parameter
- Problem with accessing 2 different tables using the same binary
- Combine queries for single output
- Another Bizzare Crash...But no Recovery. SOS!!
- SQL Server 2000 linked server to Db2 on z/OS
- DB2 Merge performance
- informix/db2
- DB2 function
- How to write query with two select statements in db2
- SQL or stored proc
- rid
- Odd Diag Log Message on V9 FP2
- load/import in db2
- how to change user password
- query runtime problems - same tables joined together
- How to IMPORT MS EXCEL worksheet in Kanji (Japanese) to db2/400
- maximum number of column can be set as Primary key in DB@ V8
- updating the locklist
- How to get the zero's for unsatisfied fields in group by clause in DB2
- Need to connect to Db2server
- converting Oracle PL/SQL function to DB2 v9
- Sqlstate 42972 from Query
- stored procedures perf. question
- Data load in DB2
- db2 exam 701 dumps
- Return columns using db2_columns() via PHP
- print value during execution stored procedure
- Query question
- Indexing of table in DB2
- setting user name password and user name for automating create script
- High water mark
- declared global temp table with merge
- The Question about REDIRECT RESTORE
- sql error -530
- When should we Reorg
- Background Process for Reorgcheck
- Background Process For Backup
- db2 on raid5, striped disks, SAN
- Alter column precision
- Select null as xyz from sysibm.sysdummy1
- fastest way to delete 1 billion rows from a table haveing 9 billion records
- Select null as xyz from sysibm.sysdummy1
- Generated Column
- Poll: DB2 V9.1 Adoption
- Count the transactions happened in a database
- Describe Sql View
- Select From Db2 W/php Error
- Not a trial, a commercial tool you can use for no charge for as many databases as you want
- Backup Information