A fix is available
APAR status
Closed as program error.
Error description
When copying DB2 data using FM/DB2 Copy Utility (option 3.3), receive SQLCODE -530. Edit copy options 'Use uncommitted read', 'Ignore ALL Duplicates', and 'Ignore referential integrity errors' are selected.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: In the FM/DB2 copy utility the option: * * 'Ignore referential integrity errors' * * is not working. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The intention of the 'Ignore referential integrity errors' option is to allow any row that generates an SQLCODE-530 on insert (update) of the target DB2 object to be ignored. This option is not working - any SQLCODE-530 error results in the copy operation being terminated.
Problem conclusion
File Manager DB2 component has been updated to correct the problem. The option description has been changed to better reflect the option's function. When the option is selected, any SQLCODE-530 or SQLCODE-545 errors will be ignored. --------------------------------------------------------- Publication Closing Code: DEVCHNG For the documentation changes associated with this APAR, please refer to: ftp://ftp.software.ibm.com/software/websphere/awdtools/ filemanager/fmv10apar.pdf The changes are to the following publications: PUB ID PUB NAME ------------ ---------------------------------------- SC19-2858-00 File Manager for z/OS V10R1 User's Guide and Reference for DB2 Data The latest published manuals can be found at: http://www.ibm.com/software/awdtools/filemanager/library/ index.html.
Temporary fix
Comments
APAR Information
APAR number
PM20620
Reported component name
FILE MANAGER ZO
Reported component ID
5655V5200
Reported release
A12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-08-18
Closed date
2011-02-01
Last modified date
2011-03-02
APAR is sysrouted FROM one or more of the following:
PM20660
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL FMN2LVLJ FMN2LVLK
SC19285800 |
Fix information
Fixed component name
FILE MANAGER ZO
Fixed component ID
5655V5200
Applicable component levels
RA1B PSY UK64394
UP11/02/04 P F102
RA12 PSY UK64403
UP11/02/04 P F102
RA13 PSY UK64434
UP11/02/04 P F102
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
02 March 2011