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: 6 July 2023
DB2 Administration Tool Version 10.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PI21786
12_Nov
2014
UI22964


MESSGE ADB5256W WITH RC04 TO BECOME ADB5256I WITH RC00 WHEN SSID() HAS GROUP ATTACHMENT NAME BUT DATA SHARING NOT ENABLED
PI12946
27_Aug
2014
UI20907


GEN MESSAGE ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE PARSED.
PI24038
27_Aug
2014
UI20906


GEN ADB1455E ADB2REP: UNEXPECTED SQLCODE IN : FETCH C_TRIGDEP2 SQLCODE100
PI19731
16_Jul
2014
UI19647


DEBUG MESSAGES BEING SEEN
PI15738
16_Jul
2014
UI19649


DB2 ADMINISTRATION TOOL FOR Z/OS IMAGE COPY STATUS QUERY (ICS) MAY FAIL WITH SQLCODEN413 IF COPYPAGES VALUE IS LARGE
PI16092
16_Jun
2014
UI18858


PANEL ADBHAT HELP DB2 TABLE AUTHORIZATIONS COLUMN HG DOES NOT LIST G AS AN OPTION
PI16299
26_May
2014
UI18325

HIPER

MISSING DB2 LOAD UTILITY SYNTAX ( MIXED KEYWORD ) DATA CORRUPTION WHEN CHANGING COLUMN FROM NULLABLE WITH DEFAULT TO NOT NULL
PM98358
14_May
2014
UI17987


THE GEN FUNCTION CREATES INVALID CREATE PROCEDURE DDL WHICH WHEN EXECUTED MAY FAIL WITH SQLCODEN338
PI09080
28_Apr
2014
UI17468


CATALOG COPY FUNCTION RUNNING DB2 V10ENFM FAILS WITH MSG IEF212IADBSYSPK DATA SET NOT FOUND
PI11759
14_Apr
2014
UI17019


ALTERING A TABLE DOES NOT GENERATE GRANTS ON RELATED MQT TABLE
PI14287
14_Apr
2014
UI17031


PANEL ADB21K SQ OPTION GENERATES INCORRECT RESULTS WHEN INVOKED FROM PANEL ADB21P 14/03/26 PTF
PECHANGE
PI13850
14_Apr
2014
UI17028


ISPT034 TABLE IS NOT OPEN TBTOP ISSUED FOR TABLE ADB2DB2D THAT IS NOT OPEN.
PI14168
14_Apr
2014
UI17032


ABEND0C4 ONCODE8094 MODULE ADB2FMT ENTRY POINT F_ADD_UNTIL_PTYPEWHEN RUNNING GEN
PI11201
19_Mar
2014
UI16207


DB2 ADMINISTRATION TOOL FOR Z/OS BATCH JOB FUNCTION MAY GENERATEADB0351E RC08 ONCODE=520 AFTER APPLYING TH 14/02/06 PTF
PECHANGE
PI08340
19_Mar
2014
UI16207


APPLY JOB FAILS WITH SQLCODEN923 DUE TO HARD CODED PLAN NAME ADBIN EXEC ADBGAJOB
PM57188
19_Mar
2014
UI16226


WHEN A TABLE HAS LOB/XML, IT WILL USE SYNTAX FROM ADMIN DEFAULT WHICH DO NOT HAVE DSNTYPE AND DIR FORMAT CAUSING SQLCODEN452
PM94956
18_Feb
2014
UI15263


SADBSAMP MEMBERS ADBU001 & ADBU002 SPECIFY INCORRECT ELEMENTS PNLENU & SKLENU
PM95119
18_Feb
2014
UI15252


ACF2 USERS: MONITOR1 / MONITOR2 SECURITY REPORT VIOLATIONS WHEN ATTEMPTING BIND
PI09002
18_Feb
2014
UI15242


SORT FIELD COMMAND ON PANEL ADB21T GENERATES THAT FIELD NAME ON THE OPTION LINE OF PANEL ADB21
PI09158
18_Feb
2014
UI15245


GEN/DDL ADB2GEN SQLCODEN423 WHEN PROCESSING A NATIVE STORED PROCEDURE / NSP. 14/01/08 PTF
PECHANGE
PM99679
28_Jan
2014
UI14576


ALT: PANEL ADBPJ7 'REDEFINE TRIGGER' DOES NOT SHOW TRIGGER BODY / 'EDIT TRIGGER BODY' YES SHOWS EMPTY DATASET ON PANEL
ISREDDE2
PM94074
28_Jan
2014
UI14593
PI11201

CATALOG COPY FEATURE: ADB5256E THE SSID PARAMETER THAT IS PASSEDTO THE PROGRAM IS NOT RECOGNIZED FOR DB2 DATA SHARING GROUP
PM78665
28_Jan
2014
UI14574


ADB21XSD DOES NOT TRANSLATE COPYUPDATELRSN VALUE TO READABLE CHARACTERS
PI07539
28_Jan
2014
UI14593
PI11201

DB2 ADMINISTRATION TOOL FOR Z/OS CM DOES NOT MAINTAIN PROPER CCSID IN THE BASE VERSION AFTER RUNNING A CHANGE ON CGTT
PI06256
28_Jan
2014
UI14593
PI11201

WSLVAL SQLCODEN104 CAUSED BY INVALID ALTER TABLE VALIDPROC SYNTAX IN WSL ( MISSING PROC NAME ).
PI08226
28_Jan
2014
UI14585


DB2 ADMINISTRATION TOOL FOR Z/OS ON PANEL ADB2C14 ISSUES MESSAGE NOT FOUND FOR ADB9999
PM90389
28_Jan
2014
UI14593
PI11201

DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT CHANGE OWNER OF THETABLESPACE IF COMPARE STARTS ON THE TABLESPACE LEVEL
PM95922
14_Jan
2014
UI14216


INCONSISTENT RESOLUTION OF TNAME VARIABLE IN TEMPLATE NAMES.
PM97150
14_Jan
2014
UI14217


PANEL ADB2GEN DOES NOT GENERATE COMMITS WHEN STATISTICS ONLY IS SPECIFIED IN THE DML
PI07463
14_Jan
2014
UI14217


MIG 'SCOPE OF MIGRATE:' / 'CATALOG STATISTICS' USES LOCAL SYSTEMS INDEXSPACE NAME RATHER THAN THE TARGET SYSTEMS INDEXSPACE
NAME
PI07836
14_Jan
2014
UI14217


DB2 ADMINISTRATION TOOL FOR Z/OS CLONE WSL FUNCTION RESULTS IN USER ABEND 4,038 DEC PROCESSING COMMAND 'ADB2WCL '
PM96448
26_Dec
2013
UI13860


PANEL ADB21TIN 'BUILD SQL INSERT PROTOTYPE' SQLCODEN206 CLOB / BLOB COLUMN DATA TYPES.
PK78580
26_Dec
2013
UI13874


DB2 OBJECT COMPARE MQT NOT REGISTERED AS IMPLICITLY DROPPED WHENA REFERENCED TABLE IS DROPPED.
PM87069
26_Dec
2013
UI13855


UNLOAD ON A TABLE OR TABLESPACE WITH "LAST IC" SPECIFIED ON ADB2USU BY JCL, UNLOAD(HPU) IS BUILT INTO THE JCL.
PM97843
11_Dec
2013
UI13440


UNEXPECTED ALTER STATEMENTS WHEN TABLE-CONTROLLED PARTITIONING OBJECT COMPARED TO DDL USED TO CREATE OBJECT
PM98241
11_Dec
2013
UI13409


PANEL ADB2RIP REVOKE IMPACT REPORT DIFFERENT RESULTS FOR SAME ACTION DEPENDING ON USERS SYSADM AUTHORITY.
PI04754
11_Dec
2013
UI13416


ONCODE451 ADB2CMP CM BATCH
PI06723
11_Dec
2013
UI13440


TABLE NOT FOUND OR COLUMNS NOT FOUND WHEN CREATING AN INDEX FOR THE TABLE WHOSE NAME AND SCHEMA HAVE BEEN ALTERED.
PM98432
27_Nov
2013
UI13008


GEN / DDL FUNCTION: INCORRECT DDL WHEN AN INCLUDE COLUMN IS ADDED TO AN INDEX THAT IS FOR A PRIMARY KEY, CREATED PRIOR TO
DB2 7
PM96003
27_Nov
2013
UI13016


LOAD STATEMENT DOES NOT INCLUDE DEFAULTIF
PM96812
27_Nov
2013
UI13021


DB2 OBJECT COMPARISON TOOL FOR Z/OS GENERATES DROP/CREATE INSTEAD OF ALTER WHEN PROCESSING TIMESTAMP COLUMN
PM96562
27_Nov
2013
UI13005


PANEL ADB2US KL COMMAND DSNU067I DSNUKLIT - TABLE SPACE IS NOT A LOB TABLE SPACE AND DSNU074I DSNUKINP CHECK DATANOT
SUPPORTED
PM98751
27_Nov
2013
UI13014


DB2 ADMINISTRATION TOOL FOR Z/OS INCORRECTLY USES SCHEMA MASK TO MASK THE OWNER OF THE OBJECTS CREATED PRIOR TO DB2 V9 NFM
PM98754
27_Nov
2013
UI13014


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT USE SCHEMA MASK TO MASK SYSPACKAGE.QUALIFIER
PM99447
27_Nov
2013
UI13002


DB2 ADMINISTRATION TOOL FOR Z/OS PTF UK97097 MISSPELLS KEYWORD UCOUNT AS UCONUT CAUSING THE ERRORS WHEN R 13/10/18 PTF
PECHANGE
PM93113
27_Nov
2013
UI13021


GEN MESSAGE ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE PARSED.
PM94214
27_Nov
2013
UI13021


DB2 ADMINISTRATION TOOL FOR Z/OS GEN PROCESS DOES NOT USE THE CCSID OF THE VIEW FROM SYSENVIRONMENT RECORD
PM89188
27_Nov
2013
UI13021


ALT DOES NOT WARN OF CHANGE WHICH WILL EXCEED DB2 LIMITS RESULTING APPLY JOB FAILS WITH SQLCODEN680 TOO MANY COLUMNS
SPECIFIED
PM96101
13_Nov
2013
UI12479


SQLCODEN551 IN BIND CAUSED SQLCODEN525 WHEN EXECUTING GEN MODULEADB2REM.
PM96080
13_Nov
2013
UI12477


ALTERING LOB TS GENERATES MSG ADB5184E DSNU049I REORG
PM97143
13_Nov
2013
UI12484


GEN MESSAGE ADB1653E STOGROUP NOT FOUND, SGNAME= 00000001 WHEN ABILITY TO SELECT FROM DIRECTORY TABLES ENABLED.
PI04749
13_Nov
2013
UI12468


SPACE MANAGER / SM: INVALID DATA IS FOUND IN THE 'PAGE SIZE' FIELD ( A VALUE OF '409' )
PM99667
13_Nov
2013
UI12481


PROCESSING ERROR WHEN ALTERING A VIEW WITH A GLOBAL VARIABLE.
PM93818
13_Nov
2013
UI12475


DB2 ADMINISTRATION TOOL FOR Z/OS WHEN RUNNING IMPORT CHANGE WITH LARGE AMOUNT OF OBJECTS USES A LOT OF RESOURCES
PM91601
13_Nov
2013
UI12470


ADBTEP2 --#SET MAXERROR DOES NOT BEHAVE LIKE DSNTEP2 / DSNTEP4.
PM91894
30_Oct
2013
UI11939


PANEL ADB25LE TRUNCATES THE PART COLUMN IF MORE THAN ONE CHARACTER IS SPECIFIED.
PM94873
30_Oct
2013
UI11968


THIS APAR WILL DELIVER CODE TO PREVENT THE PRODUCT FROM COMPARING NUMPARTS FOR PBG OBJECTS.
PM97960
30_Oct
2013
UI11945


NO INDICATION AND/OR MESSAGE RETURNED WHEN ISSUE 'UT' COMMAND ONTHE PANEL ADB25.
PM98625
30_Oct
2013
UI11964


CATALOG COPY GENERATES INCORRECT LOAD STATEMENT SQLCODE -104
PM93218
30_Oct
2013
UI11968


ALTER TABLE, INSERT AND REMOVE XML COLUMN WITH XMLSCHEMA, DATA CONVERSION IS MISSING BEFORE LOAD. 13/07/17 PTF
PECHANGE
PM91490
30_Oct
2013
UI11961


PANEL ADB2W1I 'INTERPRET WORK STATEMENT' SHOWS INCORRECT VALUE FOR 'QUAL' COLUMN.
PM89539
30_Oct
2013
UI11968


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT CHECK ZPARM VALUE FOR RRF SETTING WHEN GEN DDL WITH INLINE LENGTH FOR CLOB COLUMNS
PM94587
16_Oct
2013
UK98525


ALT MAKEPBR 'UNEXPECTED CONSTANT FOUND IN IN VALUES CLAUSE' MESSAGE ISSUED IN ERROR.
PM96673
16_Oct
2013
UK98538


INCORRECT LOAD SUMMARY REPORT ISSUING RESTART AFTER WSL ABEND
PM98014
16_Oct
2013
UK98540


CHANGE MANAGEMENT: SQLCODEN803 INDEX SPACE ADBCIDX1 AFTER EDIT OF IGNORE PANEL GOCCI 'SPECIFY IGNORE FIELDS: OBJECTS'
PM98253
16_Oct
2013
UK98493


WHEN SPECIFY SYSTEMPAGES=YES ON PANEL ADB2USC, NO KEYWORD IS ADDED TO THE UTILITY STATEMENT.
PM93417
16_Oct
2013
UK98549
PI05317
PI05441

DB2 ADMINISTRATION TOOL FOR Z/OS CHANGE MANAGEMENT ANALYZE DOES NOT PROCESS PROPERLY RENAMED COLUMN OF THE UNIQUE INDEX
PM88143
16_Oct
2013
UK98549
PI05317
PI05441

ALT CHANGE FROM IMPLICIT TO EXPLICIT TABLESPACE DB2 LOAD UTILITYDSNU305I DSNURWI TABLE HAS AN INCOMPLETE TABLE DEFINITION
PM89018
16_Oct
2013
UK98530


DB2 OBJECT COMPARISON TOOL FOR Z/OS INCORRECTLY GENERATES ALTER TABLE ALTER PARTITION STATEMENT FOR XML TABLESPACE
PM91587
16_Oct
2013
UK98480


THE APPLY JOB FAILED WITH RC=8 SINCE INCORRECT LISTDEF ADBLD2 ISUSED. SHOULD BE LISTDEF ADBLD1 FOR TABLE
>SCHEMA<.>TABLE_NAME<
PM85966
16_Oct
2013
UK98549
PI05317
PI05441

ALT DOES NOT ALLOW GENERATING INDEX CONTROLLED PARTITIONING
PM87938
16_Oct
2013
UK98549
PI05317
PI05441

DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT PROVIDE A PATH TO CONVERT TABLE FROM SEGMENTED TO INDEX PARTITIONED
PM88501
16_Oct
2013
UK98549
PI05317
PI05441

DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT HAVE SUPPORT FOR DSSIZE 256G PROVIDED BY DB2 FOR Z/OS IN APAR PM42175
PM91492
16_Oct
2013
UK98536


PANEL ADBDMT DOES NOT RETAIN THE SSID SET VIA THE SYSTEM() PARM IN EXEC ADBL.
PM94749
26_Sep
2013
UK97962
PM98676
PM99573

COMPARE GENERATES MSG ADB7139E WITH TS WITH PARTITIONED IX
PM93198
26_Sep
2013
UK97962
PM98676
PM99573

DB2 OBJECT COMPARISON TOOL FOR Z/OS SELECTS INCORRECT DEFAULT DSSIZE FOR PARTITIONED TABLESPACE WITH 32K PAGESIZE
PM94061
26_Sep
2013
UK97962
PM98676
PM99573

DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT REPORT SEGSIZE DIFFFOR IMPLICIT TABLESPACE WHEN RUNNING UNDER DB2 FOR Z/OS V10
CM9
PM90035
26_Sep
2013
UK97962
PM98676
PM99573

GEN FUNCTION APAR PM84458: IMPROVEMENTS TO MESSAGES AND DOCUMENTATION.
PM90471
26_Sep
2013
UK97962
PM98676
PM99573

DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT DISPLAY COLUMN LIST EVEN WHEN OPTION 1 IS SELECTED ON ADB2CONF PANEL
PM91327
26_Sep
2013
UK97962
PM98676
PM99573

DB2 OBJECT COMPARISON TOOL FOR Z/OS ISSUES MESSAGE ADB7163W FOR THE LOB OF THE DEPENDENT TABLE WHICH IS MISLEADING
PM81375
26_Sep
2013
UK97962
PM98676
PM99573

BEHAVIOUR OF 'RUN SQLID' PARM ON GENERATED GRANT STATEMENTS.
PM81753
26_Sep
2013
UK97962
PM98676
PM99573

GEN/DDL COMMAND DOES NOT EXTERNALIZE FIELDPROC WITHOUT ROW ATTRIBUTES / WITH ROW ATTRIBUTES
PM88033
26_Sep
2013
UK97931


HELP PANEL FOR ADB21T FOR VIEW ON VIEW, TSNAME IS INVALID. SQL BOOK HAS BEEN CHANGED
PM90883
26_Sep
2013
UK97945


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT USE THE SAME DATASET NAME IN THE LOAD STEP AS IT GENERATED IN UNLOAD JCL DURING
ALTER
PM91035
26_Sep
2013
UK97949


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT CHECK FOR THE OMISSION OF THE TRAILING PERIOD IN TEMPLATE DSN VARIABLE NAME
PM90654
13_Sep
2013
UK97527


PANEL ADB2USU 'LAST IC' FIELD LAST RESULTS IN ZERRMSG ISPF105 FUNCTION ADB2U LINE 2388: FTINCL ADB2UTUL OUTPUT OVERFLOW
PM89254
13_Sep
2013
UK97520


DB2 ADMINISTRATION TOOL FOR Z/OS GENERATES INCORRECT LIBRARY FOR ADBTEP2 IN TARGET JCL WHEN DOING MIGRATION
PM89256
28_Aug
2013
UK97083


PANEL ADB2US POOR PRODUCT PERFORMANCE WHEN GENERATING COPY UTILITY AT THE PARTITION LEVEL.
PM89471
28_Aug
2013
UK97097
PM99447

IGD17293I DATA SET >HLQ<.IFF HAS PARTITIONED ORGANIZATION AND IS NOT ELIGIBLE TO BE A MULTI-VOLUME DATA SET, ALLOCATION
D
PM89542
28_Aug
2013
UK97089
PI14287

SLOW PERFORMANCE ON PANEL ADB21K 'PACKAGES' WHEN PROCESSING LARGE NUMBERS OF PACKAGES ( FOR EXAMPLE 6,000+ ).
PM90542
28_Aug
2013
UK97109


CLIST ADBRPGM HAS HARDCODED TSO ALLOC FOR ADBDIAG DD WHICH DOES NOT HAVE A TYPE SPECIFIED I.E. TRACKS
PM91222
28_Aug
2013
UK97095


DB2 ADMINISTRATION TOOL FOR Z/OS USING DB2 FOR Z/OS V10 IN CM9 MODE DOES NOT FORMAT SP CORRECTLY USING DDL OR GEN OPTION
PM91300
28_Aug
2013
UK97102


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT PROVIDE AN EASY EXIT FROM EDIT SESSION RESULTED FROM RO OPTION FOLLOWING AN RT
OPTION
PM89199
16_Aug
2013
UK96764


DB2 ADMINISTRATION TOOL FOR Z/OS ALTERS LIMIT KEY ON TS LEVEL INSTEAD OF ON TB LEVEL FOR TABLE-CONTROLLED PARTITIONED TABLE
PM91229
16_Aug
2013
UK96768


ABENDX37 FOR UTLMAP TEMPLATE IN LOAD DUE TO HARD CODED SPACE.
PM91790
16_Aug
2013
UK96764


ADB2PA: COULD NOT CONVERT CHARACTERS FROM CCSID(NNNN) TO CCSID(NN), CODE = 3002 / ADB2PA5:
PM91200
16_Aug
2013
UK96766


WSL CLONE COMMAND FAILS WITH ADBQ901E ERROR INTERPRETING STATEMENT OR COMMAND WITH TYPE OF DB2.
PM77537
25_Jul
2013
UK96129


ONLINE COMPARE ISSUES MESSAGE ALLOC RC=12 ALLOC STMT: ALLOC REU OLD DD(SRCVERI) DA('') AND/OR IEC212I 414-08 SYSPRINT
PM85511
24_Jul
2013
UK96053


MISSING ALTER INDEX STATEMENTS IN WSL
PM85949
24_Jul
2013
UK96111


SQLCODEN626 ON ALTER GBCACHE BECAUSE STOP DID NOT PRECEED ALTER TABLESPACE
PM90556
24_Jul
2013
UK96053


PANEL GOC5 'GENERATE COMPARE JOBS' FIELD 'SUPPRESS DROP OF OBJECTS' AKA KEEPTGT AKA 'KEEP TARGET' BEHAVIOUR CHANGED FOR LOB'S
PM85866
24_Jul
2013
UK96109


PANEL ADB2DIPD 'DROP IMPACT ANALYSIS DETAILS' 'NOT POSSIBLE' MESSAGE FOR DRD LINE COMMAND IS ALTER NOT ISSUED.
PM87557
24_Jul
2013
UK96053


APPLY JOB FAILS SQLCODEN601 AFTER 'NEW HISTORY TABLE >SCHEMA<.>TABLE< WILL BE ADDED' MESSAGE IN OBJECT COMPARISON REPORT
PM90885
24_Jul
2013
UK96053


ADB27AC MESSAGE 'ADBC200E INTERNAL ERROR. MAX PRIM KEY SEQ ^= #KEY COLS' 13/06/14 PTF
PECHANGE
PM62098
16_Jul
2013
UK95900


GOC5 UNLOAD METHOD P PARALLEL UNLOAD DOES NOT RESULT IN PARTITION PARALLELISM
PM85229
16_Jul
2013
UK95873


PANEL ADB2Z2TS 'TRACE FUNCTIONS' MESSAGE 'INVALID PARAMETER' 'THE PARAMETER LENGTH IS NOT VALID FOR THE SPECIFIED COMMAND'
PM89937
16_Jul
2013
UK95900


ALT LIMIT KEYS OF TEMPORAL TABLE ISSUES DROP VERSIONING STATEMENT LEAVING TABLE WITHOUT VERSIONING
PM74168
16_Jul
2013
UK95877


SUPPORT FOR PRODUCT LIBRARIES IN TSO LOGON PROC / LIBDEF'ED BEFORE ADBL IS INVOKED.
PM85821
16_Jul
2013
UK95873


PANEL ADB2P2 'CHANGE DB2 ADMIN DEFAULTS' FIELD 'CAPITALIZE DATA''NO' DOES NOT PREVENT FOLDING TO UPPER CASE IN ALL CASES.
PM85848
16_Jul
2013
UK95875


PANEL ADB2C2L 'CM - MASK LINES' LINE COMMAND 'D - DELETE' WILL ONLY DELETE VALID MASK LINES / 'INVALID VALUE' MASK LINE
ISSUE
PM87211
16_Jul
2013
UK95882


DB2 ADMINISTRATION TOOL FOR Z/OS CHANGE MANAGEMENT ANALYZE RUN FAILS TO DETECT STOGROUP WHEN PROCESSING CHANGE
PM88473
16_Jul
2013
UK95558


WSL VALIDATION FAILED WHEN ALTER COLUMN OF TABLE WHICH HAS A MQTREFERENCED OR IS A TEMPORAL TABLE WITH VERSIONING ENABLED
PM90574
16_Jul
2013
UK95884


PANEL ADB2USO 'SPECIFY UTILITY OPTIONS - REORG' ALLOWS 'SHRLEVEL N' FOR LOB TABLESPACES DSNU126I NO LONGER SUPPORTED
PM90633
16_Jul
2013
UK95887


MESSAGE 'MISSING SEMI-COLON AFTER SQL-PROCEDURE-STATEMENT IN IF STATEMENT' WHEN PROCESSING CREATE PROCEDURE STATEMENT.
PM84348
25_Jun
2013
UK95394


DB2 BIND PACKAGE KEYWORDS APREUSE, APRETAINDUP, APCOMPARE MISSING FROM PANEL ADB21KR / ADB21KB.
PM90936
25_Jun
2013
UK95399


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT GENERATE IMPORTANT CATALOG STATISTICS INCLUDING AVGKEYLEN
PM87396
25_Jun
2013
UK95394


PANEL ADB21KB 'BIND SQL PROCEDURE PACKAGE' BC - BIND COPY LINE COMMAND BLANK FIELD 'DEPLOY PACKAGE' MSG 'ENTER REQUIRED
FIELD'.
PM88642
25_Jun
2013
UK95396


SQLCODEN4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEWFUNCTION MODE WHEN RUNNING ADBTEP2 IN DB2 10 CM8 FO 13/05/15 PTF
PECHANGE
PM88739
25_Jun
2013
UK95396


WSL RESTART BEHAVIOR "MISSING" SET CURRENT STATEMENTS.
PM81289
17_Jun
2013
UK95037
PM93218

FOLLOW ON FROM APAR PM66561, TRIGGER OBJECTS NOT ACTED UPON.
PM81665
17_Jun
2013
UK95037
PM93218

SQLCODEN554 ERROR: AN AUTHORIZATION ID OR ROLE CANNOT GRANT A PRIVILEGE TO ITSELF.
PM82329
17_Jun
2013
UK95037
PM93218

UTILITIES ARE GENERATED WITH CLONE KEYWORD FOR NON-CLONED OBJECTS
PM83934
17_Jun
2013
UK95179


DB2 ADMIN TOOL IGNORES THE INLINE COMMENTS IN IN A VIEW WHEN USING REVERSE ENGINEERING TO GET THE DDL FOR THE VIEW
PM84240
17_Jun
2013
UK95037
PM93218

DB2 ADMINISTRATION TOOL FOR Z/OS DURING ALTER OF A TABLE DOES NOT ALLOW LENGTH OF THE COLUMN TO BE CHANGED IN FOREGROUND
PM88805
17_Jun
2013
UK95164


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT PROVIDE ENOUGH USEFUL INFORMATION WHEN IT ISSUES MESSAGE ADBC099E (MSGADBC099E)
PM89203
17_Jun
2013
UK95183


GEN ADB2PA5.TOKENIZE ISSUE WITH TRIGGER HEX VALUE '5A'X FOR AN EXCLAMATION POINT IN A CCSID 277 ENVIRONMENT.
PM89546
17_Jun
2013
UK95176


DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES PROG755 /SCREEN ERASURE DURING DDL COMMAND ON SAMPLE SP DSN8EN1
PM89658
17_Jun
2013
UK95185


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT PROCESS CHANGE WITH FOREIGN KEY CORRECTLY AFTER USING (DELTA) CHANGE IN COMPARE
JOB
PM89741
17_Jun
2013
UK95170


SQLCODEN4700 ALTER FUNCTION WHEN DB2 10 CM9.
PM90093
17_Jun
2013
UK95187


WSL VALIDATION MESSAGE ADB3012E ERROR PROCESSING INDEX IN CREATE STATEMENT: THE PRIMARY INDEX OR INDEX ENFORCING UNIQUE
PM76541
17_Jun
2013
UK95037
PM93218

WHEN DOING A COMPARE OF A TABLE, THE COMPARE STEP DOES NOT LIST THE CHANGES, THE ANALYZE RUN AFTER THAT DOES LIST THE CHANGE.
PM83386
17_Jun
2013
UK95037
PM93218

DB2 OBJECT COMPARISON TOOL FOR Z/OS PRODUCES CREATE STATEMENTS IN WSL OUT OF SEQUENCE
PM86639
17_Jun
2013
UK95037
PM93218

DB2 OBJECT COMPARISON TOOL FOR Z/OS ISSUES COMPARE ERROR WITH ALIASES ON VIEWS
PM88424
17_Jun
2013
UK95162


PANEL ADB21TRE 'PARENTS OF TABLE' FIELD 'RELATION NAME' NOT SCROLLABLE.
PM88599
17_Jun
2013
UK95037
PM93218

DB2 ADMINISTRATION TOOL FOR Z/OS WHEN ADDING VERSIONING TO A TEMPORAL TABLE ENCOUNTERS ONCODE 8094 IN THE ADB2CMP
COMPONENT
PM88644
17_Jun
2013
UK95181


PANEL ADB21S 'TABLE SPACES' COMMANDS: 'STO ALL' IS NOT POINT-AND-SHOOT ENABLED.
PM89497
17_Jun
2013
UK95174


MSGDSNU047I DSNUKDIN - A REQUIRED CARD OR TEMPLATE IS MISSING NAME UTLOUT OR NAME SYSUT1 MISSING IN CHECK DATA UTILITY
PM78895
23_May
2013
UK94520


CHANGE DEFAULT VALUE FOR A NULLABLE COLUMN, DROP/RECREATE WAS USED INSTEAD OF ALTER
PM86058
23_May
2013
UK94520


OC DROP / CREATE INSTEAD OF ALTER WHEN CHANGING BLOB 1M TO BLOB 2M
PM88412
23_May
2013
UK94374


REORG INDEX WITH SHRLEVEL CHANGE, THE DRAIN CLAUSE NOT INCLUDED IN THE FINAL REORG STATEMENT.
PM77205
23_May
2013
UK94520


ALT WSL APPLY JOB ENDS WITH SQLCODEN669 ON DROP TABLE AS A MQT CREATED IN A PBG TABLE SPACE IS DEFINED ON TABLE.
PM85137
23_May
2013
UK94516


PANEL ADB2USU 'LAST IC' FIELD LAST RESULTS IN ZERRMSG ISPF105 FUNCTION ADB2U LINE 2388: FTINCL ADB2UTUL OUTPUT OVERFLOW
PM73284
14_May
2013
UK94268


ADBTEP2 AUTO CHECK UTILITIES DOES NOT USE HLQ PREFIX FROM PANEL INPUT ON CHECK DATA UTILITY DATASETS
PM79009
14_May
2013
UK93044


WHEN ALTERING A TABLE, THE JOB OUTPUT LISTS RC0 EVENTHOUGH AN SQLCODE=-805 IS ISSUED
PM83764
14_May
2013
UK94273


PANEL ADB21XAA 'ALTER INDEX - ADD COLUMNS' COLSEQ COLUMN ORDER INCORRECT.
PM84458
14_May
2013
UK94291


GEN OF SQL NSP FAILS RC8 RC08 MSG1933E PARSER ERROR ON TABLE LIKE EXPRESSION
PM85027
14_May
2013
UK94277


PANEL ADB2SDS HIDES DESCRIPTION INPUT FIELD WITH PFKEY DISPLAY WHEN USING S SAVE DIALOG OPTION FROM PANEL GOCMENU
PM85832
14_May
2013
UK94275


PANEL ADB2DIPD 'DROP IMPACT ANALYSIS DETAILS' COMMANDS DROP DOES NOT TAKE ANY ACTION WHEN SELECTED BY CURSOR
PM85855
14_May
2013
UK94279


PANEL ADB26CTF 'CREATE TABLE COLUMNS' ALLOWS 'NULL Y DEFAULT N' TO BE SPECIFIED.
PM86215
14_May
2013
UK94291


GEN FUNCTION: SQL STMT NOT COMPLETELY PARSED ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED CREATE FUNCTION ADB1932W
RC28
PM87818
14_May
2013
UK94029


INVALID DISP OPERAND IN LOAD UTILITY JOB
PM80133
25_Apr
2013
UK93788


PANEL ADB21TAV 'DISPLAY LIMIT KEY VALUES' MISSING INFORMATION WHEN DECIMAL=COMMA / LKEY LINE COMMAND.
PM78961
25_Apr
2013
UK93788


ALT: PANEL ADB21SAR, CHANGE TO DATABASE NOT HONORED AND PANEL ADB27C CHANGE TO DATABASE AND TABLESPACE NOT HONORED
PM84715
25_Apr
2013
UK93790


MODULE ADB2CMF IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED. FROM ENTRY POINT COMPARE_TABLESPACES
PM85524
25_Apr
2013
UK93779


PANEL ADB21SA 'ALTER TABLE SPACE' FIELDS 'PRIMARY QUANTITY' AND 'SECONDARY QUANTITY' SHOW A VALUE OF -4 / NEGATIVE 4
PM86440
25_Apr
2013
UK93781


GEN OF DB2 CATALOG OBJECTS DDL HAS USING VCAT " "
PM68380
15_Apr
2013
UK93450


CM COMPARE FAILS RC16 WITH PARSER MESSAGE, UNEXPECTED TOKEN AFTER (PART-COL.LIST) - EXPECTED (PART CLAUSE)
PM73272
15_Apr
2013
UK93463


TEMPLATE VALUES &DB AND &TS PRODUCE GENERIC NAMES "DBNAME" AND "TSNAME" INSTEAD OF THE ACTUAL DB AND TS NAMES
PM74264
15_Apr
2013
UK93463


UNABLE TO GENERATE REORG WITH SHRLEVEL C FROM PANEL ADB2USO . SHRLEVEL IS SET TO N.
PM84262
15_Apr
2013
UK93463


DSNU028I DSNUTILB - UNABLE TO CONNECT TO DB2, REASON=X'00F30024' AFTER MESSAGE 'ADB5216I PERFORMING AUTO-CHECK
PROCESSING...'
PM84747
15_Apr
2013
UK93456


(D)FIELD TABLESPACE TYPE CHANGED FROM LARGE TO <NORMAL> WHEN COMPARING DDL TO DB2 CATALOG FOR OBJECTS DEFINED AS LARGE
RTS
PM77220
15_Apr
2013
UK93463


MSGDSNU1015I ERROR ALLOCATING DATASET CODE=X'02200000' MSGIKJ56221I DATA SET NOT ALLOCATED RC08 RC8
PM80271
15_Apr
2013
UK93452


ZPARM ASSEMBLY ERROR RC=12 ON DB2 V10
PM81441
15_Apr
2013
UK93459


PANEL ADB21T CDI LINE COMMAND RESULTS IN ERROR RUNNING ADB21CDI,LINE 146: BAD ARITHMETIC CONVERSION
PM81461
15_Apr
2013
UK93463


ABENDU4038 IBM0342S ONCODE=340 THE SIZE CONDITION WAS RAISED FROM ENTRY POINT CREATE_INDEX AT STATEMENT 2812 ADB2REG
PM83100
15_Apr
2013
UK93454


VERSION 10.2 TEMPLATE ADBCX10 BUILDS INDEX ON DB2 CATALOG BUT NOJOB DELETES INDEX OBJECTS BUILT FOR PRIOR LEVELS OF ADMIN
PM81794
26_Mar
2013
UK92891
PI09158

DB2 ADMIN TOOL WHEN GENERATING VIEW DDL ISSUES MSGADB1649E ADB2REM: UNEXPECTED SQLCODE IN : FETCH C_VIEW LOOP. RC=12
PM73347
26_Mar
2013
UK92885


ALT A TABLE TO DELETE AND INSERT MULTIPLE COLUMNS(NOT NULL),THE WRONG POSITIONS ARE CREATED IN THE CNC FILE FOR INSERTED
COLS.
PM80223
26_Mar
2013
UK92895


OPTIONS ON PANEL ADB2Z2D 'DISPLAY THREADS' CAUSE 'NONE' TO BE SHOWN ON ADB2Z2D2 'DISPLAY/CANCEL THREADS' S/B DSNV515I
00E60820
PM81236
26_Mar
2013
UK92895


USER DOESN'T HAVE PRIVILEGE EXECUTING DB2 COMMAND, WHEN AL AN INDEX, A DB2 ERROR MESSAGE WILL DISPLAYED.
PM82703
26_Mar
2013
UK92893


DB2 OBJECT COMPARISON TOOL FOR Z/OS PERFORMS DROP OF THE LOB BASE TABLE INSTEAD OF ALTER WHEN NEW PARTITION ADDED
PM69672
15_Mar
2013
UK92575


ALT ALTER TABLE DROP FOREIGN KEY ENDS SQLCODEN204
PM76359
15_Mar
2013
UK92571


DB2 ADMINISTRATION TOOL FOR Z/OS GEN FUNCTION USING MASK GENERATES THE DSSIZE CLAUSE / KEYWORD FOR SEGMENTED TS
PM77761
15_Mar
2013
UK92575


MISLEADING MESSAGE '(W)THE LOB OBJECT HAS BEEN CHANGED FROM EXPLICIT TO IMPLICIT.' AS SOURCE AND TARGET DDL ARE BOTH
IMPLICIT.
PM81829
15_Mar
2013
UK92570


GEN MASK NOT APPLIED TO SEQUENCE SCHEMA WITHIN TRIGGER
PM82662
15_Mar
2013
UK92579


SQLCODEN104 IN PANEL ADB25TU WHEN VARIABLE TLOWNER OR LDOWNER CONTAINS RESIDUAL VALUE OF PERCENT SIGN %
PM82732
15_Mar
2013
UK92566


PANEL ADB21J 'TRIGGERS' SHOWS DUPLICATE ROWS WHEN 'J - TRIGGERS' LINE COMMAND USED ON PANEL ADB21Q 'SEQUENCE OBJECTS'.
PM76792
15_Mar
2013
UK92573


ALT COPY STEP DSNU1032I INVALID QUALIFIER P&PART.(+1). IN TEMPLATE COPYDDN1 DUE TO EXTRA PERIOD SUFFIX ADDED BY
PRODUCT.
PM77125
15_Mar
2013
UK92561


ABENDX37 FOR THE ADBIN DDNAME IN EXEC ADBTSIN WHEN RUN PROGRAM ADBTEP2 WITH LARGE TAPE INPUT FILE
PM77986
15_Mar
2013
UK92577


SYSTABLEPART/LIMITKEY ROW NOT FOUND FOR CREATE INDEX (PART. INDEX LIMITKEY) WHEN COMPARING PBG AND PBR TABLESPACES.
PM81791
15_Mar
2013
UK92563


PANEL ADB21TSE 'BUILD SQL SELECT PROTOTYPE' MESSAGE ADB21TS: UNRECOGNIZED DATA-TYPE: VARG WHEN USING IN LIST
PM83126
15_Mar
2013
UK92583


DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT DETECT DEFINED TRIGGER SEQUENCE ON SOURCE AND TARGET WHEN RUNNING COMPARE
JOB
PM83432
15_Mar
2013
UK92585


DB2 ADMINISTRATION TOOL FOR Z/OS CM BATCH VARIOUS FIXES.
PM79232
22_Feb
2013
UK91904


DB2 ADMINISTRATION TOOL FOR Z/OS ON PANEL ADB21SAC THE -STOP COMMAND CONTAINS AN INVALID PARTION-ID
PM79976
22_Feb
2013
UK91906


INCORRECT STATEMENT ALTER TABLE ADD CLONE ""."" IS GENEREATED WHEN DROP CLONE WITH ALTER TABLESPACE
PM80599
22_Feb
2013
UK91908


DB2 ADMINISTRATION TOOL FOR Z/OS USING BIND ON THE COMMAND LINE ISSUES "NOT POSSIBLE" MSG FOR NSP, BUT BIND LINE COMMANDS
WORKS
PM80649
22_Feb
2013
UK91906


WHEN ALT TEMPORAL TABLE TO ALTER COLUMN, ALTER TABLE ADD VERSIONING STATEMENT IS GENERATED IN WRONG POSITION.
PM81621
22_Feb
2013
UK91917


CORRECT PARSER FUNCTION FOR ORIGINAL APAR PM64274 TO PROPERLY PARSE THE NUMRECS CLAUSE IN LOAD/UTILFROM.
PM80660
22_Feb
2013
UK91910


ADDING AND REMOVING COLUMNS FROM THE HASH TABLE, ALTER IMPLICIT HASH INDEX "FIELD CLOSE CHANGED FROM YES TO NO" RECEIVES
ERROR.
PM81364
22_Feb
2013
UK91913


TIMESTAMP (3), TIMESTAMP (6), TIMESTAMP (9) COLUMNS CHANGED TO TIMESTAMP (0) WHEN PROCESSED VIA DB2 OBJECT COMPARISON TOOL.
PM81372
22_Feb
2013
UK91915


DB2 ABENDS04E REASON CODE=00C50102 NAME=DSNECP10 DSNE004E PROBABLE SUBSYSTEM ERROR DETECTED IN CSECT DSNECP10
PM82365
22_Feb
2013
UK91919


GEN CREATES TIMESTAMP(0) VS TIMESTAMP OR TIMESTAMP(6) IN DDL FOR NON-SQL EXTERNAL STORED PROCEDURE / SP
PM73852
5_Feb
2013
UK91425
PM90885

MESSAGE 'UNABLE TO LOCATE ROW TO UPDATE WHEN ALTERING TABLE' THEN 'ADBC002E - SEVERE ERROR. COMPARE TERMINATES'
PM75982
5_Feb
2013
UK91412


BIND PACKAGE DSNT234I -SSID MESSAGE LIMIT EXCEEDED. PANEL ADB21KB 'BIND PACKAGE' DOES NOT SUPPORT THE FLAG KEYWORD.
PM76176
5_Feb
2013
UK91427


DB2 OBJECT COMPARISON TOOL FOR Z/OS RETURNS SQLCODE -148 WHEN CLONE EXISTS ON TABLE WITH RESTRICT ON DROP IS BEING ALTERED
PM77441
5_Feb
2013
UK91430


GEN DDL MESSAGE ADB1848W UNFORMATTED DDL AS VIEW COULD NOT BE PARSED REASON CODE = 28
PM77906
5_Feb
2013
UK91414


ALT CHECK DATA STEP DSNU047I DSNUKDIN - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=UTLOUT RC8
PM78162
5_Feb
2013
UK91425
PM90885

ERROR MESSAGE "ADBC200E INTERNAL ERROR. MAX PRIM KEY SEQ ^= #KEYCOLS", WHEN USING ALT TABLE TO DELETE THE LAST COLUMN AND
OTHERS
PM80412
5_Feb
2013
UK91430


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT FORMAT NATIVE STORED PROCEDURE CORRECTLY WHEN USING DDL COMMAND
PM75274
5_Feb
2013
UK91427


OC LEAVES CHILD TABLE IN CHECK PENDING CHKP STATUS FOLLOWING MSGDSNT404I SQLCODE162 ON ALTER TABLE FOREIGN KEY
PM78562
5_Feb
2013
UK91416


MSG DB2 CMD ERROR FROM PANEL ADB21D FOR USERS WHO HAVE NOT BEEN GRANT DISPLAY , OR HIGHER, AUTHORIZATION
PM78743
5_Feb
2013
UK91418


DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES MESSAGE "PROCESSING ERROR" ON PANEL ADB26CTF WHEN USING 'D'( DELETE CURRENT
COLUMN)
PM79910
5_Feb
2013
UK91423


PANEL ADB21XSD 'INTERPRETATION OF AN OBJECT IN SYSINDEXSPACESTATS' DOES NOT SHOW DB2 10 RELATED COLUMN LASTUSED.
PM74939
25_Jan
2013
UK91201


ALT CHANGING LENGTH OF COL WITH FIELDPROC: ADBALT - NOW TERMINATING. RC = 12 AND NO ADDITIONAL MESSAGES AS TO CAUSE.
PM75993
25_Jan
2013
UK91201


DB2 OBJECT COMPARISON TOOL FOR Z/OS FAILS TO USE RUN SQLID WHEN IGNORE DATASET CONTAINS ATTRIBUTE SYSTABLESPACE:CREATOR
PM79249
25_Jan
2013
UK91201


DB2 OBJECT COMPARISON TOOL FOR Z/OS INCORRECTLY REPORTS DUPL NAME IF TABLE BEING RENAMED AND OBJECT HAS THE SAME NAME
PM71353
25_Jan
2013
UK91201


DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT PROCESS IMMEDIATE DEFINITION CHANGE BEFORE PENDING DEFINITION CHANGE.
PM78647
25_Jan
2013
UK91201


TRIGGER SEQUENCING MASKING, TRIGGER OUT OF SEQUENCE, MISSING DEPENDENT PROCEDURE, MISSING DEPENDENT FUNCTION
PM76577
21_Jan
2013
UK91075


DB2 ADMINISTRATION TOOL FOR Z/OS MIGRATE FUNCTION DOES NOT CREATE DD ADBUEXEC IN THE GENERATED JCL FOR THE REXX LIBRARY
PM76737
18_Jan
2013
UK91054


PANEL ADB2EC 'CREATE PLAN_TABLE' CREATES DDL WITH CCSID EBCDIC DB2 10 NFM IF DATABASE IS DEFINED WITH CCSID EBCDIC
SQLCODEN878
PM77747
18_Jan
2013
UK91042


SYSPRINT ALLOCATED TO THE TERMINAL AFTER LEAVING DB2 ADMIN LAUNCHPAD.
PM78042
18_Jan
2013
UK91044

HIPER

PANEL ADB2UT 'TABLE UTILITIES' 'LO - LOAD (STAND-ALONE, FORCE REVIEW/MODIFY OPTIONS)' TIMESTAMP COLUMN DATALOSS
MICROSECONDS
PM79353
18_Jan
2013
UK91046


PANEL ADB2Z2D DISPLAY THREAD IRX0040I ERROR RUNNING ADB2ZDC LINE 5n: INCORRECT CALL TO ROUTINE
PM64274
18_Jan
2013
UK91049


DSNU1036I DSNURELD - UNABLE TO ESTIMATE SPACE REQUIREMENTS FOR WORKDDN WHEN TAPE / REMOVABLE MEDIA USED.
PM72725
18_Jan
2013
UK91054


PANEL ADB2RT 'REVOKE TABLE PRIVILEGES' SQLCODEN526 ON ATTEMPT TO REVOKE PRIVILEGES FOR A GLOBAL TEMPORARY TABLE
PM76478
18_Jan
2013
UK91048


PANEL ADB21S 'TABLE SPACES' 'DSN - DISPLAY TABLE SPACE DATA SET NAME(S)' LINE COMMAND SQLCODEN206 INSTANCE IS NOT A COLUMN
PM73625
28_Dec
2012
UK90645


INCONSISTENT ADBTEP2 MESSAGES AFTER SUCCESSFUL PROCESSING OF SQL SUCCESSFUL <ACTION> OF N ROW(S) VS ADB5180I SUCCESSFUL
PM76587
28_Dec
2012
UK90647


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT GENERATE CREATE ALIAS STATEMENT AFTER DROP ALIAS FOR MQT DURING ALTER TABLESPACE
PM78315
28_Dec
2012
UK90650


SQL PATH FOR CREATE PROCEDURE CAN NOT BE MASKED
PM72006
17_Dec
2012
UK90431

HIPER

DB2 ADMINISTRATION TOOL FOR Z/OS ALTER PROCESS MAY NOT DETECT SYSTEM ABEND E37-08, AND END WITH RETURN CODE=4 FROM DB2 UTIL
PM76307
14_Dec
2012
UK90381


DB2 ADMINISTRATION TOOL FOR Z/OS RETURNS SQLCODEN802 WHEN USING 'TABLE SPACE MAINTENANCE RECOMMENDATIONS' PANEL ADB2314T
PM74960
14_Dec
2012
UK90401


ALT REMOVING FIELDPROC RESULTS IN ADB1908E NO SYSTABLES ROW FOUND FOR 'CREATE AUXILIARY TABLE' & ADB0380E ADB2CMP RC12
PM75709
14_Dec
2012
UK90379


DSP OR DS LINE COMMAND DISPLAYS ERRORS ON ALIAS ORPHANED AND INDEX PARTITIONED OBJECT DISPLAYS
PM76058
14_Dec
2012
UK90390


DB2 ADMINISTRATION TOOL FOR Z/OS GEN FUNCTION PASSES INCORRECT INFORMATION ABOUT DB2 MODE IN THE TARGET VERSION FILE HEADER.
PM76070
14_Dec
2012
UK90400


GEN PANEL ADB2GEN FIELD 'TARGET DB2 VERSION' SQLCODEN628 THE CLAUSES ARE MUTUALLY EXCLUSIVE SEGSIZE PARTITION UTS
PM76369
14_Dec
2012
UK90384


EXECUTING STAND-ALONE UNLOAD UTILITY ON TABLE IN CLASSIC PARTITIONED OR PBR TABLESPACE BY WSL USING 12/12/04 PTF
PECHANGE
PM76659
14_Dec
2012
UK90392


CANNOT GENERATE JOB WHEN SPECIFYING UTILITIES FOR TABLESPACE IN RESTRICTIVE STATE.
PM76826
14_Dec
2012
UK90403


DB2 OBJECT COMPARISON TOOL FOR Z/OS. VARIOUS CODE CORRECTIONS.
PM76859
14_Dec
2012
UK90395


GEN 'GENERATE CATALOG STATS' MISSING AVGROWLEN FOR SYSIBM.SYSTABLESPACE IN DB2 10 NFM.
PM78184
14_Dec
2012
UK90386


TABLE HAS NO LOB COLUMN, SELECT OPTION OU ON PANEL ADB2US, THEN SPECIFY UNLOAD EXTERNAL, GET TWO STATEMENTS GENERATED.
PM66561
14_Dec
2012
UK90403


ALT SQLCODEN750 WHEN TABLE HAS TRIGGER DEFINED.
PM67183
14_Dec
2012
UK90403


DB2 OBJECT COMPARISON TOOL FOR Z/OS V10.1 DOES NOT GENERATE STOP COMMAND WHEN NEEDED DURING CHANGE MAXROWS SETTING FOR
PM72154
14_Dec
2012
UK90401


ALT SQLCODEN104 DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL """". WHEN REMOVING COLUMN FROM TABLE AND PRIMARY KEY.
PM72743
14_Dec
2012
UK90388


DB2 ADMINISTRATION TOOL FOR Z/OS INCORRECTLY TRAPS CURRENTDATA KEYWORD DURING REBIND OF A PACKAGE ON A REMOTE SYSTEM
PM76614
14_Dec
2012
UK90403


ADMIN TOOL WHEN CHANGING THE COLUMNS IN A CLUSTERING INDEX DOESN'T INCLUDE REORG IN WSL EVEN WITH "RUN REORG/REBUILD" =
"A"
PM76930
14_Dec
2012
UK90397


CREATE TRIGGER WILL FAIL IF THE FIRST INPUT VALUE IS A SPECIAL REGISTER DURING PARSING USING DDL/GEN, ALT OR OBJECT COMPARE.
PM78398
14_Dec
2012
UK90403


DB2 OBJECT COMPARISON TOOL FOR Z/OS GOC2CMP RC=8 BECAUSE OF SOMEOBJECTS HAVE DUPLICATE NAMES AFTER MASKING OR OTHER NAME
CHANGE
PM75788
28_Nov
2012
UK83822


DB2 ADMINISTRATION TOOL FOR Z/OS V10.1 MIGRATE TABLESPACE ENDS WITH RC8 COLUMN "ID" IS OMITTED DURING LOAD
PM76586
28_Nov
2012
UK83818


PERFORMING REORG ON INDEX SPACE ON PANEL ADB2314X LEADS TO ERRORPANEL "NOVALUE CONDITION RAISED FOR VARIABLE IXNAME"
PM73667
28_Nov
2012
UK83837


RTS LINE COMMAND RECEIVES DB2 CMD ERROR RC08 RC00E60820 WHEN ADMIN USER DID NOT RECEIVE GRANT DISPLAY AUTHORITY
PM56544
27_Nov
2012
UK83799


PANEL ADB21O 'STORED PROCEDURES' MESSAGE 'NO ROWS RETURNED' WHEN K LINE COMMAND ISSUED FOR JAVA SP
PM73338
27_Nov
2012
UK83803


ALT PANEL ADB26CTU 'ALTER TABLE' 'ALLOW NULLS N / WITH DEFAULT N' CHANGE TO 'ALLOW NULLS Y / WITH DEFAULT Y'
PM68852
27_Nov
2012
UK83801


PANEL ADB21T 'TABLES, VIEWS, AND ALIASES' ALTER NOT SUPPORTED FOR AUX TABLE ( TYPE=X) MESSAGE 'INVALID OBJECT TYPE' APPEND
YES
PM75778
27_Nov
2012
UK83805


GEN FUNCTION: SQL PATH DEFAULT SPECIFIED ON CREATE PROCEDURE DDL IN DB2 10 NFM.
PM69762
16_Nov
2012
UK83609


DROP IMPACT REPORT DOES NOT LIST PACKAGES FOR NATIVE STORED PROCEDURES ( NSP ).
PM71066
16_Nov
2012
UK83612

HIPER

WSL EDIT CAUSES LONG STATEMENT TRUNCATION ON SECOND EDIT
PM72960
16_Nov
2012
UK83592


ONCODE520 THE SUBSCRIPTRANGE CONDITION ENTRY POINT SIMPLE_TABLE_SPEC WHEN USING GEN TRIGGER
PM73406
16_Nov
2012
UK83594


DB2 OBJECT COMPARISON TOOL FOR Z/OS MODULE ADB2CMF DETECTED AN ONCODE CONDITION 520 WITH ADD_OBJECT_ENTRY & ISSUED
MSGADB0352E
PM68462
16_Nov
2012
UK83582


ABEND0C4 IN TSO ROUTINE IKJEFT04 + 118 AFTER ABEND04E RC00E40090 FROM DB2 CHECK DATA UTILITY SYNTAX ERROR
PM70870
16_Nov
2012
UK83584


SHOULD NOT UPDATE THE TEMPLATE DSN IF THE DSN NAME IS INVALID ONPANEL ADB25TD
PM72315
16_Nov
2012
UK83590


ALT COMMAND ABENDX37 ON SYSOUT MESSAGE ONCODE150 STRINGSIZE CONDITION ENTRY POINT APPLY_PATHSCHEMA_MASKS /
APPLY_RECORD_MASK
PM72532
16_Nov
2012
UK83615


ALT LOAD DSNU094I DSNUGPTC - KEYWORD 'DISCARDDN' IS DUPLICATED RC8
PM75036
16_Nov
2012
UK83596


GEN CREATES TIMESTAMP(0) VS TIMESTAMP OR TIMESTAMP(6) IN DDL.
PM75925
16_Nov
2012
UK83603


DB2 ADMINISTRATION TOOL FOR Z/OS HELP PANEL ADBHCCJ
PM72854
5_Nov
2012
UK83260


DDL / GEN TRIGGER WITH BEGIN ATOMIC REFRESH TABLE RESULTS IN UNEXPECTED TOKEN MESSAGE TOKEN = REFRESH ADB2PA
PM67173
5_Nov
2012
UK83258


PANEL ADB2314 SHOWS WORKFILE DATABASE
PM65509
24_Oct
2012
UK82897


IBM INTERNAL APAR FOR NEGATIVE FEEDBACK ON ++HOLD DATA NOT CLEARLY STATED FOR EXISTING V10.1 ENVIRONMENT ONLY.
PM71720
24_Oct
2012
UK82929


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT DISPLAY PROPER SPACE RELATED VALUES ON PANELS ADB221SPI AND ADB2BRIF FFA20 PM72590
PM66298
24_Oct
2012
UK82911


OBJECT COMPARE TOOL MAY ENCOUNTER "NOVALUE CONDITION RAISED FOR VARIABLE ADB101NF" WHILE RUNNING FUNCTION ADBGAJOB
PM66594
24_Oct
2012
UK82913


PANEL ADB2Z2RI 'INSERT RLIMIT' AND PANEL ADB2Z2RU 'INSERT RLIMIT' DO NOT HAVE ANY EFFECT NOR ISSUE ANY MESSAGES.
PM68348
24_Oct
2012
UK82917


ALT PANEL ADB27C'ALTER TABLE' SQLCODEN104 ERROR: ILLEGAL SYMBOL WHEN 'COMMENT ON TABLE' CONTAINS EMBEDDED QUOTE
PM69278
24_Oct
2012
UK82939


GEN OF TRIGGER OBJECT CAN FAIL WITH ONCODE -451 STORAGE CONDITION AND ABEND U4039 RC0
PM73422
24_Oct
2012
UK82941


DB2 OBJECT COMPARISON TOOL FOR Z/OS, TRIGGER TO BE DROPPED IS NOT IN THE COMPARISON REPORT.
PM73862
24_Oct
2012
UK82919


GEN SQLCODEN526 SEEN BY MONITORING TOOLS - NO IMPACT ON CUSTOMERS JOB OUTPUT.
PM66849
24_Oct
2012
UK82941


APPLY JOB ALTER STATEMENT FAILS SQLCODEN20385 DUE TO EARLIER ALTER STATEMENT SQLCODE610.
PM67266
24_Oct
2012
UK82936


ADB21 'AND/OR OTHER SELECTION CRITERIA (OPTION XC SHOWS YOUCOLUMNS FOR OPTION X)' VALUE FIELD QUOTES RESULTS IN
SQLCODEN180
PM67936
24_Oct
2012
UK82941


OBJECT COMPARE TOOL DOES NOT ISSUE WARNING MSG WHEN CHANGE FROM NON-LARGE TS TO LARGE AND NOT ADJUSTING LIMIT KEY OF LAST
PART
PM68245
24_Oct
2012
UK82915


CATALOG COPY / CC: PANEL ADB2CCJ 'CATALOG COPY METHOD' OPTION L=LOAD FROM CURSOR RESULTS IN UNLOAD/LOAD FOR CERTAIN
TABLESPACES
PM69854
24_Oct
2012
UK82921


DB2 ADMINISTRATION TOOL FOR Z/OS GENERATED UNLOAD LOB USING PDSE RESULTS IN LONG EXECUTION TMES AS COMPARED WITH USING
VBS
PM71547
24_Oct
2012
UK82923


PANEL ADB2AUS 'USER AUTHORIZATIONS SUMMARY' SHOWS MESSAGE 'AUTHORITY INCLUDES SYSCTRL ...' IN ERROR.
PM71812
24_Oct
2012
UK82925


ABENDU4038-1 ONCODE520 SUBSCRIPTRANGE CONDITION ENTRY POINT CONV_INFO_FOR_ADDED_COLS WHEN USING ALT FUNCTION
PM72630
24_Oct
2012
UK82943


DB2 OBJECT COMPARISON TOOL FOR Z/OS, RUNNING GOC2CMP RESULTS IN ABEND906-08.
PM73842
24_Oct
2012
UK82911


ALT IMAGECOPY STEP MESSAGE 'DSNU088I DSNUGTIS - INVALID CHARACTER OPERAND' WHEN COPYDDN TEMPLATE NAME SPANS COLUMN 72
PM60595
25_Sep
2012
UK82100


DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT GENERATE DROP FOR EXTRA INDEX ON TARGET DDL
PM61885
25_Sep
2012
UK82086


OPTIONS FIELDS IN PANEL ADB2UTC ARE INPUT INHIBITED AND CONTAIN RESIDUAL VALUES NOT HELPFUL FOR MIG MIGRATE FUNCTION
PM66747
25_Sep
2012
UK82088


GEN MSGADB1848W WHEN VIEW CONTAINS XML CONSTRUCTS.
PM67206
25_Sep
2012
UK82090


OC DROP / CREATE ON NUMPARTS DIFFERENCE IN DB2 V9 AND V10 CM9 MODE FOR PBG UTS ONLY WHEN NUMPARTS EXCEEDS 1 FFA20 PM72977
PM60792
25_Sep
2012
UK82088


MSGADB1932W PARSER ERROR - REASON CODE 28 ISSUED BY ADB2GEN INCORRECTLY MAY LEAD TO STORAGE EXHAUSTION
PM67776
25_Sep
2012
UK82091
PM76369

DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT PASS GROUP ATTACH NAMEAFTER APAR PM56278 USING SYSPROC.FFA20 PM73615
PM68774
25_Sep
2012
UK82093


DB2 ADMINISTRATION TOOL FOR Z/OS ENCOUNTERS SQLCODE = -199 AKA SQLCODEN199 DURING ALTER OPERATION OF FK (FOREIGN KEY) OF
TABLE
PM71293
25_Sep
2012
UK82091
PM76369

USING "HPU" TO UNLOAD TABLESPACE, CM CHANGE JOB GOT RC=8 AND ERROR MESSAGE "DB2 HPU NOT USING KEY 7,FFA20 PM73604
PM72755
25_Sep
2012
UK82092


DB2 ADMINISTRATION TOOL FOR Z/OS SETS SCHEMA NAME INCORRECTLY DURING DROP/CREATE TRIGGER RESULTS IN SQLCODEN204 FFA20
PM72882
PM67393
10_Sep
2012
UK81655


DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT GENERATE PROPER GRANT STATEMENT - FFA20 PM72781
PM68356
10_Sep
2012
UK81655


DB2 OBJECT COMPARISON TOOL FOR Z/OS GENERATES WHEN NOT EXPECTED "ALTER TABLESPACE TABLE SPACE NAME DSSIZE 4G" FFA20 PM72779
PM71021
10_Sep
2012
UK81664


RH RUNSTATS HISTORY COMMAND PANEL ADB21SPH 'SYSTABLEPART HIST FOR ' SHOWS INCORRECT VALUE OF -1 FOR SPACE AND ROWS COLUMNS.
PM71544
10_Sep
2012
UK81662


ALT EXTERNAL TABLE FUNCTION, ANALYZE JOB FAILED WITH 0012 WITH ADB0352E MODULE ADB2CMF DETECT AN ONCODE CONDITION 8094 ERROR
PM65512
10_Sep
2012
UK81651


DB2 ADMIN TOOL ALT COMMAND PRODUCES REBIND PACKAGE SYNTAX WITHOUT TRIGGER KEYWORD WHEN COMPLEX RI+TRIGGER FFA20 PM72650
PM67899
10_Sep
2012
UK81652


DB2 ADMINISTRATION TOOL FOR Z/OS RETURNS SQLCODEN802 WHEN USING 'TABLE SPACE MAINTENANCE RECOMMENDATIONS' FFA20 PM72647
PM70375
10_Sep
2012
UK81655


MESSAGE 'ADBC002E - SEVERE ERROR. COMPARE TERMINATES' RC12 AND NO ADDITIONAL INFORMATION AS TO THE CAUSE OF THE ERROR.
PM71366
10_Sep
2012
UK81661


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT ALLOW ON PANEL ADB2P2 TO RETAIN CHOICE FOR FIELD 'HLQ FOR LOB FILES'
PM67943
28_Aug
2012
UK81363


ADBTEP2 DSNU049I DSNUGPRS - INVALID OPERAND '.AAA' FOR KEYWORD 'CHECK'
PM61405
28_Aug
2012
UK81355


IBM INTERNAL APAR - VIEW W/ GARBAGE FOLLOWING TERMINATING (:) SEMICOLON FAILS, SQL STMT NOT COMPLETELY PARSED FFA20 PM69923
PM50056
28_Aug
2012
UK81352


MSGDSNR035I UNCOMMITED UR ISSUE WHEN USING GEN- FFA20 PM69923
PM64302
28_Aug
2012
UK81359


DB2 ADMIN TOOL DOES NOT PLACE SADBLINK LIBRARY IN THE STEPLIB GENERATED FOR CHECK DATA UTILITY DURING ALT PROCESS
PM66712
28_Aug
2012
UK81361


DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES SQLCODEN117 WHEN COMING FROM PACKAGE PANEL ADB21K INTO PANEL ADB2EL TO INSERT HINT
PM67084
28_Aug
2012
UK81366


RUNSTATS . SYSTABLEPART IS MISSING IN SAMP MEMBER ADBRUNSV
PM67091
28_Aug
2012
UK81362


IBM INTERNAL APAR ISSUE LINE COMMAND 'DI' ON PANEL ADB21TC, PANEL ADBCDI SHOWS INSTEAD OF PANEL ADB21CDT
PM68353
28_Aug
2012
UK81364


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT UPGRADE UID.PLAN_TABLEVERSION COL TO 122 CHAR DB2 9 NFM UT FUNCTION,FFA20 PM71813
PM61347
28_Aug
2012
UK81354


DROP / CREATE WITH HPU FORMAT INTERNAL FAILS RC08 MSGDSNU0498 INVALID OPERAND 'INTERNAL' FOR KEYWORD 'FORMAT' FFA20 PM69923
PM61527
28_Aug
2012
UK81352


GEN: 'GENERATE CATALOG STATS' SQLCODEN803 DBID, PSID AND PARTITION VALUES 0 FOR SYSTABLESPACESTATS AND SYSINDEXSPACESTATS
FFA20
PM63326
28_Aug
2012
UK81357


DB2 OBJECT COMPARISON TOOL FOR Z/OS MISSING SET CURRENT PATH STATEMENT THAT RESULTS IN SQLCODE -440 WHEN RECREATE UDF
PM63859
28_Aug
2012
UK81358


DB2 ADMIN TOOL RECEIVES IBM0441W ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED DURING DDL GEN PROCESS OF MANY OBJS
FFA20
PM68325
28_Aug
2012
UK81352


COMPARE JOB FAILS IN T01DB2, SQLCODE= -525 IN GENERATING THE STORED PROCEDURE. SQLCODEN525 FFA20 PM60792
PM70449
28_Aug
2012
UK81365


PANEL FLOW: END FROM PANEL ADB2DROW 'DISPLAY ROW' RETURNS TO PANEL ADB21 'SYSTEM CATALOG' RATHER THAN PANEL ADB21C'COLUMNS'.
PM57689
21_Aug
2012
UK81227


RC8 MESSAGE "MANUAL INTERVENTION IS REQUIRED TO RESOLVE THIS CONFLICT" WHEN KEEPTGT USED AND PROCESSING CONSTRAINT FFA20
PM66623
21_Aug
2012
UK81227


ALTER TABLESPACE MAXPARTITIONS FAILS SQLCODEN650 REASON 10 FFA20 PM69923
PM66696
21_Aug
2012
UK81227


DB2 OBJECT COMPARISON TOOL FOR Z/OS DOES NOT DETECT TABLESPACE TYPE CHANGE FROM LARGE TO NORMAL CORRECTLY
PM67504
21_Aug
2012
UK81227


DB2 OBJECT COMPARISON TOOL FOR Z/OS FAILS TO ALTER TRIGGERS WITHPROPER TIMESTAMP SEQUENCE,ENSURE PROPER EXEC SEQ FFA20
PM73422
PM68803
21_Aug
2012
UK81227


COMPARE DDL TO DDL FAILS ONCODE451 IN GOC2CMP ROUTINE SRC_INPUT AT STATEMENT 7798
PM69339
21_Aug
2012
UK81227


OC COMPARE WITH IGNORES,VALID FIELDS IN IGNORES ARE CONSIDERED AS INVALID FIELDS ENDING IN RC=08
PM64979
21_Aug
2012
UK81227


DB2 ADMIN TOOL GEN DOES NOT SUPPORT GENERATING STP DDL WHEN TEXTSTORED IN DDL HAS SQL COMMENT IN BEGINNING OF TEXT FFA20
PM69923
PM60543
10_Aug
2012
UK81004


DROP / CREATE FOR WSL FAILS ON LOAD WHEN UNLOAD GOES TO TAPE DEVICE - MSG VOLUME NOT AVAILABLE FOR UNLOAD DATASET
ULD.TNNNN
PM68436
10_Aug
2012
UK81012


MESSAGE ISPS105 INVALID KEYWORD'SHARED' IS NOT A VALID KEYWORD FOR THIS SERVICE.CURRENT DIALOG STATEMENT: VPUT (GETMODE)
SHARED
PM60648
10_Aug
2012
UK81006


REORG ON TABLESPACE WITH TEMPLATE GENERATES INLINE COPY
PM60359
10_Aug
2012
UK81003


PERFORMANCE QUERY PANEL ADB2314I DISPLAYS TOO MANY INDEXES AND NEEDS TO BE LIMITED
PM65177
10_Aug
2012
UK81008


DB2 ADMIN TOOL PANEL ADB2E OPTION CT CREATES WRONG DDL FOR PLAN_TABLE WHILE UNDER DB2 FOR Z/OS V8 NFM AND V10 CM8
PM65859
10_Aug
2012
UK81011


PANEL ADB21SA 'ALTER TABLE SPACE' SQLCODEN665 PGB / PARTITION BY GROWTH TABLESPACE FFA20 PM69923
PM68955
10_Aug
2012
UK81014


PANEL: ADBH1I 'HELP: DB2 INFORMATION FROM SYSIBM.SYSCOPY' AND PANEL ADB21II1 'INTERPRETATION OF AN OBJECT IN SYSCOPY' TYPE
L
PM69017
10_Aug
2012
UK81016


SELECT FCCPYDDN FOR FLASH COPY, IN GENERATED APPLY JOB, THE DEFINITION OF TEMPLATE FCCPYDDN MISSING GDGLIMIT 1 AND
PCTPRIME
PM58375
10_Aug
2012
UK81010


MSGADB3000E USING AUTOCHECK WITH "VALIDATE WSL" SET TO YES WHEN ALTERING OWNER OF AN INDEX WHERE RI IS PRESENT
PM65372
10_Aug
2012
UK81010


RENAME A TABLE THEN DELETE A PRIMARY KEY COLUMN, RECEIVES -205 ERROR IN CREATE INDEX STMT RUNNING CHANGES JOB.
PM64689
27_Jul
2012
UK80594


PANEL ADB2AZ 'SYSTEM PRIVILEGES AUTHORIZATIONS' REVOKE BY RESULTS IN SQLCODEN104 ILLEGAL SYMBOL "ACCESSCTRL"
PM65873
27_Jul
2012
UK80590


OBJECT COMPARE APPENDS REBUILD INDEX FOLLOWING TABLE UNLOAD / DROP / CREATE / LOAD
PM66994
27_Jul
2012
UK80591


ADD REBIND EXPLAIN(ONLY) FOR DB2 10
PM67611
27_Jul
2012
UK80592


MESSAGE 'UNKNOWN OBJECT TYPE' ADB9006I THE PROGRAM ADBCVOB COMPLETED ABNORMALLY. 12/06/26 PTF
PECHANGE
PM68886
27_Jul
2012
UK80593


WRONG DSN NAME IN MIGRATION JCL WHEN MIGRATING A DATABASE WITH NEW ADDED TEMPLATES.
PM63218
27_Jul
2012
UK80590


SQLCODEN478 DROP ON OBJECT TYPE PROCEDURE CANNOT BE PROCESSED BECAUSE OBJECT OF TYPE TRIGGER IS DEPENDENT ON IT.
PM66892
27_Jul
2012
UK80590


RC=20 "ADBCDTS DOES NOT SUPPORT TABLESPACE STATEMENT."
PM51774
15_Jul
2012
UK80305


TEMPLATE USAGE - DEFINITIONS FROM ADB25TU3 NOT USED BY OC EVEN THOUGH ADBH5TU SAYS "SPECIFY WHICH TEMPLATE WILL BE USED"
PM60256
5_Jul
2012
UK80058


BINDERROR PARAMETER IS NOT HANDLED CORRECTLY IN ADBTEPIN
PM63875
5_Jul
2012
UK80060


SQ COMMAND IN PANEL ADB21K DISPLAY FAILS FOR TRIGGER PACKAGE WHEN RUNNING UNDER DB2 V10 COMPAT MODE
PM66906
5_Jul
2012
UK80061


SQ COMMAND SQLCODEN452 ERROR: UNABLE TO ACCESS THE FILE REFERENCED BY HOST VARIABLE REASON 13 / SQLSTATE 428A1
PM62627
5_Jul
2012
UK80059


USING DB2 ADMIN TOOL FOR Z/OS DSN LINE COMMAND DISPLAYS DATA SET NAME FOR BASE TABLE ONLY BUT NOT FOR THE CLONE TABLE
PM66930
5_Jul
2012
UK80062


ALT: EXTRANEOUS DROP TABLE STATEMENT GENERATED AFTER FK COMMAND ISSUED ON PANEL ADB27CA.
PM54301
20_Jun
2012
UK79702


SQLCODEN662 ISSUED DUE TO INCORRECTLY GENERATED DDL DURING OBJECT COMPARE WHEN NUMPARTS AND SEGSIZE CONVERT TS TO UTS
PM59036
20_Jun
2012
UK79702


SET CURRENT SQLID STATEMENT MISSING WHEN RUN SQLID IS BLANK USING DB2 OBJECT COMPARISON TOOL FOR Z/OS 10.1.0
PM48221
19_Jun
2012
UK79667


DB2 ADMINISTRATION TOOL FOR Z/OS MIGRATE MISSING STEPLIB FOR REBINDS
PM61545
19_Jun
2012
UK79670


MSGISPT034 TABLE IS NOT OPEN RESULTS FROM ONLINE REORG USING LISTDEF AND SHRLEVEL CHANGE
PM63340
19_Jun
2012
UK79671


ERRONEOUS SQL IN CREATE, DROP, ALTER DATASETS 'WITH DEFAULT 'N':'
PM65191
19_Jun
2012
UK79674


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT KEEP ACROSS ITS SESSIONS VALUE SELECTED FOR 'GENERATE WSL' IN PANEL ADB28M
PM60687
19_Jun
2012
UK79669


CM IMPORT CHANGE RC20 ADB2CID - IMPORT CHANGES ADB2PA5.TOKENI ZE SYNTAX ERROR DURING STATEMENT SCAN. TEXT=? GRANT SELECT ON
PM63571
19_Jun
2012
UK79672


PANEL ADB2P2 FIELD 'QUERY TYPE FOR VIEWS' DOES NOT RETAIN CHOICE EVEN WHEN 'RESET TO DEF. AT STARTUP' NO S 12/05/02 PTF
PEREMOVE
PM64047
19_Jun
2012
UK79673


MESSAGE (A)FIELD COMPRESS CHANGED FROM NO TO NOINDEX WILL BE ALTERED
PM65847
19_Jun
2012
UK79675


DROP TABLE GENERATED AFTER RI COMMAND ISSUED ON TABLE ON ADB27CA, WHEN NON-TABLE OBJECTS ARE ALSO LISTED ON ADB27CA
PM60585
11_Jun
2012
UK79466


MESSAGE 'INVALID COMMAND' FOR BR LINE COMMAND ON PANEL ADB21I WHEN ICUNIT=T
PM63044
11_Jun
2012
UK79467


DB2 ADMIN TOOL FOR Z/OS GEN or DDL line commands fail with SQL Code -302 when commands used remotely from DB2 V9 to DB2 v10
PM63285
11_Jun
2012
UK79468


DB2 ADMIN TOOL FOR Z/OS WHEN CALLING AN SP WITH LOB OUTPUT PARAMETER RECEIVES SQLCODEN452 AND DATA SET ALLOCATION ERRORS
PM64169
11_Jun
2012
UK79468


DB2 ADMIN TOOL'S BROWSE PANEL ADB2BRIF DOES NOT SHOW NATIONAL X'41' CHARACTER WHEN USING CCSID 424
PM64174
11_Jun
2012
UK79470


ERROR RUNNING ADB21CDI, LINE 311: INVALID EXPRESSION FUNCTION SELECT CMD(%ADB21CDI ) RETCODE 20035 ZERRMSG ADB209
PM65132
11_Jun
2012
UK79469


PANEL ADB21 APPENDS % WILDCARD EVEN THOUGH LIKE OFF REQUESTED SQLCODEN104 WHEN OTHER CRITERIA VALUE CONTAINS QUOTED STRING
PM56606
24_May
2012
UK79042


ADBTEP2 BACKGROUND UTILITIES INTRODUCED BY APAR PM26759 DO NOT USE THE :UTILPRE GENERAL CUSTOMIZATION PARAMETER REORG HLQ
WRONG
PM56720
23_May
2012
UK78986


PANEL ADB2314 'TABLE SPACE MAINTENANCE' ALLOWS COMMANDS TO BE ISSUED AGAINST TABLE SPACES IN DATABASE DSNDB07 DSNU065I
PM56278
23_May
2012
UK78985
PM67776

SQL IN WSL JOBS THAT OMIT SSID PARM TO ADBTEP2 NOW FAIL ADB5008E EITHER THE SSID() OR PLAN= PARAMETER WAS NOT
PROVIDED
PM63811
23_May
2012
UK78989


MAKEPBG ISSUES: ALTER UNEXPECTED TOKEN IN CONSTANT LIST - EXPECTED COMMA OR RIGHT PAREN FROM ADB2PA AND SQLCODEN662
PM59384
23_May
2012
UK79038

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PM62291
27_Apr
2012
UK78295


COMPARE FAILS CC08 WITH (E)THE EXPLICIT LOB TABLE SPACE TSNAME IS STILL ASSOCIATED WITH AUXILIARY TABLE TABLENAME
PM34738
26_Apr
2012
UK78293


GEN/DDL CREATE VIEW HAS SCHEMA FROM TABLE NOT VIEW FOR OBJECTS DEFINED WITHOUT A QUALIFIER
PM52417
26_Apr
2012
UK78296


MIG FUNCTION IN ADMIN TOOL DOES NOT GENERATE DD FOR UNLOAD, AND PUNCHDDN HAS UNRESOLVED TSNAME USING & 11/11/22 PTF
PEREMOVE
PM53449
26_Apr
2012
UK78293


GEN ONCODE150 ONCODE340 ONCODE350 ABENDU4038 ABENDU4039 WHEN DB2 CATALOG HAS INVALID DATA FOR LIMIT KEY SQLCODEN104
PM40216
26_Apr
2012
UK78295


SQLCODEN478 DROP ON OBJECT TYPE FUNCTION CANNOT BE PROCESSED BECAUSE OBJECT OF TYPE FUNCTION IS DEPENDENT ON IT.
PM56378
26_Apr
2012
UK78295


NEW IGNORE KEYTARGET OPTION IS IGNORING BOTH SIMPLE AND EXTENDEDINDEX FROM COMPARISON INSTEAD OF JUST THE EXTENDED INDEX
PM60021
26_Apr
2012
UK78295


IGNORE FILE WITH GENERIC OPTION KEYTARGET RESULTS IN ADBC024E - UNEXPECTED CATALOG ROW ON SOURCE FILE. EXPECTED:IP FOUND:CO
PM60526
26_Apr
2012
UK78301


ADBTEP2 CONTROL FOR BACKGROUND REORG AND REBUILD UTILITIES FOR NON-ADVISORY PENDING STATES
PM60628
26_Apr
2012
UK78299

HIPER

PERFORMANCE OF THE V COMMAND ON PANEL ADB21
PM61613
26_Apr
2012
UK78301


CM BATCH JCL PROCEDURE PARMS
PM61935
26_Apr
2012
UK78299


DB2 10 ENFM9 PANEL ADB21 V VIEWS COMMAND SHOWS NO RESULTS.
PM61940
26_Apr
2012
UK78299


DB2 10 ENFM9 SQ COMMAND SHOWS NO RESULTS.
PM61947
26_Apr
2012
UK78293


GEN ADB1924E NO STATEMENT TEXT RECORD(S) FOUND FOR CREATE VIEW WHEN RUNNING IN DB2 10 ENFM9
PM61999
26_Apr
2012
UK78305


DB2 ADMINISTRATION TOOL FOR Z/OS MISCELLANEOUS ENFM9 FIXES.
PM57713
18_Apr
2012
UK78052


DB2 V8 NFM ZPARM VALUES SWAPPED DURING DISPLAY IN PANEL ADB2ZZMN MAXCUR AND MAX_UTIL VALUES ARE SWAPPED
PM58897
18_Apr
2012
UK78053


RECOVERY CHANGE FOR COMMA IS DECIMAL SUBSYSTEM LOAD UTILITY DISCARDS ROWS
PM58938
18_Apr
2012
UK78054


ABND=04E-00E70005 M=DSNTFRCV,LOC=DSNXGRDS.DSNXEPAR:M110 WHEN PROCESSING QUALIFIER """""""AAAAAAA""""""" IN PROCEDURE
PM60046
18_Apr
2012
UK78055


THE FORMATTING OF THE SOURCE CODE IN NATIVE STORED PROCEDURE CONTAINS ADDITIONAL LINES OF CODE USING DB2 ADMINISTRATION
TOOL
PM61024
18_Apr
2012
UK78056


U4038 / ABEND0C4 / IBM0534S ONCODE=8094 PROTECTION EXCEPTION L LINE COMMAND / BR COMMAND XML STRUCTURE.
PM58373
11_Apr
2012
UK77849


GEN/DDL CREATE PROCEDURE MISSING SYNTAX
PM59484
11_Apr
2012
UK77851


B BR BROWSE RESULTS IN ISPF ABEND0C6 IN ISPTASK
PM57527
11_Apr
2012
UK77848


WHEN USING GEN ON MQT ENCOUNTERED ERROR MESSAGE ADB1847E A PARSER ERROR OCCURRED FOR THE FOLLOWING MQT. REASON CODE =
8
PM60515
11_Apr
2012
UK77851


DB2 ADMINISTRATION TOOL FOR Z/OS DRIVER DOES NOT PROCESS PROPERLY SQLCODE +445 VALUE HAS BEEN TRUNCATED
PM51206
26_Mar
2012
UK77370


GEN: SQLCODEN713 LOWER CASE CHARACTER IN SCHEMA STATEMENT NOT ENCLOSED IN DOUBLE QUOTES.
PM59010
26_Mar
2012
UK77370


ALTER IS NOT CHOSEN WHEN COLUMN DEFINITION CHANGED FROM DECIMAL(M,N) TO DECIMAL(M,0) USING DB2 OBJECT COMPARISON TOOL
PM59247
26_Mar
2012
UK77370


SMART ALTER NOT GENERATED FOR ALT WHEN CHANGE IN DECIMAL VALUE IS REQUESTED BUT DROP/CREATE IS USED INSTEAD
PM50127
26_Mar
2012
UK77370


SQLCODEN204 DROP RESTRICT ON DROP DROP FOREIGN KEY
PM55334
22_Mar
2012
UK77278


SPACE MANAGEMENT / SM FEATURE SQLCODEN665 ALTER TABLESPACE PARTITION BY GROWTH
PM57673
22_Mar
2012
UK77289


PANEL ADB26CG ALLOWS SPECIFICATION OF A VOLUME WITH THE STRING '*'. A VOLSER OF '*' IS NOT VALID
PM55107
22_Mar
2012
UK77178


GEN FAILS SQLCODEN104 WHEN PBG TS HAS MORE THAN 1 PARITITION
PM55759
22_Mar
2012
UK77280


DROP IMPACT REPORT DOES NOT LIST SEQUENCE PACKAGES
PM59529
22_Mar
2012
UK77306


++HOLD INFO INCORRECT IN PM36340'S UK69177/UK69178 STATES 'OPEN PARENTHESIS' WHEN IT SHOULD STATE 'CLOSED PARENTHESIS'
PM31997
22_Mar
2012
UK77178


ORDER OF DEPENDENT OBJECTS IN GEN OUTPUT RESULTS IN SQLCODE440
PM56149
22_Mar
2012
UK77284

HIPER

PERFORMANCE OF V OPTION ON PANEL ADB21D
PM56159
22_Mar
2012
UK77285


SQLCODEN670 ON SYSPACKSTMT TABLE WHILE PERFORMING CATALOG COPY USING DB2 ADMINISTRATION TOOL V10.1 FOR Z/OS IN DB2 V10 CM8
PM57372
22_Mar
2012
UK77288


SQLCODEN4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE PANEL ADB2DDF "USE DDF TO ACCESS REMOTE CATALOG" DB2 10
PM58145
22_Mar
2012
UK77296


DB2 ADMINISTRATION TOOL FOR Z/OS V10.1 DOES NOT PROPOSE ALT BUFFER POOL AUTOSIZE WHEN USED UNDER DB2 V9 CM
PM58452
22_Mar
2012
UK77288


SORT COMMAND LINE COMMAND FOLLOWED BY SORT FIELDS SELECTION ON PANEL ADB2SORT RESULTS IN :ZERRMSG : ISPT106 VALUE TOO
LARGE
PM60243
22_Mar
2012
UK77177


VIRTUAL RESTART MARKERS ARE MISSING FROM GENERATED JCL
PM56486
22_Mar
2012
UK77287


ROWS OF A SQL TEXT EDITED IN THE EXPLAIN DIALOG IS TRUNCATED WHEN LEAVING PANEL ADB2E
PM58054
22_Mar
2012
UK77164


LISTDSI CC=19, IKJ58418I PARTIAL DATA SET INFORMATION NOT OBTAINED. IKJ58419I DATA SET RESIDES ON MULTIPLE VOLUMES.
PM49907
10_Mar
2012
UK76851

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS. 12/03/09 PTF
PEREMOVE
PM59040
10_Mar
2012
UK76851


GEN AND DDL ON JAVA SP OMIT JAVA_SIGNATURE
PM59629
5_Mar
2012
UK76649


INTERNAL APAR TO CORRECT JCLIN SHOPZ PROBLEM. 12/03/08 PTF
PECHANGE
PM40193
16_Feb
2012
UK76289


SQLCODEN478 DROP ON OBJECT TYPE PROCEDURE CANNOT BE PROCESSED BECAUSE OBJECT OF TYPE TRIGGER IS DEPENDENT ON IT.
PM39767
16_Feb
2012
UK76288
PM67611

SQLCODEN478 DROP ON OBJECT TYPE FUNCTION CANNOT BE PROCESSED BECAUSE OBJECT OF TYPE TRIGGER IS DEPENDENT ON IT.
PM39863
16_Feb
2012
UK76288
PM67611

ALT PANEL ADB21XAS "REDEFINE INDEX - SPACE" FIELD "PART" INPUT PRIQTY AND SECQTY 999 VALUE ROUNDED TO 1000 AND APPLIED TO
ALL
PM55039
13_Feb
2012
UK76134


SQLCODEN206 ERROR: TS.MAXPARTITIONS IS NOT A COLUMN SPACE MANAGEMENT / SM FUNCTION PANEL ADB2M 11/12/27 PTF
PECHANGE
PM49130
13_Feb
2012
UK76125


GEN 'MISSING SEMICOLON AFTER TRIGGERED ACTION' TOKEN = INTO TRIGGER SUBSTR(CHAR(CURRENT TIMESTAMP),25,2) ADB1847E
ADB1848W
PM49142
13_Feb
2012
UK76127


LARGE NUMBER OF BIND OR REBIND COMMANDS ( 1000+ ) RESULTS IN NO JCL AND NO MESSAGES MULTIVOLUME ZTEMPN EXEC ADB2W1
PM52430
13_Feb
2012
UK76132


ADB1602E NO VOLUMES FOUND FOR STOGROUP= WHEN RELCREATED IS BLANK AND STOGROUP HAS NO VOLUMES CLAUSE, USED VCAT AND DATACLAS
ONLY
PM55492
13_Feb
2012
UK76132


IMPORT A CHANGE, THEN REGISTER AS A NORMAL CHANGE, BUT GET RC=20WHEN REGISTERING CHANGE, NO MATTER USING TSO OR BATCH MODE.
PM56146
13_Feb
2012
UK76136


DROP IMPACT REPORT / 'REPORT DROP IMPACTS' OPTION ON PANEL ADB26DT DOES NOT REFLECT 'REPORT DROP IMPACTS' OPTION ON PANEL
ADB2P2
PM46865
6_Feb
2012
UK75982


DSNUPROC LIB= STATEMENT MISSING WHEN CO'ED TO REMOTE LPAR
PM47312
6_Feb
2012
UK75982


LISTDEF DB2 UTILITY DUPLICATE TABLE(ALL) STATEMENTS DSNU082I DSNUGPPP - INVALID KEYWORD - TABLE
PM56369
6_Feb
2012
UK75975


SAMPLIB MEMBER ADBCHANG DELIVERED CONTAINS DUPLICATE ALTER STATEMENTS AND THUS MISSING ONE ALTER
STATEMENT
PM52853
6_Feb
2012
UK75980


PANEL ADB21S 'TABLE SPACES': REPEATED COMMAND RTS SHOWS ONLY THELAST OBJECTS INFORMATION
PM54260
6_Feb
2012
UK75973


SORT ROWS COMMAND LINE COMMAND: ZERRMSG : ISPT106 VALUE TOO LARGE
PM44926
6_Feb
2012
UK75982


ALT PRIMARY INDEX SCHEMA CHANGE TABLESPACE CHKP CHECKPENDING STATUS AFTER CHANGE AS NO DB2 CHECK UTILITY BUILT SQLCODE162
PM50942
6_Feb
2012
UK75982


ALT OF PQTY ONLY CAUSED DROP / CREATE INSTEAD OF ALTER
PM55878
6_Feb
2012
UK75974


ON PANEL ADB21K THE COMMAND PLANMGMT DOES NOT EXIST IN DB2 V9 CM. THE OPTION APPEARS ON ADB21KR PANEL
PM44298
6_Feb
2012
UK75980


PANEL ADB21S UTL LINE COMMAND SLOW PERFORMANCE, EXCESSIVE INSERT/ GETPAGE ACTIVITY GTT SESSION.DB2T001
PM47337
6_Feb
2012
UK75968


PANEL ADB2USOF 'OFFLINE UTILITIES PARAMETERS' FULLCOPY FIELD YES HOWEVER SYSUT1 HAS UNDERLYING DB2 VSAM DATASET NOT
IMAGECOPY
PM48735
6_Feb
2012
UK75982


ALLOCATION OF DATASETS FOR *.DDL.CREATE AND "*.DDDL" MAY RESULT IN B37.
PM49035
6_Feb
2012
UK75980


PANEL ADB2DIP 'DROP IMPACT ANALYSIS SUMMARY' MESSAGE 'WARNING: UNABLE TO EXTRACT CATALOG RECORDS. CHECK BIND.' LOB
TABLESPACE
PM53900
6_Feb
2012
UK75982


DUPLICATE IMAGECOPY TEMPLATE IKJ56893I / IGD17101I NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN CATALOG
PM56252
6_Feb
2012
UK75979


PANEL ADB21TI1: MESSAGE ADB21TI1 CONVERSION OR TRUNCATION PROBLEM FOUND WHILE ATTEMPTING TO STORE VARIABLE 'REFRESH'
PM52787
19_Jan
2012
UK75571


SYNTAX ERROR 40 IN ADB21KSQ SYSNNNNN: INCORRECT CALL TO ROUTINE - LINE NNN: DB2LENGTH = C2D(SUBSTR(STMT,1,4))+4
PM53320
19_Jan
2012
UK75573


PANEL ADB21KI1 DOES NOT DISPLAY INHERITFROMPLAN AS IT SHOULD WHEN PACKAGE IS BOUND WITH RELEASE(INHERITFROMPLAN)
PM55599
19_Jan
2012
UK75570


ON PANEL ADB2USR9 ( UTILITY OPTIONS FOR RUNSTATS ) THE PARAMETERNUMQUANTILES DOESN'T APPEAR WHEN USED WITH DB2 V9 CM
PM55501
19_Jan
2012
UK75569


PANEL ADB2USM 'SPECIFY UTILITY OPTIONS - MODIFY' DOES NOT SHOW ALL AVAILABLE OPTIONS WHEN RUNNING UNDER DB2 9 CM
PM52494
10_Jan
2012
UK75309


GEN MISSING STORED PROCEDURES CAUSED BY TRAILING X'20' IN SYSIBM.SYSROUTINES.SCHEMA COLUMN
PM54032
10_Jan
2012
UK75311


LOAD FAILS ON ADBCHKPT TABLE RC08 DURING ADMIN MIGRATION FROM V720 TO V10
PM51314
10_Jan
2012
UK75307


SQLCODEN104 IF SAMPLE JOB ADBPRHIS IS RUN ON DB2 RELEASE LOWER THAN 10
PM51391
10_Jan
2012
UK75308


ENHANCE PANEL ADB2CUS1 FOR MORE THAN ONE TLIB
PM52629
10_Jan
2012
UK75308


SEMICOLON IS MISSING AFTER GENERATED TEMPLATE IN RUN WSL IN CASE AUTOCHECK YES IS USED.
PM46379
10_Jan
2012
UK75308


MSGADBC130E ALTER REQUEST AND LOAD STMT DO NOT MATCH CC1012 RC1012 ON CONVERT JOBSTEP ROUTINE ADB27AC
PM47436
22_Dec
2011
UK75066


GEN OF VIEW WITH MASKING DOES NOT CHANGE THE TABLE OWNERS TO THE NEW OWNER
PM50293
22_Dec
2011
UK75069


DEFAULT FOR A COLUMN AS U FOR USER OR S FOR SQLID DOES NOT WORK AS EXPECTED
PM51233
22_Dec
2011
UK75070


MSGIRX0040I ERROR RUNNING ADB2DIP WHEN REPORTING DROP IMPACT ON DATABASE
PM52217
22_Dec
2011
UK75063


PANEL ADB21T SHOWS A ROW FOR EACH SEQNO A VIEW / TYPE = 'V' HAS 12/01/23 PTF
PECHANGE
PM53444
22_Dec
2011
UK75076


DRIVER DOES NOT SUPPORT DECFLOAT VALUES
PM53257
22_Dec
2011
UK75075


NEW OBJECT GRANT STATEMENTS NOT PROPAGATED ADB1873E PROCESSING ENDED BUT NOT ALL SUPPLIED CATROWS WERE USED
PM45383
22_Dec
2011
UK75063


PANEL ADB21T PROTOTYPING SEL COMMAND FAILS SQLCODEN551 ON OBJECT SYSIBM.SYSCOLUMNS
PM48078
22_Dec
2011
UK75078


CATALOG COPY FEATURE 'L=LOAD FROM CURSOR' METHOD LOAD DSNU344I UNIQUE INDEX KEY DUPLICATES KEY OF INDEXED RECORD SYSOBJ
PM48436
22_Dec
2011
UK75068


ADB27SP, LINE 80: ADB27PAR = DUP0001 /* PARTITIONS */ * ADB2U, LINE 1435: SPC = MAX(SPC,ADB27HUR) /* USE GREATER OF RETCODE
40
PM51885
22_Dec
2011
UK75072


MESSAGE "INCORRECT TABLE FORMAT"/"THE TABLE UTLISTE DOES NOT HAVE THE EXPECTED COLUMN NAMES, DATA TYPES 11/11/09 PTF
PECHANGE
PM51901
22_Dec
2011
UK75079


GEN COMMAND FOR SP GENERATES DDL WITH NEXTVAL IN DOUBLE QUOTES, WHICH IS WRONG. THERE SHOULD NOT BE ANY DOUBLE QUOTES.
PM52845
22_Dec
2011
UK75073


ISPP121 PANEL 'ADB25LEA' ERROR PANEL DEFINITION TOO LARGE, GREATER THAN SCREEN SIZE 24X80 11/11/23 PTF
PECHANGE
PM53081
22_Dec
2011
UK75074


WSL STOPS WITHOUT MESSAGE / SQLCODEN501
PM48413
8_Dec
2011
UK74613


INDEX CHANGE TO/FROM AUXILIARY TABLE NOT SUPPORTED" ADBC002E SEVERE ERROR. COMPARE TERMINATES RC12
PM50673
8_Dec
2011
UK74611


ADBTEP2 AUTO REBIND SYNTAX RESULTS IN DSNE964E DSNECP55 FOR PACKAGE KEYWORD PARAMETER ( SPACES BETWEEN NAMES )
PM45448
8_Dec
2011
UK74613


OC TERMINATES WITH RC=12 WHEN COMPARING INDEXES.
PM48186
8_Dec
2011
UK74613

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PM48316
8_Dec
2011
UK74613


COMPARE WITH RECREATE OF XML TABLESPACE USES GBPCACHE UNKNOWN RESULTING IN RC8
PM51449
8_Dec
2011
UK74595


DOCUMENTATION UPDATE AND ++HOLD(DOC) NEEDED FOR NEW FUNCTION INTRODUCED IN APAR PM22869 FOR ADBCHANU TO UPDATE CM
PM43167
23_Nov
2011
UK74145


WRONG VIEW CREATOR WHEN USING IMPORT USING BATCH FOR PREREQ RESOLUTION MODE AND EXECUTION MODE
PM43984
23_Nov
2011
UK74148


REP COMMAND INVALID INPUT FROM FILE(IN) IGNORED. VERIFY INPUT INVALID VALUE IS: ACTVCNTL = '' RC4
PM44630
23_Nov
2011
UK74152


REBIND TRIGGER PACKAGE FAILS DSNT264I DSNTBRB2 REBIND ERROR PACKAGE IS A TRIGGER PACKAGE AS TRIGGER KEYWORD MISSING.
PM45146
23_Nov
2011
UK74154


DB2 ERRORS LIKE SQLCODEN204 -204 DUE TO TRUNCATED SQL STATEMENT WHEN RUNNING SQL FROM FB LRECL(80) DATASET
PM48687
23_Nov
2011
UK74158


Z.2D CAN THREAD PANEL ADB2Z2D2 DISPLAY/CANCEL THREADS MSGDSN9028I KEYWORD 'THD' PARAMETER(S) MUST BE NUMERIC
PM44189
23_Nov
2011
UK74150


TEMPLATE SPACE CALCULATION USES TS SIZE, INSTEAD OF TABLE SIZE.
PM45705
23_Nov
2011
UK74156


CREATING A TABLE WITH CHAR AND VARCHAR COLUMNS IN AN EXISTING TABLESPACE USING CCSID UNICODE,COLUMNS ARE CREATED
INCORRECTLY
PM49343
23_Nov
2011
UK74151


CHANGE MANAGEMENT/CM SQLCODEN660 ON CREATE INDEX AFTER NUMPART CHANGE
PM40828
23_Nov
2011
UK74144


SQLCODEN204 CREATE VIEW SEQUENCE ERROR
PM44551
23_Nov
2011
UK74151


ALT FUNCTION U/UPDATE LINE COMMAND PANEL ADB27C CHANGE TO 'WITH DEFAULT" RESULTS IN "NO CHANGES" MESSAGE ON PANEL ADB27CA
PM47042
23_Nov
2011
UK74161


ADBTEP2 ADB5146E UNEXPECTED SQLCODE IN :FETCH AC_CSR1 SQLCODEN911 WHEN RESTARTING WORKLIST / WSL
PM48292
23_Nov
2011
UK74157


SQLCODEN616 DROP LOB TABLESPACE / RENAMETB FOR AUX TABLE
PM41334
10_Nov
2011
UK73724


CHANGING FROM 'PARTITION BY GROWTH TS' TO 'INDEX PARTITIONED TS'WITH 'NO SEGSIZE' IGNORE OPTION RESULTS IN SQLCODEN763.
PM46964
10_Nov
2011
UK73725


SQLCODEN104 PANEL ADB21K SQ LINE COMMAND TSO PROFILE NOPREFIX
PM48045
10_Nov
2011
UK73727


DB2 10 IN COMPATABILITY MODE / CM SQLCODEN199 GRANT PUBLIC AT ALL LOCATIONS GEN
PM44830
3_Nov
2011
UK73542


PANEL ADB21PB AND ADB21PR FIELD ENABLE DISABLE NOT ALL INFORMATION SHOWN AND INPUT LIMITED TO 8 CHARACTERS
PM45115
3_Nov
2011
UK73536


ALT ADDING A COLUMN TO CCSID UNICODE TABLE RESULTS IN "FOR SBCS DATA" RATHER THAN "FOR MIXED DATA"
PM50136
3_Nov
2011
UK73540


PANEL ADB25TC VOLCNT FIELD TOO SMALL CAN NOT INPUT A THREE DIGITNUMBER / MAXIMUM ALLOWABLE VALUE OF 255
PM46648
3_Nov
2011
UK73538


SAMPLE JOB ADB2UCU1 COMMENT INCORRECTLY DESCRIBES IT AS MEMBER ADB2UCU5
PM48329
3_Nov
2011
UK73539


PANEL ADB21TSE TO PANEL ADB2DF THEN F3 SHOWS PANEL ADB2E1 SQLCODEN104 ILLEGAL SYMBOL "S".
PM50241
3_Nov
2011
UK73542


TRUNCATION OF BIND/REBIND PLAN ENABLE() OPTIONS 'CICS BATCH' TRUNCATED TO 'BATCH CI' OR 'CICS BAT' PANEL ADB21PB OR ADB21PR
PM26591
27_Oct
2011
UK73287


REVOKE IMPACT REPORT DOES NOT CORRECTLY IDENTIFY PACKAGES THAT WILL BE INVALIDATED WHEN BOUND IN A LOWER DB2 LEVEL - DB2 9
& 10
PM46102
27_Oct
2011
UK73292


DDL OR GEN ON TRIGGER GETVARIABLE('SYSIBM.PLAN_NAME') RESULTS INUNEXPECTED TOKEN AFTER 'SYSIBM.PLAN_NAME' KEYWORD - EXPECTED
PM45205
27_Oct
2011
UK73290


DD - DISTRIBUTED DB2 SYSTEMS OPTION CO SQLCODEN30080 COMMUNICATION ERROR 0048 AFTER ABEND=04E REASON=00D3003B
PM49010
27_Oct
2011
UK73294


PANEL ADB2C2L MESSAGE 'INVALID VALUE' FOR TYPE TSBPNAME OR IXBPNAME
PM33353
27_Oct
2011
UK73292


COMPARISON FINDS A DIFFERENCE BETWEEN FULLY QUALIFIED PREDICATE VS UNQUALIFIED PREDICATE
PM44943
27_Oct
2011
UK73289


COMPARE FAILS RC08 WHEN SEGSIZE AND MEMBER CLUSTER ARE USED MSGGOC2CMP - ERROR(S) FOUND. PLEASE REVIEW OUTPUT
PM50413
20_Oct
2011
UK73063


JCL ERROR WHEN SUBMIT THE ANALYZE RECOVER CHANGE JOB, WRONG DATASET LIST IN THE JCL.
PM44998
17_Oct
2011
UK72995
PM51885
PM52845

HELP PANEL UPDATES.
PM44550
17_Oct
2011
UK72995
PM51885
PM52845
HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PM33906
8_Oct
2011
UK72756


MESSAGE ANALYSIS ENDED WITH RETURN CODE = 12. USE TSO ISRDDN TO CHECK THE FILE CONTENTS.ADBALT RC12
PM46457
8_Oct
2011
UK72756


MSGADB5031W 'NO STATEMENTS WERE FOUND THAT CAN BE RUN' ADMIN DROP INDEX CHG FILE INDEX <SCHEMA>.<IXNAME> WILL BE DROPPED
PM47088
8_Oct
2011
UK72756


MQT ATTRIBUTE NOT RETAINED WHEN CREATE TABLE / ALTER TABLE ADD MATERIALIZED QUERY DDL USED.
PM47778
8_Oct
2011
UK72756


ALTER PARTITIONING KEY OF TABLE WITH LOB COLUMN(S) RESULTS IN SQLCODEN20182
PM48432
8_Oct
2011
UK72756


SQLCODEN204 ALTER PROCEDURE AS ALTER OCCURS BEFORE CREATE PROCEDURE
PM47949
30_Sep
2011
UK72487


PANEL ADB25TC VOLCNT FIELD TOO SMALL CAN NOT INPUT A THREE DIGITNUMBER / MAXIMUM ALLOWABLE VALUE OF 255
PM29194
30_Sep
2011
UK72510


GEN/DDL SQLCODEN109 BECAUSE OF MEMBER CLUSTER KEYWORD IN DB2 9
PM43630
30_Sep
2011
UK72494


RC=1012 (V7.2) 1016 (V10.1) DURING REGISTER OF CHANGE DUE TO PARSER ERROR
PM43932
30_Sep
2011
UK72512
PM52217

OPTION 2:3 BUILD SQL PROTOTYPE ALLOWS SEL ON AUXILIARY TABLES RESULTING IN SQLCODEN766
PM45653
30_Sep
2011
UK72496


ANALYZE FAILS WHEN CHANGE FOUND IN INDEX CHANGE FROM TYPE 2 TO PARTITIONING RC=12 MSGADB3009E 11/08/12 PTF
PECHANGE
PM37241
30_Sep
2011
UK72498


DUPLICATE STEP NAMES WHEN PROCESSING MORE THAN 99 UNLOADS
PM46441
30_Sep
2011
UK72512
PM52217

SET PROMPT OFF AND AFTER SMART ALTER, NO MSG "ALTER STMT EXECUTED " TO INDICATE THAT THE ALTER WAS SUCCESSFUL.
PM37826
30_Sep
2011
UK72493


IBM0441W ONCODE=150 THE STRINGSIZE FROM ENTRY POINT PUT_DDL / FROM ENTRY POINT NOTIFY_REBIND_PKGS
PM44686
30_Sep
2011
UK72498


PANEL ADB2UTC CARRIED OVER IN .CNC RESULT IN MSGDSNU070I KEYWORD OR OPERAND 'STATISTICS' INVALID WITH 'RESUME(YES)'
PM46038
30_Sep
2011
UK72498


A 2ND ALTER OF A TABLE OR TABLE SPACE RESULTS IN A LOST PLAN PROBLEM.
PM47868
30_Sep
2011
UK72490


DB2 ADMINISTRATION TOOL FOR Z/OS CHECKPOINT RESTART PROBLEM
PM48322
30_Sep
2011
UK72512
PM52217

PANEL ADB2ELIH 'UPDATE OPTIMIZER HINT' RESULTS IN UPDATE PLAN_TABLE SET STATEMENT WITHOUT A WHERE CLAUSE
PK97520
21_Sep
2011
UK72125


MIG IDENTITY COLUMN PROCESSING START WITH VALUE AND SQLCODEN803 ON INSERT PROCESSING WHEN IDENTITY COLUMN VALUE DEFAULTS
PM44838
21_Sep
2011
UK72130


PANEL ADB21T K - 'SHOW PACKAGES ON TABLE' LINE COMMAND DOES NOT RETURN TRIGGER PACKAGES
PM40942
21_Sep
2011
UK72129


MSG "DB2 V810 UNSUPPORTED" / "DB2 VERSION 810 IS NOT SUPPORTED BY THIS VERSION OF THE PRODUCT" WHEN INCORRECT PLAN SPECIFIED
PM42811
21_Sep
2011
UK72124


OPTION 15 IS MISSING FROM PANEL ADB23 (PERFORMANCE QUERIES)
PM44400
21_Sep
2011
UK72129


ABEND0C4 ABENDU4088 ADBMAIN WHEN USING BR LINE COMMAND ON PANEL ADB21T
PM36033
13_Sep
2011
UK71850

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS. 11/09/13 PTF
PEREMOVE
PM46813
1_Sep
2011
UK71527


MISSING QUOTES IN LIB PARAMETER OF CHECK DATA STEP
PM27643
31_Aug
2011
UK71423
PM59629

COMPARE WHICH WILL DROP/RECREATE MQT DOES NOT CREATE MQT INDEX
PM43636
31_Aug
2011
UK71425
PM55039

INCORRECT TOTAL NUMBER OF ROWS SHOW UP IN SM - SPACE MANAGER.
PM40975
31_Aug
2011
UK71423
PM59629

DSNU1212I DSNUUUFA- INVALID FIELD NAME <COLNAME> FOR TABLE WHEN USING RENAMECOL MASK
PM44825
31_Aug
2011
UK71427


CREATE TABLESPACE WITH MEMBER CLUSTER AND SEGSIZE 4 IS NOT ALLOWED.
PM41855
31_Aug
2011
UK71423
PM59629

ADBTEPA SWITCHING NOT WORKING PROPERLY
PM42495
31_Aug
2011
UK71423
PM59629

ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUAL INTFIN: <BLANK> C001 : <COL-NAME>
PM45106
31_Aug
2011
UK71423
PM59629

RUNSTATS NOT EXECUTED ON LOB TABLE SPACES WHEN ADDING A COLUMN FROM OC
PM45846
31_Aug
2011
UK71423
PM59629

RUNNING A COMPARE JOB GETS A RC=8, EXEC ADBGAJOB ENDS WITH ERRORMESSAGE "NOVALUE CONDITION RAISED FOR VARIABLE RUNPROF"
PM34981
31_Aug
2011
UK71423
PM59629

ALT PANEL FLOW AND MISSING ALTER STATEMENTS WHEN AMENDING IDENTITY COLUMN ATTRIBUTES
PM44634
31_Aug
2011
UK71423
PM59629

SET CURRENT SQLID AFTER ALTER / DROP RESULTING IN SQLCODEN551
PM45798
31_Aug
2011
UK71423
PM59629

T02COMP FAILS CODE 8FC6 ONCODE 612 THE CONVERSION CONDITION WAS RAISED BECAUSE A CONVERSION ERROR OCCURED.
PM28602
30_Aug
2011
UK71414


GEN RC04 ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE PARSED. IMPLICIT
TABLES
PM43370
30_Aug
2011
UK71414


GEN SCHEMA OWNER FOR STOGROUP, DATABASE AND TABLESPACE TO CHANGETO CURRENT SQLID
PK64957
30_Aug
2011
UK71414


AL/REF OF A TABLESPACE WITH A TABLE WHICH HAS A GENERATED BY DEFAULT AS IDENTITY COLUMN RESULTS IN DUPLICATE DATA
PM35262
30_Aug
2011
UK71414


UNCOMMITED UR ISSUE WHEN USING GEN
PM39861
30_Aug
2011
UK71423
PM59629

LISTDEF IS NOT DEFINED FOR RUNSTATS WHEN USING ALC ON A TABLE TOADD A PARTITION.
PM42215
30_Aug
2011
UK71416


WSL FAILS ADB5146E UNEXPECTED SQLCODE IN :INSERT ADBCHK WITHOUT ANY ADDITIONAL MESSAGES.
PM45602
30_Aug
2011
UK71416


ADBTEP2 GIVES "ADMIN IF DEFINEYES TB" AS FALSE, BUT THE TABLESPACE WHICH CONTAINS THE TABLE HAS DEFINE YES.
PM40962
30_Aug
2011
UK71423
PM59629

CMD.REBIND DATASET MSGIEF861I RESERVED DATA SET NAMES UNAVAILABLE FOR DATASET <PREFIX>.<WORKLIST>.CMD.REBIND
PM45038
30_Aug
2011
UK71414


-644 RUNNING WSL FOR ALTER TABLESPACE MAXROWS 0 PRIQTY 0 SECQTY 0 PCTFREE 0
PM34686
22_Aug
2011
UK71059


MIG GENERATES TARGET SUBSYSTEM JOB USING ADBTEP2 LIB PARM FROM LOCAL (SOURCE) SUBSYSTEM
PM41929
22_Aug
2011
UK71062


ADBC099E: WSL MISMATCH. THE WSLS DID NOT COMPARE EQUALLY, FAILURE OCCURRED IN CM RUN JOB.
PM42808
22_Aug
2011
UK71061


PANEL ADB2E MISSING OPTION 4 DSN_STATEMENT_CACHE_TABLE
PM42840
22_Aug
2011
UK71062


ANALYZE WITH UO OPTION R ON RUNSTATS FAIL ON VALIDATE WSL WITH SQLCODEN104
PM38423
11_Aug
2011
UK70727


SQLCODEN206 WHEN EXECUTING VIEW DDL CREATED BY GEN IF THE "RUN SQLID" OPTION IS USED.
PM35971
11_Aug
2011
UK70724


ANALYZE ABENDS RC=8 WHEN PARTITION > 254 WITH COMPRESSION
PM41333
11_Aug
2011
UK70729


ADB3000E ERROR PROCESSING SYNONYM <SCHEMA>.<SYNNAME> IN CREATE STATEMENT: OBJECT ALREADY EXISTS RC=8 VALIDATE WORK STATEMENT
PM42646
11_Aug
2011
UK70732


RE RF RO RJ FUNCTIONS MISSING FROM PANEL ADB26.
PM42852
11_Aug
2011
UK70734


ADB5146E UNEXPECTED SQLCODE IN :SELECT SYSTABLEPART DEF2 SQLCODE -304 / SQLCODEN304 11/07/18 PTF
PECHANGE
PM35402
11_Aug
2011
UK70722


INDEX SECQTY SET TO 0 WHEN THESE IGNORE OPTIONS ARE USED
PM37888
11_Aug
2011
UK70726


ADB0351E MODULE : ADB2CMP DETECTED AN ONCODE CONDITION 9999 AT ADB2DICT_FREE / ADB0380E MODULE ADB2CMP - SEVERE ERROR
COMPARE
PM41162
11_Aug
2011
UK70738


WSL APPLY JOB LOAD RELATED DD NAMES DCB SPACE(1,50) CYL RESULTS IN ABENDX37
PM36028
30_Jul
2011
UK70330

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PM39439
30_Jul
2011
UK70329


ADB2WVL ENDS RC=00 HOWEVER CREATE VIEW DDL CONTAINS DELETED COLUMN SQLCODEN158 DSNT408I SQLCODE -158 NUMBER COLUMNS NOT
SAME
PM30189
19_Jul
2011
UK69916


CLONE WSL WITH MASK OF DATASET NAMES REFERENCES DSN THAT IS NOT BUILT BY THE CLONE PROCESS
PM30561
19_Jul
2011
UK69918


ADB2UTIL FAILS RC20 RSN56 ABENDU4038 CALLING DB2 UTILITY
PM35522
19_Jul
2011
UK69920


MISSING SEMI-COLON AFTER SQL_VARIABLE_DECLARATION GOC2DTC - UNSUCCESSFUL COMPLETION
PM42607
19_Jul
2011
UK69927


GEN PROCEDURE FAILS RC08 WITH MESSAGE 'INVALID TOKEN AFTER FOR KEYWORD - EXPECTED KEYWORD UPDATE-, READ_ONLY-, ETC. CLAUSE'
PM37193
19_Jul
2011
UK69924


LAUNCHPAD COMMAND STRING FOR DB2 OBJECT COMPARE TOOL FOR Z/OS PANEL GOCMENU FAILS
PM37580
19_Jul
2011
UK69926


PANEL ADB21PB "BIND APPLICATION PLAN" MESSAGE "INVALID COMMAND" "VALID COMMANDS ARE: EMEM, ELIB, EPACK" WHEN EPACK ENTERED
PM38254
19_Jul
2011
UK69922


CATALOG COPY FUNCTION INCORRECT TABLESPACE NAMES I.E. NOT CCNNKXX AS DOCUMENTED IN THE USER'S GUIDE AND HELP PANEL ADBHCCJ
PM41217
19_Jul
2011
UK69923


MESSAGE IEC142I 113-44 MAY BE RECEIVED RUNNING PROGRAMS ADBTEP2,ADBTEPX, ADBALT, ADBSR OR GOC2CMP
PM37993
13_Jul
2011
UK69721


SM COMPRESSION RATIO SHOULD BE SET TO 0 SINCE SM USES AVG ROW SIZE 11/04/28 PTF
PECHANGE
PM41806
12_Jul
2011
UK69661


INHERITFROMPLAN SUPPORTED FOR THE RELEASE, DEFER AND IMMEDWRITE OPTIONS ON BIND AND REBIND PACKAGE.
PM40615
12_Jul
2011
UK69660


ADB3009E ERROR PROCESSING INDEX IN CREATE STATEMENT: NUMBER OF INDEX PARTITIONS DOES NOT MATCH..OR SQLCODEN644 IF EXECUTED
PM42183
12_Jul
2011
UK69687


INCORRECT NAMES SHOWING IN DB2 COMMANDS AND DB2 UTILITY STATEMENTS -STA DB(NOT NULL)| UNLOAD TABLESPACE NOT NULL.
PM36952
12_Jul
2011
UK69660


ONCODE 8094 DDL/DDL COMPARE OR VERSION FILE/VERSION FILE COMPAREOF TABLESPACE
PM42016
12_Jul
2011
UK69660


SOURCE TABLE (TABLE-BASED PARTITION) VS TARGET TABLE (INDEX- BASED PARTITION) DROPS/RECREATES PARTITIONING INDEX
PM42232
12_Jul
2011
UK69669
UK69670


SET CURRENT SCHEMA MISSING FROM INITIAL CREATE TRIGGER
PM42531
12_Jul
2011
UK69687


DB2 OBJECT COMPARE WHEN TABLE IS REFERENCED BY MQT, PARTITIONINGKEYS CANNOT BE ALTERED (MQT SHOULD BE DROPPED/RECREATED).
PM40836
5_Jul
2011
UK69460


DROP IMPACT REPORT PANEL ADB2DIPD "DROP IMPACT ANALYSIS DETAILS" EXPLICITLY CREATED LOB TABLESPACE SHOWN WHEN DROPPING BASE
PM36340
27_Jun
2011
UK69177


BATCH WSL SYSPRINT DSN NOT RETRIEVED FROM ADB2UCUS
PM36500
27_Jun
2011
UK69179


PANEL ADB2ZZMN "SYSTEM PARAMETERS - SYSTEM PARAMETERS" MESSAGE "VALUE OUT OF RANGE" FOR DSMAX / FIELD TOO SMALL NFDB29
PM37056
27_Jun
2011
UK69181


PARSING ISSUE ON TRIGGER WHEN GEN IS USED AND @ IS USED AS TERMINATOR
PM40299
27_Jun
2011
UK69173


PANEL ADB21SS "REAL-TIME STATISTICS FOR TABLE SPACE" SHOWS TWO ROWS IF A CLONE TABLE EXISTS I.E INSTANCE GREATER THAN 1
PM39932
27_Jun
2011
UK69184


ADB5121E COMMAND FAILED:RUN PROGRAM(ADB27AC) ONCODE=340 FROM ENTRY POINT INIT_CONV_CONTROLS AT STATEMENT 6867
PM41185
27_Jun
2011
UK69185


PANEL ADB2AO "STORED PROCEDURE AUTHORIZATIONS" SQLCODEN204 ON GRANT EXECUTE ON PROCEDURE WHEN FUNCTION LISTED
PM39090
27_Jun
2011
UK69183


PANEL ADB2DDF "DISTRIBUTED DB2 SYSTEMS" CO CONNECT TO REMOTE SUBSYSTEM MESSAGE "CONNECTION RESET" LEAVE ACTIVE RA THREAD
PM25830
27_Jun
2011
UK69177


TEMPLATE USAGE - DEFINITIONS FROM ADB25TU3 NOT USED BY OC EVEN THOUGH ADBH5TU SAYS "SPECIFY WHICH TEMPLATE WILL BE USED"
PM26759
27_Jun
2011
UK69177


ALTER TABLESPACE REORG PEND STATE OPTIONAL UTIL FAILS RC=08 DSNU212I
PM40207
27_Jun
2011
UK69177


ALT JCL STRONNNN, STARNNNN AND GENR STEPS NOT LISTED IN "POINTS OF RESTART" AND NO COMMENTS FOR STEP GENR
PM26945
15_Jun
2011
UK68806


MESSAGE "DROP IMPACT NOT AVAILABLE" "THIS FUNCTION DOES NOT SUPPORT DB2 RELEASE 915, 1010 AND 1015" 11/04/14 PTF
PECHANGE
PM30560
14_Jun
2011
UK68748
PM59629

MSGIEW2646W 4B07 ESD RMODE(24) CONFLICTS WITH USER-SPECIFIED RMODE(ANY) FOR SECTION ADBLOAD.
PM33175
14_Jun
2011
UK68759


CHANGED TABLE SPACE DEFINE AND SEGSIZE BUT ONLY THE SEGSIZE WAS CHANGED.
PM35501
14_Jun
2011
UK68750


PROMPT COMMAND: SET CURRENT SQLID MISSING FROM BATCH JOB
PM38027
14_Jun
2011
UK68761


MSG ' MISSING UNLDDN ' ON HPU MIG AT DB OR TS LEVEL
PM33334
14_Jun
2011
UK68761


ALT NOVALUE CONDITION RAISED IN ADB27CMR
PM39837
14_Jun
2011
UK68752


SQLCODEN190 ALTER TABLE ALTER COLUMN1 SET DATA TYPE SMALLINT ON ALT APPLY JOB.
PM39541
14_Jun
2011
UK68753


STORED PROCEDURE MISSING PARAMETER CCSID UNICODE
PM40608
14_Jun
2011
UK68753


MESSAGE (D)FIELD OWNERTYPE CHANGED FROM <AUTHORIZATION_ID> TO <AUTHORIZATION_ID> ISSUED FOR A USER DEFINED FUNCTION / UDF
PM33985
7_Jun
2011
UK68542


PANEL ADB26CFW "ALTER EXTERNAL SCALAR FUNCTIONS" DOES NOT SHOW EXISTING RUNTIME OPTIONS.
PM39430
7_Jun
2011
UK68545


PANEL ADB2 "DB2 ADMINISTRATION MENU 10.1.0" SHOWS INCORRECT VALUE FOR FIELD "DB2 SCHEMA"
PM35568
7_Jun
2011
UK68551


SQLCODEN204 AS CREATE MQT OCCURRED AFTER CREATE VIEW
PM38311
7_Jun
2011
UK68547


DSNU047I DSNUKDIN - A REQUIRED CARD OR TEMPLATE IS MISSING. NAME=UTLOUT WHEN USING THE MIG FUNCTION WITH CHECK UTILITY
PM35086
7_Jun
2011
UK68545


ABENDU4088-68 WHEN BROWSING TABLE VIA BR LINE COMMAND
PM38187
7_Jun
2011
UK68545


IBM0361W ONCODE=350 STRINGRANGE ENTRY POINT BUILD_CATREC_HDR IBM0451S ONCODE=451 STORAGE ENTRY POINT ADB2GEN
PM38739
7_Jun
2011
UK68551


JCL ERROR: IEF642I EXCESSIVE PARAMETER LENGTH IN THE PARM FIELD DURING CM ANALYZE WITH RECOVER SPECIFIED
PM27829
27_May
2011
UK68252


WHEN USING 2ND AUTH ID, IEC130I DB2RLIB DD STATEMENT MISSING CALL 'XXXXXX.XXXXXXXX.SADBLINK(ADB2ATH)' 'CALL' GIVES RC OF
12
PM33915
27_May
2011
UK68256


DSNB DIS BPOOL LEADS TO PARSING PROBLEMS AND UNEXPECTED TABLE OUTPUT
PM36904
27_May
2011
UK68264


ADBC010E - SORT OF CHANGE BASE RECORDS FAILED. INCOMPATIBILITY IN LRECL BETWEEN SRTCIN AND SRTCOUT. SORT RETURN CODE
REPORTING.
PM37412
27_May
2011
UK68261


CREATE STORED PROCEDURE GETS SQLCODE = -104 ERROR. NSP TO ADD ANOTHER VERSION : ILLEGAL SYMBO 11/04/20 PTF
PECHANGE
PM00662
27_May
2011
UK68250


DB2 ADMINISTRATION GEN OF TABLESPACE PARTITIONS OUT OF ORDER AFTER ROTATE.
PM28544
27_May
2011
UK68254


FUNCTION DS / DSP DOES NOT LIST INSTEAD OF TRIGGER
PM34535
27_May
2011
UK68258


FUNCTION: ADBDISOB, LINE 280: END RETCODE 7 WHEN DB2 MODE(X)
PM35175
27_May
2011
UK68260


IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED. FROM ENTRY POINT POPULATE_CONV_CONTROLS U4038 U4039 IF HPU
USED
PM37419
27_May
2011
UK68264


ALT TABLESPACE FROM SIMPLE TO PARTITIONED ABENDS ON ANALYZE COMP4 STEP RESULTING IN RC=12
PM37568
27_May
2011
UK68266


CLONE WSL MASK NOT APPLIED TO CATALOG STATISTICS
PM04459
20_May
2011
UK67971


MISSING TBOWNER IN FROM CLAUSE FROM VIEW CAUSES ADB1847E WARNING ERROR PARSING DDL VIEW OR TABLE STATEMENT.
PK77357
20_May
2011
UK67980


ADMIN RDEF SEGMENTED TO PARTTIONED TABLE SPACE NO INDEX CREATED.FUNCTION = ADB2WVL, LINE 261: SIGNAL ERROR
PM22596
20_May
2011
UK67983
PM42852

COND CODE 0303 FOR CNT DATASET WHEN PROCESSING AN OBJECT CREATED WITH DEFER YES.
PM29896
20_May
2011
UK67983
PM42852

ALT JCL CONTAINS DUPLICATE STEP NAMES EG //DB2CMD & //DELC0001, NO INSTRUCTIONS AS TO RESTART, INCORRECT COMMENTS ADBS27AC
PM31726
20_May
2011
UK67980


RENAME OF COLUMN FAILS SQLCODEN750 AS CONSTRAINT NOT DROPPED BEFORE RENAME.
PM32016
20_May
2011
UK67983
PM42852

RUNSTATS EXECUTES SUCCESSFULLY IN RUN CHANGE BUT VALUE OF COL CARD IN ADB21TC STILL SHOWS -1
PM32897
20_May
2011
UK67971


DDL FROM CODEPAGE 500 TO 285 RESULT IN PARSING ERROR. ADB2PA5: THE FOLLOWING STATEMENT COULD NOT BE PARSED.
PM30423
20_May
2011
UK67985


WSL CLONE FAILS TO REPRODUCE ALL STATEMENTS IN CLONE
PM35196
20_May
2011
UK67971


SWEDISH NATIONAL CHARACTERS X'5B' X'7B' X'7C' GENERATE PARSING ERROR
PM37109
20_May
2011
UK67983
PM42852

LOBTEMPLATE DOES NOT HONOR THE DEFINITION FOUND ON PANEL ADB25TU3 LOBCOLDDN SETTING FOR THE SECOND INSTANCE
PM38281
20_May
2011
UK67983
PM42852

ALTPART WITH REORG FAILS
PM35870
20_May
2011
UK67980


ADB1908E NO SYSTABLES ROW FOUND FOR 'CREATE AUXILIARY TABLE' RC12
PM37053
20_May
2011
UK67982


OC COMPARE SOURCE AND TARGET VIA DDF YIELDS SQLCODE -104.
PM30841
20_May
2011
UK67980


PARSER ERROR WITH MSG - SYNTAX ERROR DURING STATEMENT SCAN. ERROR OCCURED WHEN PARSING THE FOLLOWING STMT
PM33170
20_May
2011
UK67980


RENAME OF COLUMN FAILS SQLCODEN750 AS TRIGGER NOT DROPPED BEFORERENAME.
PM33773
20_May
2011
UK67988

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PK78161
6_May
2011
UK67513


DB2 ADMIN PRIQTY/SECQTY NOT MULTIPLIED WITH 4K PAGES WHEN MASKING USES REXX EXITS. STRIP OFF DECIMALS OF OVERWRITE
VALUE.
PM05520
6_May
2011
UK67516


NFDB29 GEN OF IMPLICIT INDEX RESULTS IN EMPTY OUTPUT DATASET WITH NO MESSAGES TO INDICATE WHY
PM08000
6_May
2011
UK67516


GEN/DDL COMMAND DOES NOT PRODUCE OUTPUT FOR THE SYSDEFLT STOGROUP OR ISSUE ANY MESSAGES EXPLAINING WHY NO OUTPUT WAS CREATED
PM33531
6_May
2011
UK67520


ALC WITH "GENERATE TEMPLATE STATEMENTS NO" SPECIFIED ON PANEL ADB27A BUILT JCL WITH LISTDEF COPY FAILS R 11/02/25 PTF
PEREMOVE
PM20848
6_May
2011
UK67518


PROG755 / IKT00405I SCREEN ERASURE WHEN ISSUING THE DDL COMMAND AGAINST A STORED PROCEDURE / ADB1847E WARNING
PM31439
6_May
2011
UK67516


DB2 ADMINISTRATION TOOL FOR Z/OS, SUPPORT FOR CREATE DATABASE DDL FOR DSNDB* DATABASES WILL BE ENABLED.
PM33383
6_May
2011
UK67522


ALT ADB6002E THE DD STATEMENT ALTPARM IS MISSING OR IS INCORRECTCMD UNKNOWN, LINE 577: UNINITIALIZED VARIABLE IN EXEC ADBEALT
PM35752
6_May
2011
UK67522


INVALID TEXT FILE(RUNPARMS) : GENMASK = 'Y' OR GENPERM = 'Y' ADB9003W INVALID INPUT FROM THE INPUT PARAMETER FILE IS
IGNORED.
PM34230
25_Apr
2011
UK67081


MISSING REBIND FOR PLANS/PACKAGES MARKED VALID 'A' CLARIFICATIONOF HELP PANEL AND MANUAL
PM06344
25_Apr
2011
UK67081

HIPER

DB2 ADMINISTRATION FOR Z/OS. HPU UNLOAD ENDED W/ RC=303 OR RC=292 AND DATA LOSS.
PM31936
22_Apr
2011
UK67041


ALC/ALT RESULTS IN PANEL ADB27PGA"ALTER TABLE SPACE OPTION" THE NEW ROW LENGTH 6440 IS GREATER THAN THE PAGE SIZE 8192
PM32264
22_Apr
2011
UK67043


PANEL ADB2ATI1 INTERPRETATION OF AN OBJECT IN SYSTABAUTH INCOMPLETE INFORMATION "UPDATE PRIVILEGE APPLIES TO COLUMN"
PM33324
22_Apr
2011
UK67045


PANEL ADB2AHI1 "INTERPRETATION OF AN OBJECT IN SYSSCHEMAAUTH" DISPLAYS INCORRECT INFORMATION DROPIN CREATEIN ALTERIN SCHEMA
PM33645
22_Apr
2011
UK67047


PANEL ADB2ALI1 "INTERPRETATION OF AN OBJECT IN SYSRESAUTH" DISPLAYS INCORRECT INFORMATION AS CREATE AUTH MISSING
PM28154
22_Apr
2011
UK67033


OBJECT COMPARE WITH KEEPTGT AND CMDELTA OPTIONS COMPARES SYNONYMS ON A VIEW AND SQLID (SYNONYM CREATOR) IS INCORRECT.
PM28199
22_Apr
2011
UK67035


PANEL ADB21SA WILL NOT ACCEPT INPUT IF INVOKED VIA SP LINE COMMAND OF PANEL ADB21S
PM28885
22_Apr
2011
UK67037


SEQUENCE OBJECTS AND PRIMARY COMMAND GRANT ON "I" TYPE, PANEL ADB2GQ DISPLAYED INSTEAD OF WARNING MSG ADB272E NOT POSSIBLE.
PM30410
22_Apr
2011
UK67039


PARSER ERROR WITH MSG - SYNTAX ERROR DURING STATEMENT SCAN ERROR OCCURED WHEN PARSING THE FOLLOWING STMT
PM36129
22_Apr
2011
UK67050


CHANGE IN INDEX NAME ENFORCING PRIMARY KEY IN TABLE RESULT IN SQLCODEN623
PM33758
22_Apr
2011
UK67033


IBM0342S ONCODE=340 THE SIZE CONDITION WAS RAISED. FROM EP CATREC_COMMENT_COLLIST RC16 ADBCDTS VERSION FI 11/02/28 PTF
PECHANGE
PM36241
22_Apr
2011
UK67049


DB2 ADMINISTRATION TOOL FOR Z/OS DURING WORK STATEMENT VALIDATION ISSUES MESSAGE ADB3101E AND SQLCODEN525.
PK91925
13_Apr
2011
UK66740
PM37412

ADMIN TOOL CREATE PROCEDURE WITH "--" STYLE COMMENTS SQLCODE -104.
PK78576
12_Apr
2011
UK66732


DB2 ADMIN COMMENT / LABEL ON ALIAS NOT HANDLED CORRECTLY USING CM.
PK78594
12_Apr
2011
UK66732


DB2 OBJECT COMPARE COMMENT / LABEL ON VIEW ALIAS NOT REPORTED CORRECTLY.
PM32746
12_Apr
2011
UK66737


MSG "ENTER REQUIRED FIELD" WHEN USING THE EDIT COMMAND ON PANEL ADB2EE THEN SQLCODEN104
PM25498
12_Apr
2011
UK66734


VIEW CREATED WITH SPECIFIC COLUMNS IN TABLE THEN DROP OF COLUMN IN TABLE DOES NOT DROP COLUMN IN VIEW RESULT
SQLCODEN158
PM26687
12_Apr
2011
UK66735


COMPARE OF VIEW WITH 2 SYNONYMS GENERATES THE SAME CREATOR FOR 2ND SYNONYM RESULTING IN ANALYZE ERROR OR SQLCODE -601
PM32464
12_Apr
2011
UK66736


ALTER PARTITIONED INDEX, AFTER THE ALTER IS COMPLETE THERE IS NO POPUP PANEL TO DISPLAY THE UPDATED INDEX.
PM32991
1_Apr
2011
UK66440


GEN / DDL COMMAND PERFORMANCE EXCESSIVE GETPAGE DUE TO MISSING PREDICATE
PM18039
1_Apr
2011
UK66440


ONCODE150 STRINGSIZE CONDITION
PK78588
1_Apr
2011
UK66436


DB2 ADMIN MERGE HANDLE LIMIT KEY CHANGES CORRECTLY AFTER IMPLICIT MIGRATION TO TABLE CONTROLLED.
PK79138
1_Apr
2011
UK66436


MIG OF TABLESPACE WITH MQT RESULTS IN LOAD STEP FAILING RC=08 DSNU284I DSNUGMAP LOAD UTILITY NOT ALLOWEDAGAINST A SUMMARY
PM14278
1_Apr
2011
UK66440


DDL COMMAND ADB1822E NO SYSVIEWS ROW FOUND FOR CREATE MQT
PM31030
1_Apr
2011
UK66442

HIPER

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PM02498
1_Apr
2011
UK66440


GEN PANEL ADB2GEN "OUTPUT FILE AND EXECUTION MODE:" DATA SET AND "DB2 COMMAND OUTPUT FILE:" DATA SET PDS DIFFERENT MEMBERS
PM24194
1_Apr
2011
UK66436


ISPT025 LIBRARY FORMAT ERROR FIRST TABLE RECORD READ DOES NOT HAVE TIR: AS IDENTIFIER WHEN GEN WSL OUTPUT SENT TO PDS
MEMBER
PM28928
1_Apr
2011
UK66440


ORDER OF DEPENDENT OBJECTS IN GEN OUTPUT RESULTS IN SQLCODE440
PM29201
1_Apr
2011
UK66436


GEN ON VIEW OMITS CREATE TRIGGER OPTION ON ADB2GEN PANEL
PM27050
1_Apr
2011
UK66440


IMPLICIT LOB TABLESPACE CONTAINING AUX TABLE CANNOT BE DROPPED BY ITSELF SQLCODEN616
PM30063
1_Apr
2011
UK66440


ALC WITH ADDFK CHANGE IN KEY RESULTS IN DROP / CREATE RATHER THAN SMART ALTER
PM31701
1_Apr
2011
UK66440


COMMENT ON COLUMN <SCHEMA>.<TABLENAME>.<COLUMN> MISSING ACTUAL COMMENT RESULTS IN SQLCODEN104
PM31990
1_Apr
2011
UK66440


ALTER IN CONSTRAINT LENGTH DROPS AND RECREATES TABLE INSTEAD OF DROP CONSTRAINT/ALTER TABLE/ADD CONSTRAINT/CHECK/REORG
UTIL
PM32111
1_Apr
2011
UK66440


WHEN USING DB2 OBJECT COMPARISON TOOL FOR Z/OS, IGNORE KEYWORD PARTITIONING FINDS DIFFERENCE IN INDEXPART LIMITKEYS
PM32117
1_Apr
2011
UK66440


OBJECT COMPARE DROP/RECREATE TABLE USES " " AS TSNAME E.G. IN DBNAME." "
PM32201
1_Apr
2011
UK66440


STORED PROCEDURE KEYWORD QUALIFIER NOT BEING MASKED
PM32901
1_Apr
2011
UK66439


NFDB210 - ABILITY TO EXECUTE A STORED PROCEDURE FROM ADMIN
PM29627
1_Apr
2011
UK66440


DROP IN TS CONTAINING MQT TABLE RESULT IN DROP TS THEN DROP MQT TABLE. DROP TS SHOULD BE SUFFICIENT.
PM29924
1_Apr
2011
UK66440


COMPARISON OF TABLE/INDEX CREATED PRIOR TO V9 WITH OWNER=BLANK (D)FIELD OWNER CHANGED FROM '' TO TARGET OWNER FFA10 PM20528.
PM30553
1_Apr
2011
UK66440


FIRST DIFFERENCE UNDERLINING APPEARS BELOW EXACT TEXT MATCH IN OC JOBLOG
PM32199
1_Apr
2011
UK66440


COMMENT ON VIEW STATEMENTS MISSING AFTER COMPARE
PM32203
1_Apr
2011
UK66440


ALTER TABLE ADD PRIMARY KEY APPEARS IN .CHG FILE AFTER DROP/ RECREATE OF TABLE CONTAINING PRIMARY KEY
PM33633
1_Apr
2011
UK66440


ONCODE=150 ENTRY POINT _CONCNVS TGT_INPUT AND RPT_OUTM COMPARE_FILES
PK83230
27_Mar
2011
UK66163


ADMIN LAUNCHPAD ACTION(UPDATE) FAILS AFTER PK36982 / UK35275
PM19767
27_Mar
2011
UK66165


MESSAGE ADBC033W CONVERSION OF CHARACTER TO DATE MAY FAIL FOR COL ADB27AD ADBC203E DATA CONVERSION ERRORS FOUND
PM22950
27_Mar
2011
UK66161
PM37993

SM FUNCTION ON TABLESPACE WHICH HAS A VIEW GENERATES AVG. ROW SIZE ===> 0
PM28823
27_Mar
2011
UK66161
PM37993

SM FORMULA USED FOR COMPRESSION IS INVERSE. FORMULA WILL BE CHANGED TO 1-CR
PM31616
27_Mar
2011
UK66157


SM FUNCTION PANEL ADB2M1S "PAGE SET STATISTICS" LISTS INDEX PARTITIONS ( TYPE=XP ) ROWS MORE THAN ONCE
PM14206
27_Mar
2011
UK66157


DUPLICATE ENTRIES FOR PARTITIONED INDEXSPACE WHEN USING SM FUNCTION
PM23080
27_Mar
2011
UK66159


LOAD FAILS WITH ABEND04E RC00E40070 MSGDSNU037I MSGDSNU016I WHENCNT OR CNTL SYSPUNCH DATASET FROM UNLOAD DEFAULTS TO RECFM =
U
PM32478
27_Mar
2011
UK66165


ABENDU4038-1 ONCODE520 SUBSCRIPTRANGECONDITION ENTRY POINT PARSE_LOAD_STMT WHEN USING ALT FUNCTION
PM10119
16_Mar
2011
UK65832


GEN TRIGGER RESULTS IN DIAGNOSTIC TEXT IN SIGNAL SQLSTATE NOT RECOGNIZED SQLCODEN204 TOKEN NUMBER = NNNNN, TOKEN =(
PM25217
16_Mar
2011
UK65851


DB2 ADMINISTRATION FOR Z/OS REVOKE IMPACT REPORT ENHANCEMENT.
PM26094
16_Mar
2011
UK65826


SPACE MANAGER SM FUNCTION RESZ COMMAND LINE COMMAND LOOP WHEN PCT USED LESS THAN VALUE ON PANEL ADB2M1R = 1ST ROW ON
ADB2M1S
PM27273
16_Mar
2011
UK65837


INCORRECT CURSOR POSITIONING AFTER FIND COMMAND
PM29368
16_Mar
2011
UK65832


SERVICEABILITY APAR, RC00 WHEN ERROR CONDITION RAISED AND UNNUMBERED ERROR MESSAGE ISSUED
PM30556
16_Mar
2011
UK65849


WSL BUILT BY UTILITIES (REORG TABLESPACES) FAILED
PM30562
16_Mar
2011
UK65862


ADB2USR9 : THE FILE PART CAN'T ACCEPT ENTRIES GREATER THAN 254 FOR DB2 V8 AND HIGHER
PM32395
16_Mar
2011
UK65841


SPECIAL ++HOLD TEXT FOR PM26567 REFERENCES TABLE ADBCHKPT BUT THE SAMPLE REFERENCES TABLE ADBCHG
PM26517
16_Mar
2011
UK65861


"NO CHANGES" SHOW IN PANEL ADB27CA WHEN ALT GENERATED BY DEFAULTCHANGED TO GENERATED ALWAYS FOR AN IDENTITY COLUMN.
PM32282
16_Mar
2011
UK65836


ALT: MAXPARTITIONS SPECIFICATION IS MISSING IN CREATE TABLESPACESTATEMENT WHEN ALT TABLE WITH TABLE DROP/CREATE.
PM32109
16_Mar
2011
UK65863


T03COMP STEP GENERATING BLANK LINES UNDER FIELDS IGNORED WHEN COMPARING SOURCE AND TARGET OBJECTS
PM32525
16_Mar
2011
UK65832


DDL READER GOC2DTC DOES NOT SET ERROR CODE PROPERLY WHEN UNSUPPORTED "REVOKE" DDL STATEMENT IS ENCOUNTERED.
PM32530
16_Mar
2011
UK65864


DB2 OBJECT COMPARISON RESULTS IN RC=20 UPON FTINCL GOCTUNL DURING T04GAPY. INTERMITTENT WHILE PROCESSING LARGE CHANGES
FILE
PK94676
15_Mar
2011
UK65799


SM MOVE OF DB2 CATALOG FAILS ADR129E KEYWORD 'OUTDY ' IS IMPROPER OR DELIMITER ')' IS NOT PROPERLY PRECEDED BY A
CONSTANT
PM24999
28_Feb
2011
UK65300


NFDB29 DSNZPARM PANEL ADB2ZZMN "SYSTEM PARAMETERS" DOES NOT ALLOW A VALUE GREATER THAN 10 FOR AGGREGATION FIELDS /
ACCUMUID
PM26678
28_Feb
2011
UK65308


ABENDU4094-18 AFTER USING BR AND SORT <COLUMN> COMMAND.
PM32363
28_Feb
2011
UK65308


BIND ERROR PTF UK64491 MSGDSNT243I CONTOKEN IS NOT UNIQUE 11/02/10 PTF
PECHANGE
PM31702
28_Feb
2011
UK65305


CREATE SEQUENCE DECIMAL COLUMN LENGTH CHANGED WITHOUT WARNING RESULTING CHANGE MANAGEMENT CHG FILE INCORRECT
PM32315
28_Feb
2011
UK65311

HIPER

NEW FUNCTION APAR PM24212 MISSING ++HOLD ACTION SAMPLE TO INFORM CUSTOMERS OF ADBCHU02 SAMPLE ADBTEP 11/02/09 PTF
PECHANGE
PM27998
17_Feb
2011
UK64966


DB2 ADMINISTRATION TOOL FOR Z/OS FIXES FOR SQL PROTOTYPE PANELS.LASEL/INS/UPD/DEL COMMANDS DO NOT WORK, COUNT(*) PROBLEM.
PM30017
17_Feb
2011
UK64968


'CAN' IS INVALID ON PANEL ADB2PSTM AFTER ALTERING INDEX BUFFER POOL WHILE SETTING CURRENT ID CM 'NONE' IN CM MANAGE ID TABLE
PM31689
17_Feb
2011
UK64970
PM33758

ABEND=S000 U4083 DURING COMP4 STEP OF CM ANALYZE. COMMAND RT (RECOVER TO COPY) IN ADB21I LEADS TO ADB2ER.
PM26505
17_Feb
2011
UK64970
PM33758

ANALYZE FAILS WITH ONCODE=350 FROM ENTRY POINT STACK_ALTER_DDL AT STATEMENT 9650
PM29858
1_Feb
2011
UK64491
PM32363
PM26945
HIPER

IBM INTERNAL FOR PM13454 PM23880 PM27179
PM27184
1_Feb
2011
UK64491
PM32363
PM26945

NFDB210 DB2 ADMINSTRATION TOOL FOR Z/OS 10 ENHANCEMENTS.
PK86685
31_Jan
2011
UK64491
PM32363
PM26945

UTIL PARTITION LEVEL RECOVER TABLESPACE DSNUM N TO USES REBUILD INDEX(<INDEX-NAME> PART N ) RATHER THAN INDEX(ALL)
PM11763
31_Jan
2011
UK64491
PM32363
PM26945

ALC MISSING RI ON PARENT TABLE AFTER DROPPING COLUMN
PM18116
31_Jan
2011
UK64491
PM32363
PM26945

ADB2MEX PANEL SHOWS INVALID KEYLENGTH WHEN USING AL ON INDEX THEN ? ON PRIQTY
PM24200
31_Jan
2011
UK64491
PM32363
PM26945

DB2 ADMINISTRATION TOOL FOR Z/OS. UTILITY TEMPLATE ERROR MESSAGE: INVALID CONTROL WORD PARAMETER, ADB25TL1 RECORD-1612
PM28712
31_Jan
2011
UK64491
PM32363
PM26945

MSGDSNU071I KEYWORD 'DELETE' REQUIRES KEYWORD 'FOR EXCEPTION' ON CHECK DATA UTILITY
PM28904
31_Jan
2011
UK64491
PM32363
PM26945

ADB1219W TABLE <SCHEMA>.<GTT_NAME> NOT FOUND MESSAGE ISSUED WHEN USING VERSION SCOPE TO REFERENCE A GLOBAL TEMPORARY TABLE /
PM06412
31_Jan
2011
UK64491
PM32363
PM26945

DDL COMMAND PRODUCTS EMPTY DDL FILE WHEN DSNDB% PREFIXED OBJECTSWHILE GEN ISSUES MESSAGE ADB1926W ( AS EXPECTED )
PM10005
31_Jan
2011
UK64491
PM32363
PM26945

WHEN USING XD THEN XC TO GET THE DDL FROM JOB LOG, ADMIN TOOL ADDS A SPACE ON LEFT, RESULTING IN PARSING ERROR FOR
FUNCTIONS
PM16574
31_Jan
2011
UK64491
PM32363
PM26945

RTS IN DB2 V9 ENFM USES TABLESPACESTATS AND INDEXSPACESTATS INSTEAD OF SYSTABLESPACESTATS AND SYSINDEXSPACESTATS
PM16857
31_Jan
2011
UK64491
PM32363
PM26945

ALC FUNCTION: ADBC052I COLUMN AAA(TIMESTAMP) CHANGED TO 'GENERATED BY DEFAULT' THIS IS NECESSARY TO PRESERVE
TIMESTAMPS
PM18631
31_Jan
2011
UK64491
PM32363
PM26945

DROP OF FOREIGN KEY SINCE COLUMNS IN TABLE ARE DROPPED DID NOT MATERIALIZE RESULTING IN ADBCCME FOREIGN KEY ALREADY
EXIST
PM27813
31_Jan
2011
UK64491
PM32363
PM26945

STEP //T05GRWL RETURNS RC=0 WHEN DATASET IN USE OR THERE IS A SPACE ISSUE ON THE DATASET USED BY THE JOB ( X37 )
PM29068
31_Jan
2011
UK64442


ADBC099E: WSL MISMATCH. WSL MISMATCH OCCURRING WHEN ROTATE PARTS IS USED.
PM27284
31_Jan
2011
UK64491
PM32363
PM26945

DB2 ADMINISTRATION TOOL FOR Z/OS DURING WORK STATEMENT VALIDATION ISSUES MESSAGE ADB3101E AND SQLCODE -525.
PM27921
31_Jan
2011
UK64491
PM32363
PM26945

SYNONYMS FOR VIEWS ARE NOT RECREATED WITH THE RIGHT SQLID
PM28070
31_Jan
2011
UK64491
PM32363
PM26945

MIG PANEL ADB28M "TARGET SYSTEM PARAMETERS:" NOT HONORED IN THE "OPTIONAL STEPS AFTER RELOAD:" CHECK DATA, COPY AND RUNSTATS
PM15062
29_Dec
2010
UK63573
PM32315

COMPARISON WITH AUDIT CHANGES USING DDL SOURCE AND CATALOG TARGET RESULT IN AUDIT NONE
PM21327
29_Dec
2010
UK63561


STATISTICS OPTIONS SPECIFIED ON PANEL ADB2UXO2 "SPECIFY UTILITY OPTIONS - REORG INDEX" MISSING FROM SYNTAX
PM25921
29_Dec
2010
UK63573
PM32315

GEN ISSUES MESSAGE ADB1847E WHEN PROCESSING A STORED PROCEDURE/SP WHICH CONTAINS A DECIMAL CONSTANT
PM26070
29_Dec
2010
UK63573
PM32315

DDL/GEN ON STORED PROCEDURE WITH COMMON-TABLE-EXPRESSION IN INSERT STATEMENT GETS PARSER ERROR
PM26390
29_Dec
2010
UK63573
PM32315

DDL/GEN ISSUES PARSER ERROR WHEN A TABLE CORRELATION NAME IS A DB2 RESERVED WORD THAT IS NOT ENCLOSED IN QUOTES
PM27492
29_Dec
2010
UK63573
PM32315

INCORRECT SYNTAX BUILT BY PANEL ADB21TSE BUILD SQL SELECT PROTOTYPE. CONTAINS "WHERE AND" SQLCODEN199
PM28617
29_Dec
2010
UK63573
PM32315

GEN ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWINGVIEW BECAUSE IT COULD NOT BE PARSED. PLEASE VERIFY THE DDL.
PM20488
29_Dec
2010
UK63573
PM32315

DDL AND GEN OF VIEW FAIL ABENDU4038 RC01 ONCODE520 SUBSCRIPTRANGE CONDITION
PM22093
29_Dec
2010
UK63566


DB2 ADMINISTRATION TOOL FOR Z/OS HIGH2KEY/LOW2KEY NON HEX REPRESENTATION FIELDS NOT UPDATING ON ADB21CUR PANEL.
PM22216
29_Dec
2010
UK63568


SAMPLE JOB ADB2UCU3 INSTRUCTIONS ARE UNCLEAR CONCERNING MODIFICATIONS TO ADB2UCUS )CM COMMENT LINES REFERENCING SKELETON
ADB2USK
PM23880
29_Dec
2010
UK63573
PM32315

MQT MISSING AFTER COMPARE OF A CREATE TABLE / ALTER TABLE ADD MATERIALIZED QUERY DDL SET.
PM26567
29_Dec
2010
UK63573
PM32315

ROWID CHANGED FROM GENERATED ALWAYS TO GENERATED BY DEFAULT IN DB2 OBJECT COMPARISON TOOL FOR Z/OS.
PM27503
29_Dec
2010
UK63573
PM32315

OC PARSER ERROR ON NSP WITH MQT - MSGADB1847E - WARNING : ERROR PARSING DDL NSP STATEMENT
PM27698
29_Dec
2010
UK63573
PM32315

COMPARE APPENDS <SCHEMA>.CORRELATION-ID.COLUMN RESULTING IN PARSING ERROR
PM27857
29_Dec
2010
UK63573
PM32315

ABEND0C4 ADBCVOB AT DICT_KEY3 STATEMENT 1471 ONCODE8094 PROTECTION EXCEPTION
PM27894
29_Dec
2010
UK63570


PANEL GOC5 'SINGLE COMPARE JOB' NO OPTION CAUSES JCL ERROR WHEN VERSION/MASK/IGNORE TABLE ENTRY USED. DISP=(NEW,PASS,DEL)
PM24212
29_Dec
2010
UK63573
PM32315

NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
PM26512
29_Dec
2010
UK63573
PM32315

WSLVAL STEP ENDS FUNCTION = ADB2WVL,LINE 350: SIGNAL ERROR RC=08SQLCODEN010 AND SQLCODEN104 COMMENT ON TABLE WITH SEMICOLON.
PM27631
29_Dec
2010
UK63573
PM32315

EXPLICIT LOB TABLESPACE CONTAINING AUX TABLE CANNOT BE DROPPED BY ITSELF SQLCODEN616. FF720 PM22711.
PM27695
29_Dec
2010
UK63573
PM32315

COMPARE WHICH WILL DROP/RECREATE MQT DOES NOT CREATE MQT INDEX
PM26167
29_Dec
2010
UK63573
PM32315

DB2 ADMINISTRATION TOOL FOR Z/OS PANEL ADB21SAT DOES NOT UPDATE STATUS TO "INDEX HAS BEEN REDEFINED" AFTER REDEFINE INDEXES.
PM04486
7_Dec
2010
UK62874


ALTER OF PARTITIONED TABLESPACES CREATED IN DB2 V7 AND LOWER RESULTS IN INVALID PART NUMBER DURING RDEF
PM13145
7_Dec
2010
UK62876


(D)COLUMN AAA DROPPED RESULTS IN RELATED OBJECTS LEFT IN CHKP STATUS
PM21197
7_Dec
2010
UK62878


DB2 ADMINISTRATION FOR Z/OS, PANEL MESSAGE "INVALID VALUE" SEEN IN PANEL ADB21CDH.
PM25752
7_Dec
2010
UK62890


DDL/GEN COMMAND ISSUES MESSAGE SUBSELECT ERROR. <SELECT-CLAUSE> NOT FOLLOWED BY A <FROM-CLAUSE> ADB2PA PARSED VIEW TOKEN = (
PM25945
7_Dec
2010
UK62885


LKEY WITH PARTITION USING BIGINT GIVES ERROR ADB21TAV: UNABLE TODETERMINE QUOTING NEEDED FOR INDEX COLUMN TYPE BIGINT
PM01936
7_Dec
2010
UK62888


ADMIN TOOL GENERATES TOO MANY UNNECESSARY STEPS IN ALTER FFA10 PM24212
PM05125
7_Dec
2010
UK62890


PARSING ERROR WHEN USING @ (ATSIGN) AND CCSID 1141
PM06678
7_Dec
2010
UK62890


GEN OF MQT WITH @ IN NAME AND BATCH WITH PARMS('DEBUG=3') RESULT IN ONCODE=340
PM25623
7_Dec
2010
UK62881


DB2 ADMINISTRATION TOOL FOR Z/OS RUNNING WSL ONLINE WITH HPU=YESFAILS WITH RC=12 ON ALLOCATION.
PM19045
18_Nov
2010
UK62282


DDL AND GEN FAIL FOR SP CONTAINING WITH UR CLAUSE
PM19161
18_Nov
2010
UK62282


GEN OR DDL COMMAND ON SP FAIL RC28 WITH MESSAGE: ERROR PARSING DDL NSP STATEMENT
PM19262
18_Nov
2010
UK62282


GEN OR DDL COMMAND ON SP FAIL RC28 WITH MESSAGE: MISSING ) AFTER LIST OF EXPRESSIONS IN SET STATEMENT
PM25289
17_Nov
2010
UK62278


GEN RETRIEVES ROWS FOR UDF IN SYSROUTINES RESULTING IN ERROR ADB1815E NO SYSROUTINES ROW FOUND FOR 'CREATE PROCEDURE'
PM22869
18_Oct
2010
UK61452

HIPER

H0IHA10 ROLLUP APAR (DB2 ADMINISTRATION TOOL FOR Z/OS)

Top of page