View previous topic :: View next topic
|
Author |
Message |
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
I am trying to insert a row in a production table using a job which I have tested it in test region where it worked.
In Test region execution everything works fine
In Production also i am getting SQL code as 0 and SQl state also as 0 but rows are not inserted correctly.
Can anybody faced similar kind of issue.
IKJ56644I NO VALID TSO USERID, DEFAULT USER ATTRIBUTES USED
RESULT OF SQL STATEMENT:
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE
DSNT416I SQLERRD = 0 0 1 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000001' X'FFFFFFFF' X'000
INFORMATION
SUCCESSFUL INSERT OF 1 ROW(S) |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
but rows are not inserted correctly. |
would you like to elaborate on that remark?
Quote: |
IKJ56644I NO VALID TSO USERID, DEFAULT USER ATTRIBUTES USED |
do you have a problem with the above informational message? |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
No I have just copied all the message from the job. Rows are not inserted into table. But return code and sqlcode , sqlstate are looking good. I am not able figure out why it was not updated correctly to table. but i don;t know how it works in test.
Thanks,
Venkatraman B. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
SUCCESSFUL INSERT OF 1 ROW(S) |
somewhere (a particular DB2), someplace (a particular db2 table)
a row was inserted
you can't find it, so you assume DB2 has made some kind of error.
you are not being very helpful with your responses.
you have posted twice to tell us that - a job was run with somekind of utility/program
- to insert a row someplace
- and since you can't find the row, you figure the system has made an error
you need to elaborate or you will continue to receive the same kind of responses. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
maybe a rollback afterwards ? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I suspect the insert may have happened in some "other" subsystem or table . . . . |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
venkatatcts wrote: |
Hi,
I am trying to insert a row in a production table using a job which I have tested it in test region where it worked.
In Test region execution everything works fine
In Production also i am getting SQL code as 0 and SQl state also as 0 but rows are not inserted correctly.
Can anybody faced similar kind of issue.
IKJ56644I NO VALID TSO USERID, DEFAULT USER ATTRIBUTES USED
RESULT OF SQL STATEMENT:
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE
DSNT416I SQLERRD = 0 0 1 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000001' X'FFFFFFFF' X'000
INFORMATION
SUCCESSFUL INSERT OF 1 ROW(S) |
How are your tables qualified? Do you have RACF on your system? |
|
Back to top |
|
|
bputhirakond
New User
Joined: 22 Sep 2008 Posts: 1 Location: Chennai
|
|
|
|
If the Insert is successful, there is a reason could be selecting a subsystem / schema name is wrongly while selecting the production table.
Many systems have diff schema name for Test and Production. So, better to use correct schema name while selecting the table. |
|
Back to top |
|
|
|