Hi,
Iam a very new joinee to this form.Iam looking for some help here in DB2UDB version 9 database and IBM datastage
I see a lot of messages in diaglog relating to rebuild of index on a table
2008-05-27-00.47.47.390489+360 E27539813A471 LEVEL: Warning
PID : 630884 TID : 1 PROC : db2agent (MBDAP_QA) 0
INSTANCE: db2inst2 NODE : 000 DB : MBDAP_QA
APPHDL : 0-156 APPID: *LOCAL.db2inst2.080526184700
AUTHID : DB2INST2
FUNCTION: DB2 UDB, data management, sqldBeginIndexCreate, probe:1
MESSAGE : ADM5540W Beginning index rebuild of "2" index(es) on table "ODS
.BENEFIT_PACKAGE".
2008-05-27-00.47.47.405836+360 E27540285A501 LEVEL: Warning
PID : 630884 TID : 1 PROC : db2agent (MBDAP_QA) 0
INSTANCE: db2inst2 NODE : 000 DB : MBDAP_QA
APPHDL : 0-156 APPID: *LOCAL.db2inst2.080526184700
AUTHID : DB2INST2
FUNCTION: DB2 UDB, data management, sqldIndexCreate, probe:1
MESSAGE : ADM5541W Rebuilding index with IID "1" in object with ID "67" and
table space ID "5" on table "ODS .BENEFIT_PACKAGE".
2008-05-27-00.47.47.406733+360 E27540787A501 LEVEL: Warning
PID : 630884 TID : 1 PROC : db2agent (MBDAP_QA) 0
INSTANCE: db2inst2 NODE : 000 DB : MBDAP_QA
APPHDL : 0-156 APPID: *LOCAL.db2inst2.080526184700
AUTHID : DB2INST2
FUNCTION: DB2 UDB, data management, sqldIndexCreate, probe:1
MESSAGE : ADM5541W Rebuilding index with IID "2" in object with ID "67" and
table space ID "5" on table "ODS .BENEFIT_PACKAGE".
2008-05-27-00.47.47.605987+360 E27541289A478 LEVEL: Warning
PID : 630884 TID : 1 PROC : db2agent (MBDAP_QA) 0
INSTANCE: db2inst2 NODE : 000 DB : MBDAP_QA
APPHDL : 0-156 APPID: *LOCAL.db2inst2.080526184700
AUTHID : DB2INST2
FUNCTION: DB2 UDB, data management, sqldEndIndexCreate, probe:1
MESSAGE : ADM5542W Index rebuild of index(es) on table "ODS
.BENEFIT_PACKAGE" completed successfully.
I do not know why this happens.But when i try to run a job from datastage which would load data into the above table i get the following error
eason code "7" on table "ODS.BENEFIT_PACKAGE"
so i try to reorg the table and even after that i get the same error.
Can someone help me with this?
regards,
paddy