JR32721: IMPORT OF DB2 TABLE DEFINITION RESULTS IN A BLANK SCHEMA OWNER

APAR status

• Closed as program error.

Error description

• Import odbc table definitions from DB2 7.2 on AIX 5.3  leaves
  the creator blank which causes the sql builder to fail
  

Local fix

• export the table definitions to *.dsx file, then open the dsx
  file - Look for
  
  
  DataSchema(Creator)=\"\" and replace it with the proper value.
  
  Then import the dsx back in.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Import odbc table definitions from DB2 leaves the creator blank.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Import odbc table definitions of table type other than 'TABLE'
  from DB2 leaves the creator blank which causes the sql builder
  to fail.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR32721
  This fix is included in 8.1 FP1
  ****************************************************************
  

Problem conclusion

• Resolution was to correct the DSRMetaGeta.B module to use the
  right table type when retrieving owner from SQLTables.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R810 PSY

     UP