Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2010
    Posts
    21

    Exclamation Unanswered: Queries failing sometimes with SQL0433N on db2 10.5 and running on db2 9.5

    Dear All,
    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.

    Regards,
    Harsh

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Do you have exactly the same DDL and data being inserted into this table in both databases?
    Do you have the same database codepage in both databases?
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •