DB2 Connector error:EXECUTE or OPEN stat is large
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Tue Nov 30, 2010 10:51 am
DB2 Connector error:EXECUTE or OPEN stat is large
Hi All,
I facing a strange issue in DataStage.
My job fails due to following error
[IIS-CONN-DB2-000004] DB2 function SQLExecute failed: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
This is happen during when i ran my job in main sequence[4 other jobs rans in parallel].
When i ran only the particular sequence for this job,it works fine. I talked sysdba about this thing, they said there is nothing wrong at that time.
Do you have any clue,how i can resolve this issue?
I facing a strange issue in DataStage.
My job fails due to following error
[IIS-CONN-DB2-000004] DB2 function SQLExecute failed: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
This is happen during when i ran my job in main sequence[4 other jobs rans in parallel].
When i ran only the particular sequence for this job,it works fine. I talked sysdba about this thing, they said there is nothing wrong at that time.
Do you have any clue,how i can resolve this issue?
-
- Participant
- Posts: 37
- Joined: Tue Nov 30, 2010 10:51 am
-
- Participant
- Posts: 37
- Joined: Tue Nov 30, 2010 10:51 am
Hi ArndW,
Yes . It is a staging table. I am using before job sub routine and calling a unix script to truncate table . After running the job i am facing this issue. I am following same rule other 30 tables and it is working fine. Same unix script is used for all other jobs. If i run it manully it is working fine but if i schedule it iam getting this error DB2 function SQLExecute failed: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001.. Please help.
Yes . It is a staging table. I am using before job sub routine and calling a unix script to truncate table . After running the job i am facing this issue. I am following same rule other 30 tables and it is working fine. Same unix script is used for all other jobs. If i run it manully it is working fine but if i schedule it iam getting this error DB2 function SQLExecute failed: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001.. Please help.
-
- Participant
- Posts: 37
- Joined: Tue Nov 30, 2010 10:51 am
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
This error normally occurs when you try to store a value in a column whose datatype is lesser than the original value.
Also whenever your data contains junk value and if its length is greater than the column datatype, you will get the above said error.
The only solution for this sort of error is to increase the column datatype size.
This type of error normally occurs is String fields, specifically in columns with descriptive value like NAME, ADDRESS, LOCATION, DESCRIPT etc.
You might have a column where you store descriptive data.
First you have to identify the column then ask your DBA to increase the datatype length, then modify the job accordingly and rerun.
Kindly check the below link
http://pic.dhe.ibm.com/infocenter/dzich ... 2Fn302.htm
Also whenever your data contains junk value and if its length is greater than the column datatype, you will get the above said error.
The only solution for this sort of error is to increase the column datatype size.
This type of error normally occurs is String fields, specifically in columns with descriptive value like NAME, ADDRESS, LOCATION, DESCRIPT etc.
You might have a column where you store descriptive data.
First you have to identify the column then ask your DBA to increase the datatype length, then modify the job accordingly and rerun.
Kindly check the below link
http://pic.dhe.ibm.com/infocenter/dzich ... 2Fn302.htm
Thanx and Regards,
ETL User
ETL User
-
- Participant
- Posts: 37
- Joined: Tue Nov 30, 2010 10:51 am