DSXchange

Hi

Currently I am inserting data into DB2 from dataset file which is created in perious job and i am getting following errors

Target_table: Schema field xxx_ID in input data set 0 not present in design time information. Extended field properties for this field will not be available.

Target__Table: Schema field xxx in input data set 0 not present in design time information. Extended field properties for this field will not be available.

Target__Table: DB2 function SQLFetch failed: SQLSTATE = HY000: Native Error Code = -1,042:
Msg = [IBM][CLI Driver][DB2/NT] SQL1042C An unexpected system error occurred.
SQLSTATE=58004 (CC_DB2Connection::queryServerHostName, file CC_DB2Connection.cpp, line 3,070)


I think it is issue with data files....
Also how can i clean up all the dataset files in server for PX 8,5 jobs

It may be because of RCP??

DS User

Hi

Every day we get this error ,some times we restart the datastage box it fixes this issue...

I jusy want to know how to fix this issue completly ..

is this a DB2 issue or datastage issue ...

please share your views...

To clean up datasets, go under the menu (Tools, perhaps) for Dataset Management and delete using that interface.

The DB2 errors given may indicate DB2 has a problem. To narrow it down, next time you get the error and before you restart the DataStage server, I would suggest running a same insert into the same DB2 table manually from outside of DataStage by using a DB2 client or Toad for DB2 from your PC.