PK72445: NATIVE STORED PROCEDURES SUPPORT NFDB29

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Native Stored Procedures support for DB2 9.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare and Change           *
  *                 Management working with native SQL           *
  *                 procedures ( NSP's )                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Additional support for comparing native *
  *                      SQL procedures ( NSP's )                *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Additional support for comparing native SQL procedures (NSP's).
  

Problem conclusion

Temporary fix

Comments

• NSP support in the DB2 Object Comparison Tool for z/OS is being
  incrementally improved.
  
  Please note,  currently,  the target for the compare must be the
  active  version  of the NSP  as  support for  comparing inactive
  versions will  be added in the future.   The result of comparing
  the two NSP's is that the source version will replace the active
  version on the target.  There can be multiple versions on source
  and target specified.  OC will process  only the active  version
  from  the source by comparing it to versions from the target and
  generating  the  appropriate  SQL  statements  ( could  be ALTER
  REPLACE or ALTER ADD + ACTIVATE or ALTER PROCEDURE ALTER ...).
  
  Note. PK72445 includes the  following 3 APARs fixes.
       - PK58018, PK84929, PK88790
  
  
  o.PK58018
  USERS AFFECTED
  Users of Object Compare and Change
  Management working with native SQL
  Procedures ( NSP's ).
  
  PROBLEM DESCRIPTION
  Additional support for comparing native
  SQL procedures ( NSP's ).
  
  RECOMMENDATION
  Apply The PTF.
  
  PROBLEM SUMMARY
  Additional support for comparing native SQL procedures( NSP's ).
  
  PROBLEM CONCLUSION
  NSP support in the DB2 Object Comparison Tool for z/OS is being
  incrementally improved.
  
  o.PK84929
  USERS AFFECTED
  Users of Object Compare.
  
  PROBLEM DESCRIPTION
  Run WSL generates duplicate UNLDDN
  keyword for UNLOAD.
  
  RECOMMENDATION
  Apply The PTF.
  
  PROBLEM SUMMARY
  Run WSL generates  duplicate UNLDDN keyword for UNLOAD.
  Also, when the "Changes file data set name" input field
  on OC panel GOC5 is specified,
  the TU command does not display Template Usage panel ADB25TU3
  panel at times.
  
  PROBLEM CONCLUSION
  Incidents are now resolved.
  
  o.PK88790
  USERS AFFECTED
  Users of Object Compare using encoding
  scheme ignores.
  
  PROBLEM DESCRIPTION
  In  DB2 Admin and Object Compare Tools,
  many  DB2   objects  are   dropped  and
  recreated  due to differences  in CCSID
  value stored in DB2 catalog as Encoding
  scheme.  IGNORE actions fails to ignore
  the differences found.
  
  RECOMMENDATION
  Apply The PTF.
  
  PROBLEM SUMMARY
  IGNORE actions for encoding scheme fails to ignore the
  differences found.
  
  PROBLEM CONCLUSION
  The problem has been fixed.
  

APAR Information

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

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

  UK48695

Modules/Macros

•    GOCCIF   GOCDB2   GOCGAJOB GOCTUNL  GOC2CMF
  GOC2CMP  GOC2CMR  GOC2CMS  GOC2CMT  GOC2DTC  GOC2IGN  GOC2LCC
  GOC27AC  GOC5     H25G720J
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK48695

     UP09/07/31 P F907

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.