DB2

SQL0901N Error.
Hi , I received this error message while executing an application SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "column number out of range".) SQLSTATE=58004 From the error message in error help ..I can't find any thing mean... 27 Feb 2006 06:57

Explain history
Does anybody have a tool to store/retrieve explained sql? We're running DB2 8.2 on AIX. We would like to be able to compare old saved explains to the current ones and see if anything changed. Thanks, Yuri ... 21 Feb 2006 16:20

Cause of excessive paging
Greetings, Could someone confirm if the following reasoning is correct (64-bit DB2 on 64-bit AIX v5.3): ================================================================== For each connection to DB2 db, AIX will reserve a 64GB shared memory segment for buffer caching. So if there are connections to 3 differe... 24 Feb 2006 09:08

Simple Insert using Case statement
Hi, I have a table with 2 columns ** CREATE TABLE test (emp_num DECIMAL(7) NOT NULL,emp_name CHAR(10) NOT NULL) and i have inserted a number of records. ** Now, I want to insert a new record (3232,'Raindeer') based on the condition that the emp_num 3232 doesnt exist. SELECT * , CASE ... 17 Feb 2006 02:51

Failover problems
2 servers with solaris,veritas cluster and DB2 UDB ESE v8.1 with fixp10. ON the primary db2 server did I create 2 db2 instances and the admin instance. It is possible to start both db2 instances and the db2 admin server on the primary server but ...failover works only for the 2 db2 instances and not for the admin s... 25 Jan 2006 19:01

DB2 Connection String Problem while DB2 connection OPEN
while opening a new DB2 connection using ODBC connection i get the following error message ERROR [08004] [IBM][CLI Driver] SQL30061N The database alias or database name \"DATABASENAME \" was not found at the remote node. SQLSTATE=08004\r\n\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver'... 19 Jan 2006 00:20

How to query the DB2 z/OS V7 dictionary for indexes?
Hi, i've tried to query the dictionary for indexes on a table as follows: SELECT KEYS.COLNAME, KEYS.COLNO, KEYS.COLSEQ, KEYS.ORDERING FROM SYSIBM.SYSKEYS KEYS, SYSIBM.SYSINDEXES IDXS WHERE IDXS.NAME = KEYS.IXNAME AND IDXS.CREATOR = KEYS.IXCREATOR AND IDXS.TBNAME = 'FOOBAZ' AND IDXS.TBCREATOR = 'FOO... 13 Jan 2006 06:04

Regarding MTK
Greetigs, I just came to know that MTK does not migrate "RULES" object from Sybase. Is this true? if yes, whats the workaround? Any help will be appreciated TIA ... 9 Dec 2005 09:19

db2 load with named pipe gives sql3025n error
Hi, The system is Windows XP and DB2 v8.1.7. I'm trying to load a text file via named pipe into a table. I have two programs: the first program creates the named pipe, waits for a client and writes the text file into the named pipe. the second program is doing the db2Load() call. Unfortunately, db2 gives... 23 Nov 2005 03:30

Concatenation
Is it not valid to use concatenation in a WHERE ... LIKE clause? SELECT iam0.g_itemId FROM g2_ItemAttributesMap AS iam0, g2_ItemAttributesMap AS iam1 WHERE iam1.g_parentSequence LIKE iam0.g_parentSequence || iam0.g_itemId || '/%' SQL0440N No authorized routine named "||" of type "FUNCTION... 11 Nov 2005 23:25