Unanswered: Queries failing sometimes with SQL0433N on db2 10.5 and running on db2 9.5
We have two setups one is on db2 9.5 and one is on db2 10.5.
There is one insert queries having union of sub selects is failing some times in 10.5 with an error SQL0433N (values too long) and the same is running successfully in db2 9.5.
SETUP DB2 9.5 fp 4
OS : AIX 6.1
SETUP DB2 10.5 fp2
OS : AIX 6.1
Has someone else faced/resolved this issue earlier or can give an hint of the problem.
if you would be more specific and provide some more data/facts, someone could give you some hints/ideas ..
what is going on ? what are you doing exactly ? what is the complete message ? what has been recorded in diag ???
this is a typical entry : I have a problem - please resolve ? yes, provide me userid/pw of instance owner and I will logon and have a look and ship you the invoice later..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be