DB2

primary key index?
I have added primary key to my table using the 'ALTER TABLE' statement. Now, is it mandatory for me to use the 'CREATE UNIQUE INDEX' on primary key columns in order to enforce the primary key constraint? I have a vague idea that unique indexes are automatically created when we specify the primary key constraint. C... 17 May 2006 19:43

JDBC error
Hello, I'm trying to connect to DB2 Express-C for Linux using the JDBC Universal Driver and I get the error below. I thought it was my code then I installed Websphere Community Edition 1.0.0.1 and I'm now using the IBM JDK 1.4.2. I wasn't planning to work directly with Websphere but just wanted to try a differen... 7 May 2006 03:15

Index Naming Standards
Hi all, I need a proper index naming standard for my database (datawarehouse). This is what I have thought so far: Table name: TGL_MTR_VHCL Index name: XGL_MTR_VHCL I am just replacing a 'T' for table with a 'X' for an index. But the problem occurs when there are multiple indexes on the same table. How... 18 Apr 2006 13:00

Calling SYSPROC.DB2LOAD within SQL stored procedure
Hi: How can one call SYSPROC.DB2LOAD procedure within a SQL stored procedure. I get the following error: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0418N A statement contains a use of a parameter ma... 7 Apr 2006 19:57

Blocking Agent ID for Locks in SNAPSHOT_*
Hi, I am trying to find a way to query for the (lock) blocking connection on my DB2 server. I am using DB2 for LUW 8.1 and 8.2. I have two connections, one which has an exclusive lock, and the other which is being blocked by the connection with the exclusive lock. I want to be able to query for the locks on t... 5 Apr 2006 22:13

Catalog Database
Hi , I want to catalog a database and I have the follwoing information with me. Node name = abcdef Comment = Protocol = TCPIP Hostname = abcdef.portsmouth.uk.ibm.com Service name = 5912 I hav... 6 Apr 2006 00:47

Alter Column
Hi, I'm trying to change a column on a DB2 table so that it has a default value but I cannot get it to work. Does anyone have any experience in this area. I'm trying with this statement: Alter Table x Alter column y default 0; I also tried with this: Alter Table x Alter Column... 31 Mar 2006 09:05

SQL1224N - A database agent could not be started to service a request
Env : DB2 UDB 8.2, AIX 5.3, Ascential Datastage (DS) DS jobs are used to process the backend DB2 database. Sometimes DS job fails with the message APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a r... 27 Mar 2006 20:51

NULLID.SYSSN300
Can anyone please help me and explain: [24/03/06 11:22:28:212 EST] 3e70982f WSRdbDataSour I DSRA8203I: Database product name : OS2 [24/03/06 11:22:28:332 EST] 3e70982f WSRdbDataSour I DSRA8204I: Database product version : DB2 UDB 6.1 [24/03/06 11:22:28:332 EST] 3e70982f WSRdbDataSour I DSRA8205I: JDBC drive... 27 Mar 2006 01:28

Exporting current system timestamp to unix server
Hi all, Im trying to extract db2 server current system timestamp from unix shell script. So from shell script call the export command " db2 export to curdate.txt of del modified by chardel' ' select current timestamp from sysibm.sysdummy1". when i run the script im getting error curdate.txt file or directory... 22 Mar 2006 13:49