A fix is available
APAR status
Closed as new function.
Error description
THIS PTF ADDS THE FOLLOWING FEATURES: 1) Support for "As IDENTITY" clause in CREATE TABLE column DDL 2) Support for check constraints 3) Support for distinct type name generation in CREATE TABLE column DDL 4) Adds condition code checking in generated recovery JCL This PTF addresses the following problems: 1) Fixes incorrect error message that was displayed when an invalid response was entered on "Save LAT File?" and "Save DDL?" panels 2) Fixes problem where pop-up panel size remained in effect following attempt to execute saved DDL option using a PDS with a non-80 byte LRECL; an error message is now produced if DDL PDS LRECL <> 80 3) Fixes NOP upon entering an "F" or "J" on ISPF command line 4) Fixes panel display error when backing out of a restore job for DB2 aliases. 5) Fixes insufficient region size by adding a "REGION=4M" clause in the DSN1COPY steps of the recovery JCL generated by AUO. 6) Fixes problem where literal string was not being preceded by a "'" for default values for Graphic column types in recovery DDL 7) Fixes extraneous comma produced on generation of DSN1COPY parms for segmented tablespace recovery 8) Fixes problem where literal (hex) string was not being preceded by an "X" for specified default values in recovery DDL 9) Removes extraneous "G" from recovery DDL for tables defined with Graphics columns defined as "WITH DEFAULT" and no specified value assigned to the default 10) Add warning message "Single table recovery for segmented tablespace not yet allowed" upon attempt to recover a dropped table that existed in a segmented tablespace. 11) Fixes error where recovery DDL for tablespaces (and subordinate objects) is duplicated when recovering a database or tablespace
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 Object Restore Users * **************************************************************** * PROBLEM DESCRIPTION: THIS PTF ADDS THE FOLLOWING FEATURES: * * * * * * 1) Support for "As IDENTITY" clause * * in CREATE TABLE column DDL * * 2) Support for check constraints * * 3) Support for distinct type name * * generation in CREATE TABLE column * * DDL * * 4) Adds condition code checking in * * generated recovery JCL * * * * This PTF addresses the following * * problems: * * * * 1) Fixes incorrect error message that * * was displayed when an invalid * * response was entered on "Save * * LAT File?" and "Save DDL?" panels * * * * 2) Fixes problem where pop-up panel * * size remained in effect following * * attempt to execute saved DDL option * * using a PDS with a non-80 byte * * LRECL; an error message is now * * produced if DDL PDS LRECL <> 80 * * * * * * 3) Fixes NOP upon entering an "F" or * * "J" on ISPF command line * * * * * * 4) Fixes panel display error when * * backing out of a restore job for * * DB2 aliases. * * * * 5) Fixes insufficient region size by * * adding a "REGION=4M" clause in the * * DSN1COPY steps of the recovery JCL * * generated by AUO. * * * * 6) Fixes problem where literal string * * was not being preceded by a "'" * * for default values for Graphic * * column types in recovery DDL * * * * * * 7) Fixes extraneous comma produced on * * generation of DSN1COPY parms for * * segmented tablespace recovery * * 8) Fixes problem where literal (hex) * * string was not being preceded by an * * "X" for specified default values in * * recovery DDL * * * * 9) Removes extraneous "G" from * * recovery DDL for tables defined * * with Graphics columns defined as * * "WITH DEFAULT" and no specified * * value assigned to the default * * * * 10) Add warning message "Single table * * recovery for segmented tablespace * * not yet allowed" upon attempt to * * recover a dropped table that * * existed in a segmented tablespace. * * * * 11) Fixes error where recovery DDL for * * tablespaces (and subordinate * * objects) is duplicated when * * recovering a database or * * tablespace * * * **************************************************************** * RECOMMENDATION: * **************************************************************** Code changes have been made to add the new function and correct the errors.
Problem conclusion
Temporary fix
Comments
APPLY PTF
APAR Information
APAR number
PQ55895
Reported component name
DB2 OBJECT REST
Reported component ID
5655E7201
Reported release
120
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2001-12-13
Closed date
2002-03-12
Last modified date
2002-05-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UQ63998
Modules/Macros
AUO$DDDL AUO$DOPT AUO$DPAN AUO$DPTB AUO$JUMP AUO$LATR AUO$MAIN AUO$REST AUO$SLAT AUO$SRES AUO#ANGN AUO#BIND AUO#CCGN AUO#DDL AUO#DDL2 AUO#TBGN AUO#TBUL AUO#TVGN AUO#WRDC AUO@DSQL AUO@FRAN AUO@FRIK AUO@IOTB AUO@RDDL AUO@RECV AUOBTSO AUODSNL AUODSNT AUODSNU AUODSN1 AUORECI AUO05 H23L120J
Fix information
Fixed component name
DB2 OBJECT REST
Fixed component ID
5655E7201
Applicable component levels
R120 PSY UQ63998
UP02/04/25 P F204
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"120"}]
Document Information
Modified date:
18 March 2021