DB2

DB2 Express - cannot create database!
I just installed the free DB2 Express. I am going through the wizard and I am unable to create a database. I keep getting the error "create database path does not exist". The log file says "An attempt is made to create a database on a path without first enabling this feature using db2_create_db_on_path registry var... 25 Apr 2007 23:51

ASUTIME?
I am trying the execute and admittedly large SQL query against our DB2 database. The query pasted into MS-Word has 2800 words, 21000 characters (w/o spaces), 26000 (w/ spaces) and 1000 lines. There are UNION ALLS, and subqueries LEFT JOINing to other subqueries. That said, when it runs, I get a message that says: ... 26 Apr 2007 06:13

VERITAS netbackup failed on AIX DB2
After setting the netbackup, it is found that there is below error. SQL2062N An error occurred while accessing media "/usr/openv/netbackup/bin/nbdb2.sl". Reason code: "513" DB version: v8 FP14 Instance width: 32-bit Netbackup client: NetBackup-DB2-AIX5 5.1MP5 Does anyone have any suggestion or solution? ... 17 Apr 2007 00:50

SQL0954C Not enough storage is available in the application heapto process the statement. SQLSTATE=57011
Justin wrote: We bumped the app heap size to 12 K and it works. Not satisfied with the change - but liveable. Works fine db2 v 8 operating under only 4K. Testing db2 v9 fix pack 2 - starting today. Not sure if we will come across similar problems. I'm no expert on that topic, but I'd look into db2... 13 Apr 2007 11:55

SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
Recieved the message: SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011 After viewing other posts, they recommended changing the applheapsz (which was completed). We have restarted DB2. The query is not too complex. The interesting point is that we r... 10 Apr 2007 15:50

DB2 and REXX
Hi all, I am a little puzzled.. I am trying to make some insert into an DB2 using SQLEXEC and it just does not work... code looks like that: /* // Initialize SQLEXEC interface */ parse version rexxType . parse source platform . trace 'o' if platform == 'AIX/6000' & rexxType == 'REXXSAA' then do rcy = SysA... 11 Apr 2007 05:50

Strange query
I was getting snapshot since the database was responding very slow...here is the query that was in a snapshot: WITH TYPEINTS ( TYPEINT, COLTYPE ) AS ( VALUES ( SMALLINT(1 ), CHAR( 'INTEGER', 8) ), ( SMALLINT (2 ), CHAR( 'SMALLINT', 8) ), ( SMALLINT(3 ), CHAR( 'BIGINT', 8) ), ( SMALLINT(4 ), CHAR( 'REAL' ,... 11 Apr 2007 06:21

PROBLEM WITH JUNK CHARECTER
Hello all, i have a column in a table which stores tag lines which are usually less than 500 charecter. when we display the data through the browser some character display as "boxes" or junks. i predict it may be the newline or carriage return character. is there any function so that i can ward of these charact... 3 Apr 2007 13:16

Help
¿¿¿¿¿¿Anybody knows this error?????? 2007-03-23-11.08.12.484581 Instance:db2inst1 Node:000 PID:204782(db2agent (DB2XXX)) Appid:*LOCAL.db2inst1.070323232921 data_management sqldmdpi Probe:443 Database:DB2XXX DIA9999E An internal error occurred. Report the following error code : "0xFFFF8544". 2007-03... 25 Mar 2007 18:31

SQL0437W reason code 3, anything to worry about?
While investigating deadlocks in an application I wrote a function to check if there where any batchjobs running in parallell at the time of the deadlocks. The check runs surprisingly fast, but If I narrow the searchspace I start getting SQL0437W with reason code 3 "Optimizer cost underflow". Statistics are u... 22 Mar 2007 16:31