DSNT404I SQLCODE = 162,

jajularamesh · New User Joined: 21 Nov 2005 Posts: 10

ALTER TABLE EMPLOYEE2 ADD CONSTRAINT CON_DEPT FOREIGN KEY (DEPTNO) REFERENCES DEPT2(DEPTNO);
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT404I SQLCODE = 162, WARNING: TABLE SPACE DBTCHN03.TS001 HAS BEEN PLACED IN CHECK PENDING DSNT418I SQLSTATE = 01514 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXICRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 20 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000014' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

nikyojin · Active User Joined: 05 Oct 2005 Posts: 88

Hi,
When adding a foreign key to an existing table , SQLCode 162 is returned. DB2 places a table space into CHECK PENDING state if:

1)Any table in that table space has ever been populated at any time.
2)A foreign key is added or modified for any table in the table space.

The library server performs and commits the foreign key creation. However, a warning message is written to the library server log to remind you to run the CHECK DATA DB2 utility so that tables and views in this table space can be accessed.