IC85693: DBIMPORT FAILS WITH PREPARE SQLOBJ -201 ERROR

APAR status

• Closed as program error.

Error description

• dbimport fails with prepare sqlobj -201 error   on a  huge
  database with many tables Stored Procedures etc.
  

Local fix

• Dbexport created bad syntax for a database object. Dbimport
  should be failing with a 201 error on the object directly above
  the error in the output file ( dbimport.out ). Check and correct
  the syntax of that object in the
  databasename.exp/databasename.sql file and rerun the dbimport.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC6                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC6
  

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels