Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 2 August 2023
DB2 Object Restore Version 2.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH10993
18_Jul
2019
UI64272


ABEND 0C4 IN REPOSITORY UPDATE JOB
PI80067
15_May
2017
UI47248


COMMAND 'AUO$MAIN' ABENDED WITH CODE 806000. LOAD MODULE NOT FOUND.
PI73881
13_Mar
2017
UI45512


PROVIDE SUPPORT FOR DB2 V12
PI66134
27_Dec
2016
UI43577


ERROR MESSAGE ALAA021E MAY OCCUR WHEN GENERATING RECOVERY JCL
PI56734
12_May
2016
UI37807


ABEND U0016 WHEN RUNNING OBJECT RESTORE VR UPDATE
PI50815
23_Feb
2016
UI35576


AUO#UTIL - AUO#VRUB MODULE ERROR DETECTED RESULTING IN ABEND0C1
PI22906
11_Sep
2014
UI21282


FEC801E PGM: AUO$SCR8 - SQLCODE180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE *N IS INVALID
PI10337
24_Feb
2014
UI15411


IEW2140E 0962 SYMBOL CONTAINS ONE OR MORE INVALID CHARACTERS. 14/01/24 PTF
PECHANGE
PM98603
7_Nov
2013
UI12280
PI10337

UNABLE TO GENERATE RECOVERY DDL FOR LOB OBJECTS.
PM86825
22_Oct
2013
UK98709


DB2 V11 TOLERATION PTF
PM90544
1_Aug
2013
UK96367


ABEND0C1 IN AUO#UTIL MAY OCCUR WHEN WRITING TO OUTPUT AFTER SQL ERROR.
PM72426
7_Nov
2012
UK83309


OPTION "S" ON IMAGE COPY LIST PANEL ( AUO$D8SC ) NOT CORRECTLY PROCESSED.
PM58828
15_Mar
2012
UK77091


SQLOUT FAILS BECAUSE A RESERVE CHARACTER IN DATA VALUE.
PM48925
3_Nov
2011
UK73528


CHANGES TO SUPPORT LOG ANALYSIS V3.3
PM15422
18_Aug
2011
UK70945


SUPPORT NEW FEATURES ADDED IN DB2 10
PM44653
18_Aug
2011
UK70946


SUPPORT NEW FEATURES ADDED IN DB2 10 (PM15422 CONTINUATION)
PM44654
18_Aug
2011
UK70947


SUPPORT NEW FEATURES ADDED IN DB2 10 (PM15422 CONTINUATION)
PM34113
27_Jul
2011
UK70209


PARTITIONING INDEX CHANGES MAY NOT BE REFLECTED IN REPOSITORY
PM31926
29_Mar
2011
UK66251


PRIQTY SECQTY GENERATED INCORRECTLY DURING DDL CREATION
PM30800
11_Feb
2011
UK64782


SYSRESAUTH NOT POPULATED AFTER MIGRATION FROM V7 TO V8
PM29298
2_Feb
2011
UK64510


PARTITIONED INDEX GENERATED INCORRECTLY.
PM25668
10_Dec
2010
UK63006


SQLCODE803 IN JOB AUO13#U8 WHEN MIGRATING FROM DB2 V7 TO V8
PM18809
11_Nov
2010
UK62120


INCORRECT DDL CREATED WHEN GENERATING SECONDARY PARTITIONED IX
PM15691
4_Aug
2010
UK59424


DBID / OBID VALUES INCORRECTLY DISPLAYED ON PANEL AUO$D8TB
PM14094
14_Jun
2010
UK57945


INCORRECT DDL GENERATED FOR TABLE CONVERTED TO TABLE PARTITIONED
PM06853
19_Apr
2010
UK56208


PROVIDE TOLERATION SUPPORT FOR ENHANCEMENTS
PM07310
22_Mar
2010
UK55469


IEA705I ERROR DURING FREEMAIN ABENDSA87 RC10 FECLINKL+5E6
PM04964
8_Mar
2010
UK54955


DB2 OBJECT RESTORE ABEND806-04 REQUESTED MODULE AUO$XBND NOT FOUND EXTERNAL SYMPTOM CODE
PM01168
21_Jan
2010
UK53730


CHANGE DB2 OBJECT RESTORE BIND DEFAULT TO EBCDIC
PK95025
18_Dec
2009
UK53033


SQLCODE -180 IN DB2 OBJECT RESTORE REPOSITORY UPDATE JOB
PK87157
29_Oct
2009
UK51568


TOLERATION APAR FOR LOG ANALYSIS TOOL INTERFACE
PK96544
29_Oct
2009
UK51568


SELECTING OPTION Q FROM MAIN MENU ON A V9 SYSTEM RESULTS IN ERROR
PK85036
30_Sep
2009
UK50643


ALLOW RECOVERY OF A DROPPED SIMPLE TABLESPACE INTO A SEGMENTED TABLESPACE IN DB2 V9
PK91796
17_Sep
2009
UK50211


AUO943E MESSAGE WHEN DEFINING A DIFFERENT UNIT TYPE IN IMAGE COPY DATASET
PK93467
24_Aug
2009
UK49520


ABENDS0C4 RC10 IN MODULE FEC@SCR1 OFFSET 0014AAE
PK86976
20_Jul
2009
UK48521


SQLCODE204 ON RESTORE BECAUSE THE IMPLICIT TS
PK87695
20_Jul
2009
UK48521


SQLCODE -805 AUO@F9XR NOT FOUND IN PLAN AUO8PLN1 WITH DB2 V9 CM
PK88025
20_Jul
2009
UK48521


LEAP SECONDS CONVERSION ERROR RESULTED IN DUPLICATE RECORDS WHENDOING A POINT IN TIME RECOVERY
PK85466
26_May
2009
UK46900


AUO OBJECT LIST FILTER PANELS WORDED INCORRECTLY
PK83555
26_May
2009
UK46900


ABEND S0C1 RC = 00000001 MAY OCCUR WHEN A DATASET IS ENQUEUED AND DB2 OBJECT RESTORE IS USING THE SAME DATASET ON ANOTHER
LPAR
PK84472
26_May
2009
UK46900


IMAGE COPY ROWS ON PANEL AUO$D8SC MAY DISPLAY INCORRECT COLORS.
PK82142
24_Apr
2009
UK46009


INVALID SQLCODE OF -811 WAS ENCOUNTERED IN MODULE AUO#TAU8 ON STATEMENT 0307
PK83263
24_Apr
2009
UK46009


AUO REPOSITORY UPDATE JOB FINISHES WITH CC=0 EVEN THOUGH AN SQLERROR OCCURS IN ONE OR MORE SUBTASKS
PK80090
24_Apr
2009
UK46009


TRIGGERS NOT GENERATED AFTER THE BASE TABLE'S ALTERED TIMESTAMP HAS BEEN CHANGED.
PK82329
24_Apr
2009
UK46009


DSNT408I SQLCODE = -331, ERROR: CHARACTER CONVERSION CANNOT BE PERFORMED
PK78781
24_Mar
2009
UK45184


SQLCODE -811 WHEN GENERATING RECOVERY JOB AT TABLE LEVEL
PK81038
24_Mar
2009
UK45184


SEQUENCE STILL HAS DROPPED STATUS OF N AFTER A SUCCESSFUL DROP
PK79111
24_Mar
2009
UK45184


ISSUING DB2 OBJECT RESTORE COMMAND "R" TRIGGERS AND VIEWS MAY NOT BE REMOVED PROPERLY
PK76225
22_Jan
2009
UK43406

HIPER

ROLLUP SUPPORT INTERNAL CHANGES TO COMMON CODE
PK76689
6_Jan
2009
UK42902


NEW OPTION TO EXCLUDE SQL UPDATES CAUSED BY A TRIGGER FOR DROPPED OBJECT RESTORE WITH SQL LOG APPLY
PK76964
6_Jan
2009
UK42902


VR UPDATE LOOP
PK73666
6_Jan
2009
UK42902


DB2 V8 DBRM'S TO BE REBUILT TO AVOID DSNT208I MSG
PK74774
6_Jan
2009
UK42902


NEW OPTION IN THE AUO VR UPDATE JOB THAT WILL ALLOW A SYSCOPY ONLY UPDATE OF THE REPOSITORY
PK75349
12_Dec
2008
UK42446


ABEND INTERCEPT WHEN GENERATING SQL USING DB2 LOG ANALYSIS TOOL V3.1 AND PK70642 IS APPLIED.
PK73837
12_Dec
2008
UK42446


OBJECTS NOT GENERATED IN RECOVERY DDL AFTER AN ALTER
PK73091
12_Dec
2008
UK42446


SQLCODE -811 WHEN GENERATING RECOVERY JOB
PK73087
27_Oct
2008
UK41098


INCORRECT CONSTRAINT IN RESTORE DDL
PK65403
30_Sep
2008
UK40342


IEA705I ERROR DURING FREEMAIN SYS CODE = 378-18
PK66781
30_Sep
2008
UK40342


DDL SEQUENCING MAYBE INCORRECT WHEN RESTORING A TABLE WITH MORE THAN ONE COLUMN ADDED WITH AN ALTER TABLE STATEMENT.
PK69733
30_Sep
2008
UK40342


DDL INCOMPLETE WHEN RESTORING VIEWS AFTER MIGRATION TO DB2 V8
PK71954
30_Sep
2008
UK40342


SQLCODE -199 ON VIEW DDL GENERATION ON V8 ENFM SYSTEM
PK71988
30_Sep
2008
UK40342


-20182 IN DDL GENERATION OF TABLE-PARTITIONING OBJECT
PK65281
10_Sep
2008
UK39736


CONSTRAINT NOT RESTORED WHEN RESTORING DB
PK67078
10_Sep
2008
UK39736


DSN1987I DSN1TRAN SP MAP PAGE CONTAINING OBID 0006 HAS NO MATCHING VALUE IN THE SYSXLAT FILE
PK67089
10_Sep
2008
UK39736


FEC801E PGM: AUO F8TC SQLCODE = -180, ERROR:
PK64882
28_Jul
2008
UK38472


INCORRECT MESSAGE AUO070E DISPLAYED WHEN ATTEMPTING TO ACCESS ROLES OBJECT LIST DISPLAY ON A V8 NFM SUBSYSTEM
PK65244
28_Jul
2008
UK38472


INCONSISTANT WILDCARDING IN TABLES FILTER
PK65268
28_Jul
2008
UK38472


USE OF A SHRLEVEL CHANGE COPY DURING RECOVERY COULD RESULT IN DATA INTEGRITY ISSUES
PK65269
28_Jul
2008
UK38472


OBJECTS NOT BEING RESTORE WHEN RELATED OBJECT ARE IN DIFFERENT TABLESPACES
PK65396
28_Jul
2008
UK38472


NON-UPDATE MODE, DELETES ARE BEING PREFORMED ON TABLES
PK65404
28_Jul
2008
UK38472


WHEN RECOVERING DROPPED OBJECTS, THE DSN1COPY STEP MAY FAIL DUE TO MISSING DD STATEMENT INFORMATION
PK65706
28_Jul
2008
UK38472


ERROR AUO005E HELP MESSAGE INVALID AFTER ENTERING COMMAND FROM DATABASE STRUCTURE DISPLAY. MESSAGE ADDED TO INCLUDE THE
PK57348
9_May
2008
UK36359


ALLOW PIT RECOVERY OF DROPPED TABLESPACE AFTER LOAD LOG YES UTILITY HAS BEEN RUN
PK58293
24_Mar
2008
UK34876


OBJECT RESTORE TOLERATION OF LOG ANALYSIS 3.1
PK57326
24_Mar
2008
UK34876


ENHANCE THE INTERFACE BETWEEN OBJECT RESTORE AND LOG ANALYSIS TOOL
PK60119
24_Mar
2008
UK34876


LEAP SECONDS CONVERSION ERROR RESULTED IN DUPLICATE RECORDS WHENDOING A POINT IN TIME RECOVERY
PK55537
7_Feb
2008
UK33526


FOREIGN KEY ON PARENT TABLE MAY NOT BE RESTORED WHEN RESTORING CHILD TABLE
PK58403
7_Feb
2008
UK33526


SQLCODE -20100 MAY OCCUR WHEN RESTORING AN OBJECT WITH A TRIGGER.
PK58432
7_Feb
2008
UK33526


MESSAGE: "IAT4404 DATASET NOT FOUND" MAY BE ISSUED BY THE RECOVERY JOB
PK55858
22_Jan
2008
UK33144


POSSIBLE ERRORS DURING MIGRATION FROM AUO REPOSITORY V7 TO V8
PK53079
12_Nov
2007
UK31141


JCLERR "FAILED BY INTERPRETER" IN DB2 OBJECT RESTORE V2.1 WITH DB2 LOG ANALYSIS TOOL V2.3 (POINT IN TIME RECOVERY).
PK54042
17_Oct
2007
UK30360


MESSAGE GIM23901E MAY BE ISSUED DURING SMP/E APPLY PROCESSING FOR MODULE AUO@FRCL
PK47842
17_Sep
2007
UK29281


LOOP DURING PGM=AUO#UTIL,PARM='VRUPDATE,DB2P' AFTER SQLCODE904
PK49071
17_Sep
2007
UK29281


FORMAT ERROR ON DBRM DISPLAY PANEL
PK51663
17_Sep
2007
UK29281


DISPLAY DROPPED N FOR ALIAS DISPLAY IS NOT WORKING PROPERLY
PK50593
17_Aug
2007
UK28354


INCORRECT DDL GENERATED WHEN PRIMARY KEY SPECIFIED
PK32516
24_Jul
2007
UK27408


DB2 V9 NEW FUNCTION EXPLOITATION
PK32515
22_Mar
2007
UK23284


DB2 V9 TOLERATION
PK34665
16_Feb
2007
UK22284


OBJECTS NOT MATCHING THE FILTER CRITERIA MAY BE INCORRECTLY ADDED TO THE REPOSITORY
PK37676
16_Feb
2007
UK22284

HIPER

LOAD LOG YES RECORDS ARE BYPASSED DURING RECOVERY
PK37704
16_Feb
2007
UK22284


ABENDS0C4 ABEND IN AUOLMD01
PK37937
16_Feb
2007
UK22284


FILTER ON MULTIPLE TABLESPACES IN VR LOAD DOES NOT LOAD ALL SPACES
PK15219
21_Dec
2006
UK20850


OBJECT RESTORE/LOG ANALYSIS 2.3 PIT RECOVERY SUPPORT AND DB2 V8 MODE DETECTION
PK32013
21_Dec
2006
UK20850


SLOW RESPONSE TIME WHEN USING OPTION IC TO DISPLAY IMAGE COPY LIST.
PK36597
21_Dec
2006
UK20850


AE PK32013
PK19104
29_Jun
2006
UK15885


SQLCODE -205 ON ALTER TABLE STATEMENT IN DB2 V8
PK20535
29_Jun
2006
UK15885


SQLCODE104 WHEN RESTORING LARGE VIEWS
PK21311
29_Jun
2006
UK15885


INCORRECT DDL GENERATED FOR TABLE WITH AN IDENTITY COLUMN
PK25882
29_Jun
2006
UK15885


SQLCODE805 FROM AUO$SCV7 IN DB2 V8 WHEN USING OPTION IC, ERRONEOUS DB2 INFORMATION DISPLAYED USING NOTS COMMAND
PK12890
9_Feb
2006
UK11629


INCORRECT DDL GENERATED FOR TABLE WITH AN IDENTITY COLUMN
PK16494
9_Feb
2006
UK11629


BIND GENERATION DIALOG GENERATING INVALID SYNTAX
PK17667
9_Feb
2006
UK11629


SQLCODE -805 WHEN USING AUO WITH DB2 V8 AND DB2 V7 SYSTEMS
PK17002
28_Dec
2005
UK10448


AUOADBI GETS SYNTAX ERROR ON LINE 128
PK15187
23_Dec
2005
UK10416


DUPLICATE JCL GENERATED IN OBJECT RESTORE AFTER APPLY OF LOG ANALYSIS PTF.
PK12884
23_Dec
2005
UK10416


LINE COMMAND "U" IN OPTION "IC" RESULTS IN IKJ567I MESSAGES
PK12889
23_Dec
2005
UK10416


CLONE -ABOUT COMMAND SHOWS LOG ANALYSIS TOOL (ALA) 1.2 INTERF
PK13528
23_Dec
2005
UK10416


SQLCODE -199 ON ALTER TABLE STATEMENT IN DB2 V8
PK15428
23_Dec
2005
UK10416


SQLCODE -805 AFTER INSTALL ON A DB2 V8 COMPATABILITY MODE SUBSYSTEM
PK08836
15_Aug
2005
UK06296


SQLCODE811 IN OPTION IC
PK08883
15_Aug
2005
UK06296


BLANKS ADDED TO TABLE NAMES IN RESTORE DDL
PK08963
15_Aug
2005
UK06296


MESSAGE AUO014E TOO VAGUE
PK09494
15_Aug
2005
UK06296


SQLCODE180 IN AUO$SCV8 IN OPTION IC ON DB2 V8 SUBSYTEM
PK08607
20_Jul
2005
UK05562


PTF UK03087 DOES NOT CONTAIN THE ++DELETE FOR AUO#LXXX
PK02335
19_May
2005
UK03658


S0C4 ABEND OCCURS IN AUO#TAG8 (PLUS FEC801E MSG + -180 SQLCODE) WHEN TABLE WITH COLUMN-LEVEL AUTHS IS SELECTED FOR RESTORE.
PK05136
10_May
2005
UK03302


THIS APAR WILL SUPERSEDE THE PTF FOR APAR PK04283 THIS WILL ALLOW SMPE FLOW AFTER PK04283
PK04283
3_May
2005
UK03087
PK08607

ABEND S0C1 U0000 REASON=00000001 WHEN RUNNING UTILITY JCL (OPTION UJ).
PK00487
8_Feb
2005
UK00382


ABEND S0C4 RC4 AT OFFSET CDA IN AUO#TBG7.
PQ99206
24_Jan
2005
UQ97079


DB2 V 8 THE ERROR IS, DSNT SQLCODE206 AUO@IOIC ARE MISSING.
PQ95390
1_Dec
2004
UQ95620


DEVICE TYPE VALUE (FROM SETUP PANEL) NOT BEING UTILIZED IN ALLOCATION OF ISPF TEMPORARY/WORK DATASETS: AUO014E MSG
RESULTS
PQ95748
1_Dec
2004
UQ95620


INCORRECT INTEGER VALUES IN COLUMN DEFINITION OF ALTER STATEMENT
PQ96004
1_Dec
2004
UQ95620


LOB TABLES ARE BUILT WITH INCORRECT LOCKSIZE LOG.
PQ96033
1_Dec
2004
UQ95620


MSGCSV028I ABENDS906 RC08 IN AUO#UTIL
PQ94204
29_Sep
2004
UQ93395


SQLCODE181 LOADING REPOSITORY TABLE RS.SYSINDEXS IF A ROW IN SYSIBM.SYSINDEXES REFERENCES A NON-EXISTENT PARENT
PQ91989
26_Aug
2004
UQ92256


Resolves multiple IBM defects involving support of DB2V8 Part 2
PQ92357
26_Aug
2004
UQ92256


IF AN INVALID DB2 SSID IS SPECIFIED IN BATCH JOB AUOVRUPD, THE JOB ERRONEOUSLY COMPLETES WITH A MAXCC=0.
PQ85819
25_Aug
2004
UQ92256


POINT-IN-TIME RECOVERY FAILS DUE TO MISSING IMAGE COPY STEP IN DSN1COPY RECOVERY JCL
PQ84483
25_Aug
2004
UQ92256


PROVIDE DB2 V8 SUPPORT IN DB2 OBJECT RESTORE R210
PQ87015
25_Aug
2004
UQ92256


AUO014E GENERATED ERRONEOUSLY
PQ87612
25_Aug
2004
UQ92256


Recovery JCL fails with CC=8, Duplicate name in catalog.
PQ82814
12_Jan
2004
UQ83969

HIPER

WHEN UTILIZING MULTIPLE VR SUPPORT - TABLES, TABLESPACES, ALIASES AND VIEWS CAN BE LOADED INTO WRONG REPOSITORY TABLE.

Top of page