View Full Version : answers
- Perl DBD
- binary data in char field
- Production Database Setting DB2 UDB
- Online backup
- DB2 Trigger question
- New to DB2, need to download command center
- java.lang.UnsatisfiedLinkError: SQLConnect
- Concurrancy
- Normalisation
- db2 and WMI
- Pls help me solving this....
- Identifying a password for the newly created user to a database in DB2
- DB2 log file in OS/400
- Solution: DB2 JDBC addBatch truncates DECIMAL fields during inserts, if the last row has null values
- UDB 8.1 & 9 Installation notes - Fedora Core 6
- HACMP + DB2 HADR vs Automatic Client Reroute
- How to obtain actual I/O COSTS of executing a query
- Rollforward to a particular log
- Understanding Navigator output for DB2 i/Series 5r3
- How to solve SQL1009N
- 64 bit db2 and jdbc
- inconsistent state of the database
- Error while pulling data from db2
- HTTP status 500 eroor when connecting to db2 using jdbc .pls help. urgent
- I have trouble to build DB2 CLI samples using visual 7 environment !!
- Having two editions of DB2 Connect on same machine?
- How to convert Milliseconds to Date in DB2?
- transposing column data into columns
- decryption of encrypted DB2 UDB LUW column without using DB2 decrypt function
- Path error when using DB2 load dumpfile modifier - related to partitioned database?
- Statistical views and optimizer profiles (aka hints)
- CONNECT TO DB2 VIA TCP/IP PROBLEM
- DB2 9 ESE Fixpack 1 and First Steps
- Searching a CLOB of XML
- Import data from AS 400 to DB2 9 express
- Debug at DWB
- DB2 ON LINUX Z SERIES/390
- DB2 v9 as web service provider - WORF sample(s)
- Health monitor threshold check frequency
- List of a lock concerned stmts
- db2licm question (v9)
- Extract Nickname definition from system catalog tables.
- WITH clause vs global temp table
- DB2 9 Parameter hell
- DB2 federated procedure
- DB2 Stress Test
- urgent .any one please help me
- seqnum generation!!
- db2 exit codes?
- db2advis
- INSERT into ... VALUES (TIMESTAMP) problem...
- Problem with Kerberos authentication
- Help me solve this : DSNT408I SQLCODE = -104
- substr function on timestamp datatype
- problem starting db with version 9.1
- DB2 don't use an index
- please help me : problem with loading db2 driver
- Stored Procedure with db2cfg Api to get the cfg of a database!!
- DECIMAL into CHAR
- index usage when using SUBSTR
- 64 GB Hard limit on Total Pool Pages
- view with virtual column?
- Why DB2?
- Listing instance connections on z/OS
- System DSN
- SQL Operations/Functions with TIMESTAMPS
- Issue with CAST, COALESCE and nulls
- SQL 955 but snapshot shows memory still available
- Insert into and FETCH FIRST ROW ONLY
- why link to DB2 'libdb2' library cause the semaphore misbehavior?
- db2 connect to a db in a differrent server?
- Risks in Circular logging for huge db in partitioned environment.
- Adding a tablespace when an online backup is happening....
- connect reset vs disconnect vs terminate
- Import with replace for replicated table
- Schemacrawler and DB2
- DB2 DSN CURRENTSCHEMA
- How to find currentSchema from JDBC application
- db2 & message broker
- Help with using FETCH command
- Federated Database Problem.
- date_to_decimal
- SQL API's in Java? sqlugtpi and sqlugrpn in DPF environment, DB2 ESE V9
- Audit Triggers
- Support DSNTIAUL in DB2 version 9 and next?...
- Equivalent query for Connect By In oracle
- Rowid In Db2
- How to execute db2 query from a unix shell script
- Ftp Using Db2!!
- How to generate sql script?
- Temp Table - check if exists
- How do you specify a default schema for DB2ADVIS?
- Does HADR detect DB2 version mismatches?
- Unable to restore a database image into a replicated database.
- Java stored procedures from v7.2 to v8.1 problems
- test
- Laws and Myths of Usability & Interface Design
- SQLDBS reorg
- question on update sql
- db2mon by Chu Zhoi
- DB2-Visual Studio 2005
- Urgent Help plz!!
- BACKING UP DB2 DATABASE TO TAPE
- setLong() bug in db2 Connect jdbc?
- MQT table use by optimizer
- DB2 Recovery Expert V2.1
- Cursor fetching without declaring host variables... dynamic SQL?
- Db2 on iSeries strange column names
- Passing custom arguments to command-line db2 processor. Possible?
- problem when insert over 1000 records to db2
- failed concaination
- db2 relocatedb or redirected restore?
- DB2 cursors in stored procedures with parameters?
- Sub procedures in DB2?
- Text files in queries
- Is there a way to do ORDER BY with DESC inside a CASE statement?
- log archive frequency
- Tracing a Application using db2pd
- Java UDF performance trouble
- Oracle To Db2
- Help Regarding Connecting Crystal Reports with IBM DB2
- DB2 Version 8 DST Issue
- Marketplace: Yellowfin reporting 3.1 with BIRT Integration
- Changing a PACKAGE's BOUNDBY
- Fixpak 5 directly to fixpak 14 - possible?
- Database transaction log switch history
- Check for SyAuth
- how to get client workstation name
- A few questions on SET INTEGRITY
- User Defined Function
- Web Based Application Hangs when more number of users are logged in.
- DB2 issue for some Non English Characters
- Help on "create view" (no locking required)
- Query in Reorgchk
- Need help with query performance.
- problem with clean up
- DB2 optimizer
- SQL SP called with invalid parameter (-301) and WORK?!!
- timestamp & event monitor output - why time is diff???
- using db2rfpen in DR environment...
- The length of CHAR() and CLOB columns in UTF8 character set
- Executing sql UDF in java
- Multiple update in single db2 sql query
- DB2 UDB 8.1 Vs DB2 UDB 8.2
- Urgent Query
- snapshot_appl_info equivalent for z/OS
- HADR - recovery
- Registry Variable for linux
- db2 client on MSCS
- Sub-optimal performance of a UDF
- Help about stored procedures
- notification at failed log archiving
- Instance attachment
- inserting \0 into a CHAR/VARCHAR field
- Catching values returned by a java program by a DB2 function/stored procedure
- The AMX_c05_ETL1_Pre_Extract Step cannot be executed
- Stored procedure performance (DELETES VERY SLOW)
- installing DB2 on Windows
- To find whether the procedure is still running
- Limitkey
- Multiple-condition trigger trouble
- runstats on global temp tables
- DB2 UDB Logretain
- Sqlstate=42884
- Spilled Sorts (better Indexing??)
- user defined function and executing sql statements
- GROUP BY and SORT
- what is the correct DB2 data type to store an encrypted string
- Is there a way to check the order in which SET INTEGRITY needs to be applied?
- How to call SQL Stored Procedure from REXX?
- query response time and cpu usage
- Temporary Systemtablespace is too small
- slow deletes
- Slow deletes
- calling a java application in DB2 UDF
- Security issue with system call from C udf on Windows
- DB2 Diaglog file msg
- How To Find The Plan For A Program
- process to bind a java file
- Invoking java programs from stored procedures
- Error Help: CLI0120E Memory Allocation Failure
- Error Help: CLI0120E Memory Allocation Failure
- Where is the "ALLOCATE" parameter?
- GROUP BY also means SORT
- Change column Data Type from Integer to Decimal
- Getting db2 output into a shell variable
- DB2 Connect Hangs in Shell Scripts
- Copy data between databases
- Select Into
- How to load data using DB2 Load Utility into Japanese database
- unable to connect to db from client machine
- start hadr as standby fails with SQL1767N rc=1
- Linked Server from MSSQL 2005 to iSeries
- sql question
- How to extract definition of nicknames in DB2 version 7
- DB2 v7.1 for Z/OS - Need to know why I should delete and redfine DSNDB07 daily ?
- SQL Replication Migration from V8 to V9
- How to make tables use another tablespace in DB2?
- Load utility
- are wombats good?
- where are wombats?
- Catalog query
- replication and kerberos ?
- Running OS commands in DB2 UDB stored procedures
- Ulimit and Kernel Param Settings
- Shared memory issue
- SQL1042C An unexpected system error occurred
- Convert IXF to CSV
- Interrupt Port
- Creating a DB2 Instance from the Command Line (Unix/Linux)
- sorry
- HOW TO SCHEDULE TASK IN DB2
- db2 v9 license issue
- Backup and Logfiles
- restore backup from v7.2 to v9.1
- How is refresh of nickname definition done?
- Database design for tree structured data
- DB2 COBOL problem
- How to find out the most expensive SQLs in J2EE and DB2 environment.
- Connection Concentrator causes slowdowns in db2 v9
- PROJECT INTERNSHIP
- Using Data Movement Utilities(IMPORT/EXPORT/LOAD) from within Stored Procedures
- Upgrading from Version 7 Client ODBC installation, using with Embarcadero DBArtisan
- begineer to db2
- Need help with an XML querry
- print statement
- DB2 Proper Case User Defined Function
- Optimized statement for subquery using count(*)
- optimization challenge
- Problems with Database move - Windows to Linux
- EDU process dieing
- How to combine multiple input fields as single output field
- Trying to link to DB2\Linux
- output of DATE function
- Reorg : Require Urgent Response Plz
- IBM DB2 support in oXygen XML Editor
- Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was not found.)
- monitoring questions
- Convert Null in Date field to String
- correlation between ipcs -mb and db2mtrk
- Error code for Export
- SQL4304N RC=1
- SQLCODE: -443
- Net Search Extender
- Forum 2006 - Ambuj Goyal, GM IBM Information Management, keynoteat user group meeting
- how to shutdown only 1 database in a
- Is this possible with SQL?
- DB2 index related qusn
- Finding running SQL
- SOA - The movie
- Yellowfin leads the new players in taking business intelligence mainstream.
- Data Warehouse: Invoke a user defined program
- Benchmark comparisons of IDMS and DB/2
- NoClassDefFoundError:sqlj.framework.ClassFileReade r
- Determining same row in update trigger
- DPSIs: Materialisation of column values for DPSI use
- how to convert clob to other data type ?
- index on global temp table
- SQL Procedure Question
- correlated update headache (db2 unix)
- host variables in cobol program
- How to delete some DB2 packages
- com.ibm.db2.jcc.b.SQLException - URGENT
- Howto refresh cataloged database?
- DB2 UDB for Windows needs to emulate a DB2 UDB for z/OS function
- UNION ALL and OR Predicate optimising vastly differently ?
- db2advis giving trouble
- data clustering.
- INDEXREC set to access : Poor Performance
- How to signal a warning inside a trigger ?
- DB2 v9 web services sample doesn't work?
- slow connection to DB2/LINUX 8.2.3
- DB2 Java INSERT-Statement / truncate
- DB2 job in Brussels Still open
- DB2 trigger HELP
- Connecting to DB2 from MS Query
- DB2 connectivity with WAS
- how to release appropriate locks using CLP
- how to release appropriate locks using CLP
- Implicit Commit On DB2-Transaction On Termination Of Process
- Strange IMPORT warning
- Partial Transactional Integrity?
- php code is not running after migrating the DB2 Connect EE from V7 to V8
- Conversion of packed data to db2 date
- DB2 on Z/OS - SQL w/o SPUFI / QMF kinda tool
- how to reset tablespace high watermark counters?
- I/O cost of an NLJOIN
- Backup in Db2 Linux and Restore in DB2 Windows
- Statement monitor output as db2 table
- connect to UDB from host AR
- DB2 Command Line Processor (CLP) - How to turn autocommit off within CLP?
- SQLCODE -1078918717
- DB2 WSE 9.1 och RH AS 4 x86-64
- Syntax to Create MDC Table
- Variable in SQL-Script
- Replicating multple tables
- Replicating multple tables
- Using DW tools on DB2 Version 7
- can anyone suggest a more elegant solution to this?
- Test backup image
- Kerberos / Windows authentication
- Snapshot problem for dynamic-sql: zero cpu counters
- sql for db2 list db directory and db2 list node directory
- Optimizer's use of check Constraints ... ?
- dbsize
- DB2 query
- jak usunac zawartosc logów
- Does DB2 V8 support PMML?
- SQL error 805
- -30081 Solution
- How to administer multiple DB2 instances
- daemon for db2
- Autostart DB2 v9 on Linux
- IMPORT with some defaults
- Mesure Instances Usage in a DB2 server
- ALTER TABLE ALTER COLUMN
- Create multiple output files during a single unload on z/OS DB2 v8
- Db restore
- deploying java stored procedures using non standard jars
- db2expln output and operator information
- Possibly dumb IBM DB2 v8 triggers question
- Rebind operation locks up
- archive log backup doesnt happen
- DB2 GetSnapshot API
- DB2 job in Brussels
- ADMIN_CMD IMPORT and CODEPAGE
- Federation issue, DB2 to Oracle
- DB2 auto rebind lock-up
- Info-messages i db2diag.log even if diaglevel set to 3
- Use ODBC API to retrieve indexes and keys on AS/400
- MQTs and UDFs
- Strange problem after use coalesce()
- Broken Pipe
- Connect & Disconnect
- Creating User Defined functions in DB2 v7.1.2 OS/390
- two-phase commit in DB2
- Reg:db cfg parameters
- Create user in DB2 v8.1 FP11
- Performance issue in a partitioned database
- SQL Reporting Services (SRS) and DB2
- Hepl please - Product stop to work on DB2 v9.1!
- Erwin Reverse Engineering from IBM DB2
- Suggestion for select statement
- Connection from Rational Application Developer -> IBM v9.1
- Object creation
- Forum 2006 - A two-day IBM Informix and DB2 User Group TechnicalConference
- Forum 2006 - A two-day IBM Informix and DB2 User Group TechnicalConference
- db2pfchr taking lot of memory
- Transaction failed under DPF
- FYI: Technical whitepaper on compression a DSS environment
- Domestic Alternative To Offshore Outsourcing
- IMPORT with MESSAGES ON SERVER
- Unbelievable SQL0811N on scalar subselect
- concatenating historical records
- row-counts to BLOB size ratio
- multiple tablespaces containers on SAN
- question about java routines
- DB2 and extended ASCII table
- List tablespaces work, but not SQL
- case issue in fetchrow_hashref
- build index from key field
- Result set from ADMIN_CMD
- Non-Case-Sensitve LIKE Operator
- Back-Up of DB2 on 32Bit Windows, Restore on 64Bit Windows
- db2 command
- weird SELECT privilege issue
- Error formatting event log
- Error accessing Package SYSLH203
- Strange Archive Issues with the Netbackup.
- reorgchk_ix_stats and reorgchk_tb_stats
- How can I connect from DB2 to ORACLE Version 7.1 on VMS
- New hardware, copy databases?
- SQLWARN output
- Microsoft Cluster
- How to check DAS start up use ps command
- Yellowfin BI Suite are now validated on IBM's popular DB2 9 database
- Db2 invalid pool id error
- db2 hangs when using snapshot monitor on linux
- problem with udf
- How do I backup IDM DB2 database configuration parameters?
- querying from sysibm or syscat tables
- HADR: Automatic Takeover on Windows systems
- Express-C and Remote Desktop
- Bufferpool tuning hint
- Governor incorrectly forces processes
- recursive sql
- DB2 LUW on Linux
- Problem with VARCHAR FOR BIT DATA
- DB2 health checkup script
- DB2 health checkup - help needed
- Compilation error, stored procedure, sql, iseries v5r4 (as400), urgent help plz.
- SQL10004C An I/O error occurred while accessing the database directory.
- Trouble connecting to databases from DB2 9 - Command Center
- Upgrade IBM DB2 7.2 to 8.2 - Issues with Autocommit
- DB2 Scheduler on Windows stops scheduling.
- error logging functionality
- Developing application for DB2 Mainframe
- DB2 fixpak quite install
- db2 version 8.1 client fails on Windows 2000 server - help?
- Using WHERE condition in UNLOAD or LOAD
- Configuring Database
- switchover cluster
- I can't put a subquery into a coalesce in Z/OS DB2
- Testing for a Connection
- MQ Listener - anyone using this in a production and/or mission critical fashion
- db2ckbkp with leagto
- hl7 xml schema register problem with xerces library of DB2 Express-C v9
- DB2ADVIS Error: SQL0444N Routine "*IZE_INFO" (specific name "GET_DBSIZE_INFO")
- install UDB / DB2 on CentOs
- Determinining which PRODCEDUREs need to be REBINDed after a TABLE DROP/CREATE
- Choosing a good ibm db2 replication product
- db2admin server doesn't start, SQL1042C on AIX
- db2 8.1.5 how obtain machine name
- Migrating a Windows DB2 8.1 to DB2 8.1 database system on AIX 5.3
- Unable to grant execute privilege (Urgent)
- Returning rows after select for update and update current of
- db2audit - AUD00003N, I/O Error
- Divide the registers of table among process with Java and Stored Procedures
- jdbc statement.setQueryTimeout
- tablespace / container info from a backup image
- input indicator variables
- DB2 7.1 encryption Urgent Help
- DB2 v7.1 on ZOS 1.6 encrytion
- Can't query or drop a table
- How to create a query in a .bat file
- Migration from udb v7.x to db2 v9: a stupid simple question
- db2 CASE or CAST problem
- delphi -> db2 xpress 9
- determining which rows fall in which partition
- Accepting user inputs in DB2 UDB? (Oracle & syntax)
- Call stored proc inside another stored proc
- IBM DB2 question - Update 2 different tables based on IF THEN ELSE criteria
- Configuring Extent Size
- SQL Dynamic Table Count Select Assistance
- Difference between DB2 9 client and DB2 9 runtime client
- DB2 UDB LUW DB2 LOG API : Table descriptor record (how to compose the )
- javaw error, 28132
- DB2 governor, is setlimit clause measured across one SQL,UOW,connection?
- Any Links for information on db2 parameters
- Regarding DB2 EEE
- Regarding DB2 EEE
- MS-Access and IBM DB2 ODBC driver
- DB2 iSeries/AS400 vs. DB2 ESE Windows/Linux
- How to force the join order ?
- Local database requiring userid/password
- Health Monitor memory problems.
- What is the API to call terminate
- db2start fails after attempting to catalog node
- getGeneratedKeys() problem
- SP returns resultset in Control Center, but empty resultset from command line
- Trigger problems in DB2
- DB2 Z/OS - Cross Region Alias Not Working v8 Clients ?
- user exit problem
- LOG files not in a readable format
- significance of SQL state?
- UCASE really slows queries down
- set integrity command
- DB2 CLI Performance Probelm
- querying backup process
- Newb Query About Reconnecting aplications to DB2 Server
- Online Reorgs and logging
- Relationship between recv_hist_retentn and archive log files
- Export Command - How to generate a row with column headers
- Maximum Number of Connections has been removed (JR18223)
- What's the meaning of the error code
- transaction-log memory mapped on AIX ?
- Waiting for remote node - Why?
- cygwin - db2 v9 on windows
- DB2 - Beyond case statements
- Software Testing Portal
- DPF failure to connect
- ADO.Net Application compatibility between fix pack lvl on build PC and fix pack lvl on deploy target
- Export Command SQL with carriage return
- Not getting sqlcode 100 at end of fetch
- drop 'Not Null' constraint
- DB2 deadlock while accessing plan?
- DB2 stored procedures
- How to find table modification time?
- Packaging DB2 jdbc driver with an application? Why not?
- db2 client traces
- T-SQL FROM SQL to DB2
- SQL0902C : Subsequent SQL statements cannot be processed
- Creating a DB on a partition environment
- OLAP windowing legerdemain
- IllegalAccessError since db2 9 and java 1.5
- Recovering tables from DB2 V2
- ibm preps ?
- Insert Into Select - I need each row Selected to be dependent on orecords previously inserted
- PAM AND DB2 AUTHETENTICATION
- HELP! Create Database problem
- invoking db2diag tool on win32 (UDB 8.1 version)
- self_tuning_mem on
- Selecting Next Value Only...
- Unable to configure PHP with DB2
- SQL1326N The file or directory cannot be accessed
- If I have a license for DB2 V9 ESE for the appropriate number of CPU's
- query question...
- warning message along with result set
- DB2 JDBC Applet Server service terminated unexpectedly (db2jds)
- Drop all foreign keys
- Commit during insert
- SQL Locks
- DB2 license for Range Partitioning with DB2 V9 ESE
- question about "select * from new table (update ...)"
- An SQL error "-911" occurred during processing
- Could someone please say something on my issue?
- DB2 Clustering
- db2javit rc : 9505
- "MESSAGE : DPS not initialized for this application" - what is it
- stale statistics or whats the difference?
- handling DB2 warnings
- DB2 post FP13 crash
- Artificial Mind - Part One - Basic Architecture and Cognitive Structure is now available
- fixed length host variables for VARCHAR fields
- Sql Trigger or Key Constraint or Check Constraint
- SQL2036N when backing up to CIFS
- Password too short?
- Password too short?
- An interesting issue with DB2SystemMonitor
- Error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
- Sorting UNICODE as EBCDIC
- Display table structure graphically
- Getting SQL30082N resaon 19 on DB2 9
- DB2 700 exam
- Query help
- 'list applications' privilege??
- How do I clear event monitor files?
- Domestic Alternative To Offshore Outsourcing
- STMTHEAP Issue
- Type 4 JDBC driver Bug Check thrown
- UNLOAD utility (mainframes) - UNICODE to EBCDIC
- Stored Procedure/ UDF not available in DB2 Express Edition ?
- load from cursor vs delete/insert
- _ in LIKE
- DB2 temporary tables help
- "WITH UR" in a UDF
- Scheduler in db2 v8.1.12 Linus
- DB2 LUW Trigger using sqlstate
- db2updv8 problem
- Declare variables and assigning in SP's
- XML, ETL tool and db2 Version 8.2 FP13 on AIX
- Db2 backup
- DB2 Restore V8.2 Express
- Disabling the behavior of RESTRICT
- DB2 auth problem
- DB2 V8.2 Data Import
- Transaction effect PHP+DB2 v 8.1.12 Linux
- DPF related info
- How to read tables from DB2 and write them in txt file using JAVA Code?
- I need lock a row on DB2 Iseries