DB2

OSERR : 5 "Access is denied."
I get this message in the db2diag.log. 2008-04-01-10.41.37.174000+120 E13321H539 LEVEL: Error (OS) PID : 3528 TID : 144 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : XDKD01 APPHDL : 0-3541 APPID: 139.108.97.170.43026.0804010841 ED... 1 Apr 2008 19:01

Get current SQL for a job
New to the group so go easy on me : ) I am trying to determine the best way to get the current SQL for a job. I have tried using the API QUSRJOBI with format JOBI0900 and I have also tried using the tool in iSeries Navigator titled "Current SQL for a job" but after several reviews of the data that I get back, i... 22 Jan 2008 08:28

AIX DB2 Version
After doing some googling for the error below, it seem to be that this error pertains to db2 v8.2 or 8.1. 2008-01-10-10.10.36.579007-360 I16865488A285 LEVEL: Severe PID : 160024 TID : 1 PROC : db2fmp (C) 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, common commu... 15 Jan 2008 00:09

Product / license for z/OS Universal Driver on clients
I apologize if this is available in a FAQ somewhere. My question is this: The DB2 Universal Driver jars are shipped with DB2 for z/OS (db2jcc.jar and db2jcc_license_cisuz.jar). If a developer wants to use these on his workstation (for type-4 connections), does the license allow you to download them and use th... 15 Jan 2008 15:42

db2_evaluncommitted , db2_skipinserted and db2_skipdeleted
Hi I was wandering if someone has seen a bad side of using one of these parameters ? Amy performance problem ? Since with db2_evaluncommitted, db2 evaluates the where clause before locking, I was thinking that may cause a performance degradation. thanks Stephane ... 10 Jan 2008 06:29

Any body could help me out on DB2 stored procedure on Z/OS
db2 wrote: Hi, I have heard that stored procedure on Z/OS can be written on assembler language only. This is not correct. You can use pretty much any of the common languages these days. Have a look at the manuals: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.sq... 10 Jan 2008 00:55

The column name as com.ibm.db2.jcc.b.dc@1d5b3a
Hi, I tried to generate the query plan for a query using a tool called Aqua Data Studio. It showed the explain plan and showed that a particular scan on a particular table was taking a long time. It showed the tablename correctly but showed the column name as "com.ibm.db2.jcc.b.dc(a)1d5b3a" Can somebody explai... 8 Jan 2008 13:56

Sinking Feeling
2803stan(a)gmail.com wrote: On Dec 17, 9:13 pm, Serge Rielau <srie...(a)ca.ibm.com> wrote: Mark A wrote: Is 9.5 GA yet? Hmpf! If not, the DB2 Express-C version should probably be considered beta code. Even if it is GA, any problems with the free version of DB2 Express-C version should be... 27 Dec 2007 11:09

WBI Monitor
hi guys, there are some files residing in the path /usr/opt/WBI Monitor/ EventQueueDBContainer like rw------- 1 db2inst1 db2grp1 12288 Nov 26 09:18 SQL00003.INX -rw------- 1 db2inst1 db2grp1 4096 Nov 26 09:18 SQL00003.DAT -rw------- 1 db2inst1 db2grp1 4096 Nov 26 09:18 SQL00002.DAT -rw... 9 Dec 2007 23:56

DSNREXX and RXD2 from BMC mainview - coding difference
In RXD2 I can signon to the local DB2 subsystem and then from there I can connect to DB2 subsystems on other LPARs: ADDRESS DB2 "SIGNON DB2C" < local DB2 ADDRESS DB2 "CONNECT DB2P" < remote System In DSNREXX there seems to be no signon command. So how do I signon to the local DB2 sub... 10 Nov 2007 08:22