JR31484: "PROCESS META DATA NOT AVAILABLE IN DATABASE" IS ALWAYS PUT IN A JOB LOG FROM ODBC EE/NETEZZA STAGE

APAR status

• Closed as program error.

Error description

• Following log message is always put when a job which has ODBC
  EE/Netezza stage to access Netezza database is launched.
  "ODBC_Enterprise_1: Process meta data not available in database"
  
  In addition, when this message is put in a job log, following
  message is put in a database log.
  "ERROR:  Relation 'METASTAGE_LOC_INFO' does not exist".
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All platforms
  ****************************************************************
  PROBLEM DESCRIPTION:
  Warning message related to Process Metadata displayed when
  MetaStageLoc_Info table not present in database
  ****************************************************************
  RECOMMENDATION:
  Apply patch for JR31484.
  The fix has been included in the IS 8.1 FP1. Apply the FixPack1
  for IS 8.1.
  ****************************************************************
  

Problem conclusion

• Add env variable DS_NO_PROCESS_METADATA to control collection
  ofmetadata and hence avoid warning messages related to Process
   Metadata not found
  

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

• ODBC EE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP