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 7.2
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM72006
17_Dec
2012
UK90433

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
UK90383


DB2 ADMINISTRATION TOOL FOR Z/OS RETURNS SQLCODEN802 WHEN USING 'TABLE SPACE MAINTENANCE RECOMMENDATIONS' PANEL ADB2314T
PM62785
16_Nov
2012
UK83581


WSL GENERATES CHECK DATA STATEMENT USING OLD IMPLICIT DATABASE NAME INSTEAD OF NEW IMPLICIT DATABASE NAME
PM69762
16_Nov
2012
UK83611


DROP IMPACT REPORT DOES NOT LIST PACKAGES FOR NATIVE STORED PROCEDURES ( NSP ).
PM65509
24_Oct
2012
UK82899


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


DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT DISPLAY PROPER SPACE RELATED VALUES ON PANELS ADB221SPI AND ADB2BRIF FFA20 PM72590
PM67393
10_Sep
2012
UK81656


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


ABENDS0C1 ADB2GEN STATEMENT 1998 USING TAPE DEVICE FOR VERSION FILES. FFA10 PM59384
PM61405
28_Aug
2012
UK81356


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


MSGDSNR035I UNCOMMITED UR ISSUE WHEN USING GEN- FFA20 PM69923
PM60543
10_Aug
2012
UK81005


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
UK81013


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


REORG ON TABLESPACE WITH TEMPLATE GENERATES INLINE COPY
PM48221
19_Jun
2012
UK79668


DB2 ADMINISTRATION TOOL FOR Z/OS MIGRATE MISSING STEPLIB FOR REBINDS
PM56720
23_May
2012
UK78987


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


IBM INTERNAL APAR FOR DEFECT 24509
PM34738
26_Apr
2012
UK78294


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


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
UK78294


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


WSLVAL STEP SQLCODEN104 ALTER TABLE FOREIGN KEY
PM58373
11_Apr
2012
UK77850


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


B BR BROWSE RESULTS IN ISPF ABEND0C6 IN ISPTASK
PM55334
22_Mar
2012
UK77279


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


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


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


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


++HOLD INFO INCORRECT IN PM36340'S UK69177/UK69178 STATES 'OPEN PARENTHESIS' WHEN IT SHOULD STATE 'CLOSED PARENTHESIS'
PM55039
13_Feb
2012
UK76135


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


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


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


ADB1602E NO VOLUMES FOUND FOR STOGROUP= WHEN RELCREATED IS BLANK AND STOGROUP HAS NO VOLUMES CLAUSE, USED VCAT AND DATACLAS
ONLY
PM54299
6_Feb
2012
UK75978


SQLCODEN302 ADB9011E AN UNEXPECTED SQLCODE WAS FOUND IN INSERT ADBCVERLINES WHEN UNDER DB2 R810 CM
PM46865
6_Feb
2012
UK75983


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


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


IBM INTERNAL APAR FOR DEFECT 21357
PM56369
6_Feb
2012
UK75976


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


PANEL ADB21S 'TABLE SPACES': REPEATED COMMAND RTS SHOWS ONLY THELAST OBJECTS INFORMATION
PM52787
19_Jan
2012
UK75572


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


PANEL ADB21KI1 DOES NOT DISPLAY INHERITFROMPLAN AS IT SHOULD WHEN PACKAGE IS BOUND WITH RELEASE(INHERITFROMPLAN)
PM52494
10_Jan
2012
UK75310


GEN MISSING STORED PROCEDURES CAUSED BY TRAILING X'20' IN SYSIBM.SYSROUTINES.SCHEMA COLUMN
PM47436
22_Dec
2011
UK75067


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


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


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


DRIVER DOES NOT SUPPORT DECFLOAT VALUES
PM48413
8_Dec
2011
UK74614


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


ADBTEP2 AUTO REBIND SYNTAX RESULTS IN DSNE964E DSNECP55 FOR PACKAGE KEYWORD PARAMETER ( SPACES BETWEEN NAMES )
PM43167
23_Nov
2011
UK74146


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


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


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


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


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


SQLCODEN104 PANEL ADB21K SQ LINE COMMAND TSO PROFILE NOPREFIX
PM44830
3_Nov
2011
UK73543


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


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


PANEL ADB25TC VOLCNT FIELD TOO SMALL CAN NOT INPUT A THREE DIGITNUMBER / MAXIMUM ALLOWABLE VALUE OF 255
PM26591
27_Oct
2011
UK73288


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
UK73293


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


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


ABEND0C4 ABENDU4088 ADBMAIN WHEN USING BR LINE COMMAND ON PANEL ADB21T
PM49010
27_Oct
2011
UK73295


PANEL ADB2C2L MESSAGE 'INVALID VALUE' FOR TYPE TSBPNAME OR IXBPNAME
PM49042
27_Oct
2011
UK73297


PANEL ADB21XSD 'INTERPRETATION OF AN OBJECT IN SYSINDEXSPACESTAT'NUMBER OF INDEX PAGE SPLITS (SPLIT NEAR) / (SPLIT FAR)'
PM39820
30_Sep
2011
UK72486


USER ABEND CODE 4038 REASON CODE 00000001 SEEN WHEN RUNNING ALC'S ADB27AC PROGRAM.
PM47949
30_Sep
2011
UK72488


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


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


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

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


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


ONCODE150 OBSERVED AT THE COMPARE STEP
PK97520
21_Sep
2011
UK72126


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


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


RUNSTATS ISSUE WHEN USING TABLE IS MIGRATED AND SEVERAL TABLES EXIST IN TABLESPACE. RUNSTATS PICKS UP LAST TABLE IN
TABLESPACE
PM27643
31_Aug
2011
UK71424
PM59629

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

INCORRECT TOTAL NUMBER OF ROWS SHOW UP IN SM - SPACE MANAGER.
PM44825
31_Aug
2011
UK71428


CREATE TABLESPACE WITH MEMBER CLUSTER AND SEGSIZE 4 IS NOT ALLOWED.
PM28602
30_Aug
2011
UK71415


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


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


NO LOAD OR REFRESH AFTER DROP MATERIALIZED QUERY TABLE ( MQT)
PK64957
30_Aug
2011
UK71415


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
UK71415


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

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


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


ADBTEP2 GIVES "ADMIN IF DEFINEYES TB" AS FALSE, BUT THE TABLESPACE WHICH CONTAINS THE TABLE HAS DEFINE YES.
PM34686
22_Aug
2011
UK71060


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


PANEL ADB2GEN PARM - ALLOC TS SIZE AS. . . : USED DOES NOT AFFECT CC CATALOG COPY ALLOCATIONS
PM38423
11_Aug
2011
UK70728


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


ALTER TABLESPACE REORG PEND STATE OPTIONAL UTIL FAILS RC=08 DSNU212I
PM35971
11_Aug
2011
UK70725


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


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


BR LINE COMMAND: FUNCTION : TBADD DB2T004RETCODE : 20 ZERRMSG : ISPP113 ZERRSM : UNABLE TO GET SAVE AREA OR U4088
PM42617
11_Aug
2011
UK70737


PROBLEM WITH COLUMNS RIDGENA, TMSGENA REFERENCES IN V72 ADMIN 11/06/28 PTF
PECHANGE
PM42646
11_Aug
2011
UK70733


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


ADB5146E UNEXPECTED SQLCODE IN :SELECT SYSTABLEPART DEF2 SQLCODE -304 / SQLCODEN304 11/07/18 PTF
PECHANGE
PM39133
21_Jul
2011
UK69991


MIG WITH MASKING AND IMAGECOPY. JCL GENERATED FOR IMAGECOPY ON TARGET USES SOURCE TABLES INSTEAD OF TARGET TABLES
PM30189
19_Jul
2011
UK69917


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


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


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


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


LAUNCHPAD COMMAND STRING FOR DB2 OBJECT COMPARE TOOL FOR Z/OS PANEL GOCMENU FAILS
PM37993
13_Jul
2011
UK69722


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


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


ALC RUNSTATS STEP MISSING WHEN COLUMN CHANGED FROM CHAR(10) TO CHAR(13) AND "RUN RUNSTATS Y" SELECTED ON PANEL ADB27A
PM40836
5_Jul
2011
UK69461


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


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


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


PARSING ISSUE ON TRIGGER WHEN GEN IS USED AND @ IS USED AS TERMINATOR
PM39365
27_Jun
2011
UK69188


ADMIN ALT JCL ISSUES DUPLICATE STEP
PM40299
27_Jun
2011
UK69174


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


PANEL ADB2AO "STORED PROCEDURE AUTHORIZATIONS" SQLCODEN204 ON GRANT EXECUTE ON PROCEDURE WHEN FUNCTION LISTED
PM30560
14_Jun
2011
UK68749
PM59629

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


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


PROMPT COMMAND: SET CURRENT SQLID MISSING FROM BATCH JOB
PM37400
14_Jun
2011
UK68747


WRONG SET CURRENT SCHEMA FOR CREATE TRIGGER USING GEN WITH UNQUALIFIED TABLES WITHIN TRIGGER AND OBJECT SCHEMA OPTION
USED
PM38027
14_Jun
2011
UK68762


MSG ' MISSING UNLDDN ' ON HPU MIG AT DB OR TS LEVEL
PM33985
7_Jun
2011
UK68543


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


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


DSNU047I DSNUKDIN - A REQUIRED CARD OR TEMPLATE IS MISSING. NAME=UTLOUT WHEN USING THE MIG FUNCTION WITH CHECK UTILITY
PM27829
27_May
2011
UK68253


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


DSNB DIS BPOOL LEADS TO PARSING PROBLEMS AND UNEXPECTED TABLE OUTPUT
PM36321
27_May
2011
UK68269


.CNC DATASET MISSING INTO TABLE RESULTING IN RC=8
PM36904
27_May
2011
UK68265


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


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


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


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


FUNCTION: ADBDISOB, LINE 280: END RETCODE 7 WHEN DB2 MODE(X)
PM04459
20_May
2011
UK67972


MISSING TBOWNER IN FROM CLAUSE FROM VIEW CAUSES ADB1847E WARNING ERROR PARSING DDL VIEW OR TABLE STATEMENT.
PM08516
20_May
2011
UK67984
PM42852

ADDITIONAL DEBUG FACILITIES BEING ADDED TO ADB27AC ( APAR MAY BE USED TO HOUSE AN ABENDS0C8 SOLUTION AS NEEDED )
PM22596
20_May
2011
UK67984
PM42852

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

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


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

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


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


WSL CLONE FAILS TO REPRODUCE ALL STATEMENTS IN CLONE
PM33675
20_May
2011
UK67984
PM42852

ALC LOOP IN CONVERT STEP / ST3AC JOB IBM0441W ONCODE=150 THE STRINGSIZE CONDITION ENTRY POINT UPDATE_COLLIST CONVERT_DDL
PM35196
20_May
2011
UK67972


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

LOBTEMPLATE DOES NOT HONOR THE DEFINITION FOUND ON PANEL ADB25TU3 LOBCOLDDN SETTING FOR THE SECOND INSTANCE
PM37887
20_May
2011
UK67992


ALC TABLE JCL FAILED IN STEP CREATE70 WITH ERROR MESSAGE "'ADB2UTIL' GIVES RC OF 20".
PM38281
20_May
2011
UK67984
PM42852

ALTPART WITH REORG FAILS
PK78161
6_May
2011
UK67514


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


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


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


MIG FUNCTION ROWID COLUMNS CHANGED FROM GENERATED ALWAYS TO GENERATED BY DEFAULT
PM33531
6_May
2011
UK67521


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
UK67519


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


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


ALT ADB6002E THE DD STATEMENT ALTPARM IS MISSING OR IS INCORRECTCMD UNKNOWN, LINE 577: UNINITIALIZED VARIABLE IN EXEC ADBEALT
PM34230
25_Apr
2011
UK67082


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

HIPER

DB2 ADMINISTRATION FOR Z/OS. HPU UNLOAD ENDED W/ RC=303 OR RC=292 AND DATA LOSS.
PM32549
25_Apr
2011
UK67082


SQLCODEN4700 ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE
PM29030
22_Apr
2011
UK67032


CHANGE IN INDEX NAME ENFORCING PRIMARY KEY IN TABLE RESULT IN SQLCODEN623. FFA10 PM36129.
PM31936
22_Apr
2011
UK67042


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
UK67044


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


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


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


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


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


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


PARSER ERROR WITH MSG - SYNTAX ERROR DURING STATEMENT SCAN ERROR OCCURED WHEN PARSING THE FOLLOWING STMT
PK91925
13_Apr
2011
UK66741
PM37412

ADMIN TOOL CREATE PROCEDURE WITH "--" STYLE COMMENTS SQLCODE -104.
PM33868
13_Apr
2011
UK66742


1A COMMAND INVALID ON ADB2PSTM WHEN PROCESSING MULTIPLE STATEMENTS
PK78576
12_Apr
2011
UK66733


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


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


MSG "ENTER REQUIRED FIELD" WHEN USING THE EDIT COMMAND ON PANEL ADB2EE THEN SQLCODEN104
PM18039
1_Apr
2011
UK66441


ONCODE150 STRINGSIZE CONDITION
PK78588
1_Apr
2011
UK66437


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


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

HIPER

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


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


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
UK66441


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


GEN ON VIEW OMITS CREATE TRIGGER OPTION ON ADB2GEN PANEL
PK83230
27_Mar
2011
UK66164


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


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

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

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


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


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


LOAD FAILS WITH ABEND04E RC00E40070 MSGDSNU037I MSGDSNU016I WHENCNT OR CNTL SYSPUNCH DATASET FROM UNLOAD DEFAULTS TO RECFM =
U
PM10119
16_Mar
2011
UK65833


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


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


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
UK65838


INCORRECT CURSOR POSITIONING AFTER FIND COMMAND
PM29368
16_Mar
2011
UK65833


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


WSL BUILT BY UTILITIES (REORG TABLESPACES) FAILED
PM32395
16_Mar
2011
UK65842


SPECIAL ++HOLD TEXT FOR PM26567 REFERENCES TABLE ADBCHKPT BUT THE SAMPLE REFERENCES TABLE ADBCHG
PK94676
15_Mar
2011
UK65800


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


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


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


ALC TABLE MISSING CONSTRAINT NAME RESULTING IN SQLCODEN104 AND IN ADDITION IS THE MISSING CONSTRAINT NAME.
PM31081
28_Feb
2011
UK65304

HIPER

CREATE SEQUENCE DECIMAL COLUMN LENGTH CHANGED WITHOUT WARNING RESULTING CHANGE MANAGEMENT CHG FILE INCORRECT. FFA10
PM31702.
PM27998
17_Feb
2011
UK64967


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
UK64969


'CAN' IS INVALID ON PANEL ADB2PSTM AFTER ALTERING INDEX BUFFER POOL WHILE SETTING CURRENT ID CM 'NONE' IN CM MANAGE ID TABLE
PM29858
1_Feb
2011
UK64492
PM32363
PM26945
HIPER

IBM INTERNAL FOR PM13454 PM23880 PM27179
PK86685
31_Jan
2011
UK64492
PM32363
PM26945

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


ALC FAILS RC1012 AND ADBC139E INTFIN AND C001 MISMATCH. COLNAMESNOT EQUALINTFIN: UNIQUE_ID C001 : UNIQUE_ID_IDENTITY
PM11763
31_Jan
2011
UK64492
PM32363
PM26945

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

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

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

MSGDSNU071I KEYWORD 'DELETE' REQUIRES KEYWORD 'FOR EXCEPTION' ON CHECK DATA UTILITY
PM28904
31_Jan
2011
UK64492
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
UK64492
PM32363
PM26945

DDL COMMAND PRODUCTS EMPTY DDL FILE WHEN DSNDB% PREFIXED OBJECTSWHILE GEN ISSUES MESSAGE ADB1926W ( AS EXPECTED )
PM10005
31_Jan
2011
UK64492
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
UK64492
PM32363
PM26945

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

ALC FUNCTION: ADBC052I COLUMN AAA(TIMESTAMP) CHANGED TO 'GENERATED BY DEFAULT' THIS IS NECESSARY TO PRESERVE
TIMESTAMPS
PM18631
31_Jan
2011
UK64492
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
UK64492
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
UK64443


ADBC099E: WSL MISMATCH. WSL MISMATCH OCCURRING WHEN ROTATE PARTS IS USED.
PM15062
29_Dec
2010
UK63574
PM32315

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


STATISTICS OPTIONS SPECIFIED ON PANEL ADB2UXO2 "SPECIFY UTILITY OPTIONS - REORG INDEX" MISSING FROM SYNTAX
PM22155
29_Dec
2010
UK63554


GEN / DDL OF VIEW HAS INCORRECT OWNER FFA10 PM27184.
PM23997
29_Dec
2010
UK63558


UNLOAD FAILS MSGDSNU094I KEYWORD PUNCHDDN UNLDDN DUPLICATED NO FFA10 720 ONLY.
PM25921
29_Dec
2010
UK63574
PM32315

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

DDL/GEN ON STORED PROCEDURE WITH COMMON-TABLE-EXPRESSION IN INSERT STATEMENT GETS PARSER ERROR
PM26390
29_Dec
2010
UK63574
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
UK63574
PM32315

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

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


DDL CMD ON ALIAS,ONCODE=150 STRINGSIZE CONDITION WAS RAISED AND ONCODE=350 STRINGRANGE CONDITION WAS RAISED WHEN CLONING WSL
PM15370
29_Dec
2010
UK63572


GRANT ISSUED TT LEVEL BIG NUMBER OF TABLES RESULT. FFA10 PM24212IN JCL GRANTS TO GRANTEE FOR A PORTION OF TABLES IN RESULTSET
PM20488
29_Dec
2010
UK63574
PM32315

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


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


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

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

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

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

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

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


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


WRONG SQL STATEMENT SET CURRENT SCHEMA='' IN CHANGE FILE GENERATED BY COMPARE JOB.
PM04486
7_Dec
2010
UK62875


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


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


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


TEMPLATE NAME USED IN CNVRT50 INCORRECT WHEN DATE AND TIME SPECIFIED IN USER-DEFINED NAME. NO FFA10 720 ONLY.
PM25752
7_Dec
2010
UK62891


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


DB2 ADMINISTRATION TOOL FOR Z/OS USING MIGRATE OF TABLESPACE IN DSNDB04 WHEN UNLOAD METHOD IS "U" FAILS RC=8. FFA10
PM24200.
PM25945
7_Dec
2010
UK62886


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


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


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


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


DB2 ADMINISTRATION TOOL FOR Z/OS RUNNING WSL ONLINE WITH HPU=YESFAILS WITH RC=12 ON ALLOCATION.
PM26366
7_Dec
2010
UK62887


USING DB2 ADMINISTRATION TOOL FOR Z/OS THE CREATE TABLE ADB26CTFPANEL IGNORES THE LENGTH FIELD FOR LOB COLUMNS. FFA10
PM27184.
PM19045
18_Nov
2010
UK62283


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


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


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


ALC OF TABLE WITH DEPENDENT TRIGGER. 720 ONLY FAILS ON DROP/RECREATE WITH RC1016 ON STEP CNVRT50
PM15735
17_Nov
2010
UK62273


++HOLD MISSING FOR MESSAGE ADB559G YES IS NOT ALLOWED WHEN MOVING TO PARTITIONED-BY-GROWTH TABLE SPACE. FFA10 PM24212.
PM17534
17_Nov
2010
UK62274


ONCODE=520 IN ANALYZE MERGE JOB ON CREATE FOREIGN KEY FFA10 PM18631.
PM23329
17_Nov
2010
UK62277


BIND PACKAGES > 20,CREATE BATCH JOB (OPTION 1). FFA10 PM27184. RESULT IN ADB2W1 ERROR: ADBWLT NOT ALLOCAT 10/09/27 PTF
CHANGE
PM23327
17_Nov
2010
UK62280


DB2 ADMINISTRATION FOR Z/OS GEN SHOWS INFORMATION FOR DB2 AUTHORIZATION TABLES FOR USERS NO READ ACCESS. FFA10 PM24212.
PK97664
17_Nov
2010
UK62270


AL ADDCOL FAILS WITH SQLCODEN20181. FFA10 PM24212
PM11745
17_Nov
2010
UK62271


PANEL ADB2M1S FAILS TO MAINTAIN CURSOR POSITION. FFA10 PM24212
PM18655
17_Nov
2010
UK62280


ALTER TABLE COLUMN VALUES FROM SMALLINT TO DECIMAL(5,2) RESULTS IN ONCODE=340 THE SIZE CONDITION WAS RAISED
PM21745
17_Nov
2010
UK62275


DB2 ADMINISTRATION TOOL FOR Z/OS UNLOAD FAILS ON MIGRATION TOO LONG MESSAGE. FFA10 PM27184.
PM22426
17_Nov
2010
UK62276


STATEMENTS SKIPPED ON ADB5019I ADJUSTING FOR IMPLICIT COMMIT MESSAGE ALTER BUFFERPOOL SQLCODEN626 STOP. FFA10 PM24212.
PM25289
17_Nov
2010
UK62279


GEN RETRIEVES ROWS FOR UDF IN SYSROUTINES RESULTING IN ERROR ADB1815E NO SYSROUTINES ROW FOUND FOR 'CREATE PROCEDURE'
PM17999
28_Oct
2010
UK61752


ALL COMMAND ON PANEL ADB2AUS "USER AUTHORIZATIONS SUMMARY" RESULTS SQLCODE -199 DUE TO MULTIPLE WH 10/07/07 FFA10
PM24212
PK79758
27_Oct
2010
UK61716


TEMPLATE USE OF GDG NOTATION (+1) CAUSES JCL ERROR.FFA10 PM24212IEFC624I INCORRECT USE OF PERIOD ON THE DD STATEMENT.
PM06003
27_Oct
2010
UK61716


DB MIG OF DATABASE COMPRISED OF IMPLICIT TS (S) FFA10 PM24212 GENERATES NO UTILIITIES FOR CHECK DATA, RUNSTATS, IMAGE COPY
PM11854
27_Oct
2010
UK61706


MERGE MESSAGES WILL BE CLARIFIED / CHANGE MANAGEMENT CM HELP PANELS CLARIFIED AS WHERE CHANGES SHOULD BE RUN FFA10 PM24212.
PM13392
27_Oct
2010
UK61716


NFDB29 ADMIN MIG SUPPORT FOR IMPLICIT LOB AND XML TABLESPACES. FFA10 PM24212.
PM18752
27_Oct
2010
UK61717


DSNU048I DSNUGDFL - INVALID OPERAND FOR KEYWORD 'POSITION' DURING LOAD. FFA10 PM22869.
PM21367
27_Oct
2010
UK61712


JCL ERROR DUE TO UNEXPECTED STATEMENT "ENDIF" APPEARS AFTER IMPORT VERSION FILE. FFA10 GA TAPE.
PM22106
27_Oct
2010
UK61713


DB2 ADMINISTRATION TOOL FOR Z/OS LOAD UTILITY FAILS WITH DSNU052I 190 11:26 DSNUGDFL-KEYWORD 'NUMRECS' FFA10 PM24212.
PK67596
27_Oct
2010
UK61714


RENAME TABLE, MESSAGE MISSING AFTER DROP TS, NO RESPONSE AFTER ENTER,CHECK RENAME TABLE FOR OLD TABLE NAME.FFA10
PM24212
PK70132
27_Oct
2010
UK61717


CM COMPARING 2 TABLES CHECK DATA FAILS IN APPLY WITH MSG DSNU214I. FFA10 PM24212
PM02594
27_Oct
2010
UK61716


DSNUPROC LIB PARM OF APFLIB IS GENERATED WHEN ADB2CUST :BL2LLIB TAG IS BLANK. FFA10 PM24212
PM06669
27_Oct
2010
UK61704


PANEL ADB2AO "FUNCTION AUTHORIZATIONS" SHOWS STORED PROC AUTH/ GR GRANT EXEC ON FUNCTION "NAME"."*" TO PUBLIC. FFA10 PM24212
PM06879
27_Oct
2010
UK61705


PANEL ADB2USC SPECIFY UTILITY OPTIONS ISSUES MESSAGE INVALID FOR FULL FIELD IF N OR Y IF CHANGELIMIT IS YES. FFA10
PM24212.
PM13202
27_Oct
2010
UK61707


INVALID DATA SET NAME, '(ADB2ATH)' PANEL ADB2CUS1. FFA10 PM22869"DB2 SECURITY EXIT TYPE" AUTH AND "DB2 ADMIN APF LIBRARY"
BLANK
PM14625
27_Oct
2010
UK61717


ALC WITH MISSING TABLESPACE MESSAGE TS.DB INSTEAD OF DB.TS AND RC=0 INSTEAD OF WARNING USER OF ISSUE. FFA10 PM24212
PM15036
27_Oct
2010
UK61708


BH COMMAND RESULTS IN MSGIRX0040I - ERROR RUNNING ADB2ZBH WHEN DB2 RANDOM GETPAGE COUNTER WRAPS. FFA10 PM27184
PM15328
27_Oct
2010
UK61709


INCORRECT SYNTAX BUILT BY PANEL ADB21TDE BUILD SQL DELETE PROTOTYPE. CONTAINS "WHERE AND".FFA10 PM22869
PM15989
27_Oct
2010
UK61710


REVOKE IMPACT REPORT DOES NOT CORRECTLY IDENTIFY PACKAGES THAT WILL BE INVALIDATED WHEN BOUND IN A LOWER DB2 LEVEL
PM17516
27_Oct
2010
UK61717


BR LINE COMMAND ENDS WITH SQLCODE -433 VALUE <XML-VALUE> IS TOO LONG WHEN TABLE CONTAINS A XML COLUMN. FFA10 PM24212.
PM18507
27_Oct
2010
UK61711


ADB2INC NOT FOUND WHEN CURRENT SQLID DIFFERENT THAN USERID %ADB2INC GIVES RC OF 20. FFA10 GA PRODUCT.
PM18517
27_Oct
2010
UK61717


DB2 ADMINISTRATION TOOL FOR Z/OS AND OBJECT COMPARISON TOOL FOR Z/OS RESTART ENHANCEMENTS. FFA10 PM24212.
PM19939
27_Oct
2010
UK61717


DB2 ADMINISTRATION Z/OS. ISPF ERROR CLONING WSL. FFA10 PM24212. BROWSING EMPTY DATASET OR MEMBER WITH CHECKBEGIN/END
STATEMENTS.
PM20271
27_Oct
2010
UK61714


AL/RDEF PANEL ADB21SAR ISSUES MESSAGE "VALUE OUT OF RANGE" FOR LARGE TABLESPACE WITH NO EXPLAINATION AS TO WHY. FFA10
PM24212.
PM20975
27_Oct
2010
UK61717


OC COMPARING 2 TABLES CHECK DATA FAILS IN APPLY WITH MSGDSNU214I RC08 WITH NO REBUILD INDEX UTILITY
PM22163
27_Oct
2010
UK61717


DB2 ADMINISTRATION TOOL FOR Z/OS 7.2 FENCING APAR TO ISSUE MESSAGE DB2 VERSION VRM IS NOT SUPPORTED. NO FFA10 720 ONLY.
PM16339
16_Oct
2010
UK61411


GEN MISSING COMMENT ON AUXILIARY TABLE WHEN BASE TABLESPACE GEN'ED. FFA10 PM24212
PM16790
16_Oct
2010
UK61412


THE GEN FUNCTION TRUNCATES THE "EXTERNAL NAME" VALUE FOR A LANGUAGE JAVA PROCEDURE. FFA10 PM24212
PM23227
16_Oct
2010
UK61413


DDL/GEN OF VIEW WITH AS <COLTYPE>(####) CCSID 1208) RESULTS IN PARSING ERROR. FFA10 PM24212
PM12069
30_Sep
2010
UK60966


ZPARM PLANMGMT=EXTENDED/BASIC RESULT IN TRIPLICATE OR DUPLICATE PACKAGE NAMES IN PANEL ADB21K
PM19723
30_Sep
2010
UK60966


DB2 ADMINISTRATION FOR Z/OS PANEL ADB21CUR NOT REFRESHED TO DISPLAY LATEST RUNSTATS.
PM10412
27_Sep
2010
UK60825


ALC PANEL ADB27C NEW DEFAULT INDICATOR S DDL DOES NOT HAVE WITH DEFAULT CURRENT SQLID PANEL AND ADB26CTU DEFAULT VALUE TOO
LONG
PK93283
23_Sep
2010
UK60735


VALIDATE WORK STATEMENT LIST / WSL SQLCODEN104 WHEN USER INSERTS MORE THAN DDL THAN EXPECTED INTO A SINGLE WSL STATEMENT
PM15267
23_Sep
2010
UK60785


DDL OR GEN OF TRIGGER USING CAST(XMLSERIALIZE(XMLFOREST AS XXXXXCAN RESULT IN CAST <EXPRESSION> NOT FOLLOWED BY AS
PM19871
23_Sep
2010
UK60741


DB2 ADMINISTRATION FOR Z/OS LOSS OF DATA WHEN CHANGING PARTITIONING SCHEME USING ALC AND
PM21881
23_Sep
2010
UK60742


CM IMPORT FAILS WITH ABENDS322 ONCODE150 STRINGSIZE CONDITION FROM ENTRY POINT ADB2CID AT STATEMENT 1273
PM10899
23_Sep
2010
UK60772


SM COMMAND, PANEL ADB2M1S SHOWS ONLY 1 VSAM DATASET ON DB2 V9 10/07/08 PTF
PECHANGE
PM11237
23_Sep
2010
UK60736


ALC PANEL ADB26CTU CHANGING FIELD "FOR ? DATA" DOES NOT RESULT IN ANY CHANGES ( PANEL ADB27C FIELD "ACTION" SAYS "NONE" )
PM11544
23_Sep
2010
UK60737


CM/CHANGE MANAGEMENT ANALYZE FAILS WITH A 'DUPLICATE RECORDS' ERROR MESSAGE INSTEAD OF A DESCRIPTIVE ERROR MESSAGE IN MERGE
PM11847
23_Sep
2010
UK60738


PANEL ADB21XA LOOP WHEN ALTER INDEX SIZE AND ? / QUESTION MARK USED IN PRIQTY FIELD
PM16704
23_Sep
2010
UK60739


DROP AND RECREATE OF TABLESPACE WITH PARTS > 254 GETS MESSAGE: LOAD NOT SUPPORTED FOR PARTITIONS > 254 WITH COMPRESSION.
PM17236
23_Sep
2010
UK60785


GEN AND DDL COMMANDS CREATE VIEW LOWERCASE COLUMN NAMES FOLDED TO UPPERCASE 10/08/06 PTF
PECHANGE
PM18983
23_Sep
2010
UK60773


DB2 ADMINISTRATION TOOL FOR Z/OS USING MIGRATE ON PANEL ADB28M WITH OPTION USE CUST. TABLE SETTINGS = YES CAUSES DIALOG
ERROR.
PM19519
23_Sep
2010
UK60740


DB2 ADMINISTRATION FOR Z/OS SCHEMA CHANGED TO "SINGLE" ON PANEL ADB26CT, WHEN USING LOOKUP "?" AND TABLE IS NOT FOUND.
PM07941
9_Sep
2010
UK60356
PM23329

GEN WSL EDIT LINE COMMAND ON PANEL ADB2W1 WORK STATEMENT LIST LIBRARY RC20 ISPT025 LIBRARY FORMAT ERROR / DOES NOT HAVE
TIR:
PM08490
9_Sep
2010
UK60356
PM23329

BATCH WSL SYSPRINT DSN NOT RETRIEVED FROM ADB2UCUS
PK82955
26_Aug
2010
UK60006


SQLCODE100 ISSUED ON PANEL ADB24 "DB2 CHANGE CURRENT SQL ID" WHEN ADBL CMOWN PARM OR :NICK :CMOWN INCORRECT
PM09097
26_Aug
2010
UK60009


I - INTERPRET LINE COMMAND / ADB21CI1 INTERPRETATION OF AN OBJECT IN SYSCOLUMNS TRUNCATED HIGH2KEY/LOW2KEY
PM10628
26_Aug
2010
UK60014


ADBCCME MERGE VERSION FILES REPORTS "ALTER INCONSISTENCY IN ROWTYPE, LGTH OR PREFIX" ENDS ADBC002E RC12
PM15669
26_Aug
2010
UK60011


MESSAGE NULLS/DEFAULT CHANGED FROM IDENTITY GENERATED BY DEFAULTTO IDENTITY GENERATED ALWAYS YET DDL HAS GENERATED BY DEFAULT
PK68648
26_Aug
2010
UK60014


DB2 ADMIN 720 ADD SIZE PARM TO DFSORT IN MERGE DELTA MODE
PM06188
26_Aug
2010
UK60007


WHEN USING RDEF AND TEMPLATES, LOAD UTILITY DOES NOT USE TEMPLATES ERRDDN, MAPDDN, WORKDDN1 AND WORKDDN2
PM08356
26_Aug
2010
UK60008


AL PANEL ADB21SAR DOES NOT KEEP PRIQTY, SECQTY OR STOGROUP VALUES FOR EXPLICT / VCAT DEFINED OBJECTS
PM09347
26_Aug
2010
UK60010


PANEL ADB2Z52U IPNAME DOES NOT ALLOW IPNAME OTHER THAN .COM
PM20325
26_Aug
2010
UK60012


DB2 OBJECT COMPARISON TOOL FOR Z/OS COMPARES TWO TABLES AND THE NEWLY INSERTED COLUMN IS OMITTED DURING LOAD.
PM16845
20_Aug
2010
UK59850


ADMIN SUPPORT FOR IMPORT VERSION FILES.
PM06943
8_Aug
2010
UK59531


SEL LINE COMMAND SQLCODEN485 ERROR WHEN DB2 RESOURCE LIMIT FEATURE ACTIVE
PK81371
27_Jul
2010
UK59210


AL RDEF TO PARTITIONED TABLESPACE TO REDUCE NUMPARTS PARTITIONS DOES NOT REDUCE THE PART LIMITKEY FOR THE INDEX
PK95000
27_Jul
2010
UK59211


ADBBIND MEMBER IN SAMPLE LIBRARY NEEDS TO BETTER EXPLAIN WHEN THE SQLCODEN206 MESSAGES ARE ACCEPTABLE
PM14771
27_Jul
2010
UK59216


AL/RDEF SKELETON ADB21SAM BUILT JCL THAT FAILS IN CONV2 STEP WITH RC08 MSG ERROR LOADING DSNHDECP , RC=0008
PM15888
27_Jul
2010
UK59217


ALC / RDEF FAILS WITH MSGDSNU070I RC8 RC08 IN LOAD UTILITY WITH MSG: KEYWORD OR OPERAND 'STATISTICS' INVALID WITH
'RESUME(YES)'
PM00715
27_Jul
2010
UK59212


MIG HPU TEMPLATE GDG GENERATES JCL ERROR
PM04462
27_Jul
2010
UK59213


PANEL ADBH22 MAXIMUM SQL STATEMENTS IS 1820 NOT 8120
PM09814
27_Jul
2010
UK59214


BIND COPY FROM REMOTE LOCATION FAILS
PM12150
27_Jul
2010
UK59215


SNAME VARIABLE USED IN ADB2UCUS DOES NOT RESOLVE IN SKELETONS FOR EXAMPLE ADB2UXO
PM07574
25_Jun
2010
UK58318


ALC MISSING PRIMARY KEY AFTER REL/ALTER OF INDEX
PM08740
25_Jun
2010
UK58316

HIPER

ALC OF A COLUMN FROM DECIMAL(5,3) TO DECIMAL(10,2) / DROP-SC ACTION RESULTS IN DATA BEING LOADED INCORRECTLY
PM10193
25_Jun
2010
UK58317


IMPORT OF CHANGES FILE WITH SET CURRENT SCHEMA AND BLANK MASK AND IGNORE RESULTS IN MERGE ERROR
PM16972
25_Jun
2010
UK58319


DB2 ADMINISTRATION USING ALC RC=1012, ALC TABLE STEP CNVRT50 ADBC133E "(" NOT IDENTIFIED IN LOAD STMT, ADB27AD.
PM04467
25_Jun
2010
UK58315


WSL ADB5405E LOAD SUMMARY REPORT PROCESSING DID NOT COMPLETE SUCCESSFULLY RC08 FOR WSL RESTARTED AFTER LOAD STEP COMPLETED
PK98756
15_Jun
2010
UK57955


MESSAGE "TABLE PARTITIONING NEEDED FOR TABLE BUT NO PARTITIONINGINFO AVAILABLE FROM INDEX/TABLE" GOCC002E RC12
PM15151
14_Jun
2010
UK57950


ONCODE=350 THE STRINGRANGE CONDITION WAS RAISED. FROM ENTRY POINT CATREC_TABLE
PM14291
7_Jun
2010
UK57708


PANEL ADB21XAR CREATE INDEX FIELD "CLOSE RULE" POPULATED WITH THE STRING CLO RESULTS IN MESSAGE "INVALID VALUE".
PM13605
7_Jun
2010
UK57708


DB2 ADMINISTRATION TOOL FOR Z/OS. ISPF DIALOG ERROR USING UTIL COMMAND ON STORAGE GROUP RESULTING IN A DIALOG ERROR.
PK44657
26_May
2010
UK57306
PM18983

INTERNAL ADMIN APAR.ALT TEMPLATE VALUES NOT REFLECTED IN BATCH JCL OR WSLS".
PK84359
26_May
2010
UK57306
PM18983

USER-SUPPLIED TEMPLATE NAMES NOT USED FOR ALT/ALCNT & ALT/ALULD UTLPUNCH AND UTLREC ARE USED
PK92927
26_May
2010
UK57306
PM18983

CM CHANGE TO LOB TABLESPACE REORG STEP FAILS RC08 WITH DSNU076I DSNURFITKEYWORD INVALID FOR REORG LOB TABLE SPACE
PM03908
26_May
2010
UK57306
PM18983

MIG DOESN'T READ ADB2CUST TAG VALUES
PK83366
26_May
2010
UK57306
PM18983

NFDB29 REVOKE PANELS,REVOKE IMPACT
PM11641
26_May
2010
UK57306
PM18983

DB2 ADMINISTRATION TOOL FOR Z/OS ADBJCLIP TO ENSURE LOAD OF DSNDECP FOR GOC2CMP.
PM12901
26_May
2010
UK57306
PM18983

PANEL ADB2ZZAL SYSTEM PARAMETERS - ARCHIVE LOG SHOWS A TRUNCATEDVALUE FOR "MAXIMUM ARCHIVE ENTRIES IN BSDS" / MAXARCH
PM03303
26_May
2010
UK57306
PM18983

ADDING PARTITIONS - ABEND4039 AT OFFSET +00001252 FROM CONVERT_LIMITKEY DURING ANALYZE
PM09926
26_May
2010
UK57306
PM18983

DB2 ADMINISTRATION FOR Z/OS. DB2 V8 UNLOAD UTILITY INCLUDES CLONE OPTION CAUSING THE UTILITY TO FAIL.
PM10427
26_May
2010
UK57306
PM18983

NFDB29 ADMIN SUPPORT FOR IMPLICIT LOB AND XML TABLESPACES.
PM11020
26_May
2010
UK57306
PM18983

ADB5043E *** RESTART PROCESSING WAS HALTED DUE TO A COMMAND MISMATCH *** SKIP NEXTED WSL WHICH FAILED SQLCODE -204
PM12311
26_May
2010
UK57306
PM18983

USERS OF DB2 ADMINISTRATION FOR Z/OS AT ADMIN STARTUP THE DB2 SSID ISN'T FOUND.
PK90881
22_Apr
2010
UK56307


PANEL ADB2Z2Z IS CONFIGURED FOR THE DSNTIZP STEP OF THE DB2 SAMPLE JOB DSNTIJUZ BUT NOT STEP DSNTIZA ASMA939U DSNTIXL
PK95067
22_Apr
2010
UK56307


IBM0441W ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED. ENTRY POINT CHECK_ALLOC UPDATE_SYMBTAB EDIT_DDL_STMT
CREATE_VIEW
PK98345
22_Apr
2010
UK56307


NFDB29 CC FEATURE DOES NOT COPY DSNDB06.SYSJAVA TABLESPACE TABLES SYSJARCONTENTS/SYSJAROBJECTS/SYSJAVAOPTS/SYSJAVAPATHS
PK99474
22_Apr
2010
UK56307


WSL TEMPLATE UNLOAD GENERATES MSG ADBT333I RC303
PM05496
22_Apr
2010
UK56307


GEN'ED TRIGGER SQLCODEN104 DUE TO EXTRA SPACES BETWEEN THE CONCATENATION CHARACTER AND A QUOTED SEMICOLON
PM09132
22_Apr
2010
UK56307


DUPLICATE DDNAME ALLOCATIONS RUNNING MIG
PM09370
22_Apr
2010
UK56307


PANEL ADB2W1R VALIDLY DISPLAYS '(PREFIX, MAX VAR CHARS)' HOWEVER NO EXPLAINATION OF WHY IS GIVEN
PM09496
22_Apr
2010
UK56307


WSL NO JCL TO RUN WORK STMT LIST BUILT WHEN PANEL ADB2W1R HAS "GENERATE ONE JOB" NO
PM09992
22_Apr
2010
UK56307


ANALYZE SEGSIZE MASK ISSUE WITH MERGE / UNIVERSAL TABLESPACE MESSAGE BUT NO SEGSIZE IN DDL
PM10546
22_Apr
2010
UK56307


PANEL ADB27A DOES NOT SUPPORT THE SQLID COMMAND LINE COMMAND.
PM11598
22_Apr
2010
UK56307


DB2 ADMINISTRATION TOOL FOR Z/OS GEN USER CHANGING THE SEGSIZE OF A LOB TS TO SOMETHING OTHER THAN ZERO (EXPECTED VALUE)
PM06657
22_Apr
2010
UK56307


HELP PANELS DO NOT EXPLAIN WHY THE VALUE FOR SCHEMA MAY NOT EXIST AS AN ACTUAL SCHEMA
PM08505
22_Apr
2010
UK56307


ALC VIA CHANGE MANAGEMENT / CM DOES NOT ADD THE DEFAULT VALUE ENTERED ON PANEL ADB26CTU ALTER TABLE
PM08903
22_Apr
2010
UK56307


CLONE WSL SQLCODEN104 COMMENT ON TABLE
PM08993
22_Apr
2010
UK56307


AL/RDEF BASE TABLESPACE CHANGE SIMPLE TO SEGMENTED/SEGSIZE RESULTS IN SQLCODEN601 ON CREATE LOB TABLESPACE & UTILS ON ONLY
BASE
PM09413
22_Apr
2010
UK56307


PANEL ADB21XI1 FIELD "INDEX SUBPAGE SIZE(BYTES):" DOES NOT CORRECTLY DISPLAY THE VALUE FOR AN INDEX CREATED BEFORE DB2 9
PM10034
22_Apr
2010
UK56307


RETURN CODE 66 INVOKING ADBTTP EXEC ADB2TSO RC= 66 HPU NOT USED WHEN UNLOAD(HPU) APPEARS IN WSL
PM10884
22_Apr
2010
UK56307


DB2 ADMINISTRATION TOOL FOR Z/OS UTILITY SKELETONS TO SUPPORT LISTDEF.
PM09418
9_Apr
2010
UK55960


GEN ABEND0C8 ONCODE340 SIZE CONDITION WHEN REBIND COUNT EXCEEDS 36400
PM10940
9_Apr
2010
UK55960


CHANGES REPORTED FOR A TRIGGER WHEN NONE EXIST IF CREATED BEFOREDB2 R810 AND SCHEMA OR NAME < 8 CHARACTERS
PM10189
27_Mar
2010
UK55638
PM17999

EXEC ADBRTAB NOT INCLUDED IN THE SAMP MEMBER ADBFB2VB CREATE VB CLIST AND EXEC
PK85451
26_Mar
2010
UK55638
PM17999

PANEL ADB2AUS "USER AUTHORIZATIONS SUMMARY" SAYS "TABLE " AND SHOULD SAY "TABLE, VIEW, MQT ETC".
PK91029
26_Mar
2010
UK55638
PM17999

CREATE A DPSI UNDER ADMIN, LIKE DOESN'T WORK
PK99733
26_Mar
2010
UK55638
PM17999

GEN COMMAND TRIGGER ISSUES MESSAGE SYNTAX ERROR IN INSERT STATEMENT ADB1847E WARNINGTOKEN REASON CODE = 28 TOKEN = (
PM04561
26_Mar
2010
UK55638
PM17999

GEN OR DDL AGAINST A COMPLEX STORED PROCEDURE RESULTS IN ADB1847E WARNING: ERROR PARSING DDL NSP STATEMENT.
PM06076
26_Mar
2010
UK55638
PM17999

SM PANEL ADB2M "DB2 SPACE MANAGER"'S OPTION 3 "INDEX SPACE ESTIMATOR" SHOWS A ZERO KEY LENGTH ON PANE ADB2MEX
PM07573
26_Mar
2010
UK55638
PM17999

SQLCODE -582 WHEN USING DS LINE COMMAND FROM PANEL ADB21D FAILS ONLY IN DB2 V8 CM ENVIRONMENT 10/03/08 PTF
PECHANGE
PM03374
26_Mar
2010
UK55638
PM17999

ADMIN UTIL "OO" ONLINE REORG OF USER-MANAGED DATA SETS AND NON-STOGROUP DEFINED OBJECTS SUCH AS DSNDB06.SYSPKAGE ENDS
DSNU296I
PM07902
26_Mar
2010
UK55638
PM17999

NFDB29 RENAME INDEX SUPPORT FOR ADMIN.
PM08721
26_Mar
2010
UK55638
PM17999

CLONE'D WSL LOAD STEP FAILS WITH DSNU053I - DSNURWUF - FIELD NOT FOUND DUE TO QUOTES / QUOTED RESERVED WORD ISSUE
PM09108
26_Mar
2010
UK55638
PM17999

GEN / DDL PARSING ISSUE FOR FUNCTIONS CREATED PRIOR DB2 V9 RESULTING IN TRUNCATION OF THE DDL
PK89537
18_Mar
2010
UK55333


GOCC024E - UNEXPECTED CATALOG ROW ON TARGET FILE
PK92925
18_Mar
2010
UK55333


CM LOB TABLE STOGROUP CHANGE RESULTS IN RC12 AUX TABLES ARE PROCESSED WITH THE BASE TABLE. PLEASE INCLUDE THE BASE TABLE
PM09403
18_Mar
2010
UK55333


ONCODE451 STORAGE CONDITION FROM ENTRY POINT MASK_STRING 10/06/15 PTF
PECHANGE
PK71133
18_Mar
2010
UK55333


ADMIN 720 MERGE SUPPLIES OLD TABLESPACE NAME IN THE VERSION FILERECORD USING CM CAUSES OC PROBLEM WITH TABLE SPACE NAME
CHANGE.
PM06659
18_Mar
2010
UK55333


GEN CMD REBIND SYNTAX INVALID RESULTS IN DSNECP55 INVALID SYNTAXFOR PACKAGE KEYWORD PARAMETER ( SPACES BETWEEN NAMES )
PM06883
18_Mar
2010
UK55333


SEGSIZE 64 MASK APPLIED EVEN THOUGH TABLESPACE IS PARTITIONED
PK84529
26_Feb
2010
UK54756
PM09403

NFDB29 - SUPPORT CLONED TABLES - OC, RENDB & MIG
PK92926
26_Feb
2010
UK54756
PM09403

CM ONCODE CONDITION 520 IN MERGE_RELATIONS ADBC012E - SUBSCRIPT RANGE CONDITION DETECTED RC12
PK95761
26_Feb
2010
UK54756
PM09403

RENAMECOL DOES NOT SUPPORT WILDCARDING
PK96496
26_Feb
2010
UK54756
PM09403

PANEL ADB2EC "CREATE PLAN_TABLE" SQLCODEN874 AS CCSID UNICODE USED EVEN IF "IN" LOOKUP SELECTION SELECTS AN EBCDIC
TABLESPACE
PM02139
26_Feb
2010
UK54756
PM09403

RTS COMMAND SHOWS LRSN FIELD INCORRECTLY FORMATTED IN PANEL ADB21SS AND ADB21SSI
PM02749
26_Feb
2010
UK54756
PM09403

PANEL ADB21XI1 FIELD "INDEX SUBPAGE SIZE(BYTES):" DOES NOT CORRECTLY DISPLAY THE VALUE FOR AN INDEX CREATED BEFORE DB2 9 NFM
PM03688
26_Feb
2010
UK54756
PM09403

DSNT408I SQLCODE -553 UPON ACCESSING PANEL ADB2
PM04872
26_Feb
2010
UK54756
PM09403

MSG GOCC025E - DUPLICATE RECORD WAS DETECTED FOR OBJECT<TRIGGER NAME> ERROR PROBABLY CAUSED BY MASKING. RC=12
PM04911
26_Feb
2010
UK54756
PM09403

DSNU310I DSNURCON DISCARDED CONVERSION ERROR OR DSNU1218I DSNUULIA LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED
PK97797
26_Feb
2010
UK54756
PM09403

PANEL ADB21II1 INTERPRETATION OF AN OBJECT IN SYSCOPY DOES NOT SHOW THE "RECOVERY STATUS CHANGE REASON" C 09/10/20 PTF
PECHANGE
PM05502
26_Feb
2010
UK54756
PM09403

DB2 V8 COMPAT MODE -4700 ISSUE WITH CHANGE MANAGEMENT
PM03875
26_Feb
2010
UK54756
PM09403

PANEL ADB2Z2D2 COLUMN TOKEN FILTER FAILS WITH MSG NO ROWS FOUND
PM05422
26_Feb
2010
UK54756
PM09403

CHANGES TO PANEL GOC5 DESCRIPTION OF DATASETS AND CONSISTENT NAMING CONVENSION FOR BATCH VS ONLINE GENERATION.
PK83365
21_Jan
2010
UK53736


ERROR ON PANEL ADB2E1 (DRIVER PANEL) NFDB29
PK90647
21_Jan
2010
UK53736


'RO' LINE COMMAND PANELS ADB21D AND ADB21T PANELS'INVALID LINE CMD'
PK94770
21_Jan
2010
UK53736


DDL IBM0023S ONCODE=670 THE CONVERSION CONDITION FROM ENTRY POINT GET_REQUEST_PARM
PK95228
21_Jan
2010
UK53736


PANEL ADB2USU DOES NOT VALIDATE THAT THE OPTIONS SPECIFIED ARE VALID DSNU049I DSNUGPRS INVALID OPERAND FOR KEYWORD
PK95436
21_Jan
2010
UK53736


ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUAL INTFIN: AAAAAAAA C001 : DSN_IDENTITY
PK95767
21_Jan
2010
UK53736


CM INVALID CREATE VIEW SYNTAX IN CHG FILE AND BATCH IMPORT COND CODE 1012 INVALID <FULL-VIEW-NAME> AFTER CREATE VIEW TOKEN =
PM03472
21_Jan
2010
UK53736


SQL PERFORMANCE ANALYZER TABLESPACE FAILED WITH ISPS108
PM00170
21_Jan
2010
UK53736


ALC ABENDU4038 RC01 ONCODE340 SIZE CONDITION ADB27AC AT STATEMENT 13691
PM02487
21_Jan
2010
UK53736


UNIT=TAPE HAS A SPACE ALLOCATION
PM02892
21_Jan
2010
UK53736


NFDB29 - ADMIN BATCH INITIALIZATION FOR TRUSTED CONTEXT.
PM04223
11_Jan
2010
UK53469


PTF UK53038 OMITS SQLERROR CLAUSE FOR BIND PACKAGE(ADBL) MEMBER(ADB2GET) IN SAMPLE ADBBIND JOB 09/12/28 PTF
PECHANGE
PK99438
18_Dec
2009
UK53038
PM04223
PM10899

CM UNNEEDED ADD PRIMARY KEY WHEN PROCESSING OBJECTS RECREATED BEFORE DB2 RELEASE 710
PK90654
18_Dec
2009
UK53038
PM04223
PM10899

SELECTION CRITERIA WHILE USING A LIKE OPERATOR DOES NOT "AUTOMATICALLY APPEND ONE" AS PER PANEL ADBH1 IF LEADING %
USED
PK90959
18_Dec
2009
UK53038
PM04223
PM10899

SM LISTCAT OF DSNDB06 TABLESPACES E.G. SYSCOPY RESULTS IN ISRB000 PARAMETER MISSING DATASET OR DATAID PARAMETER
PK96630
18_Dec
2009
UK53038
PM04223
PM10899

GEN OF VIEW WITH CATALOG VALUES OVERRIDDEN"CREATOR =" RESUL TS IN INVALID DDL ( LEADING PERIOD IN VIEW NAME ) SQLCODEN104
PM00685
18_Dec
2009
UK53038
PM04223
PM10899

GEN OR DDL FOR NSP MSGADB1847E RC28 INVALID TOKEN AFTER FOR KEYWORD - EXPECTED KEYWORD ORDINALITY
PM00038
18_Dec
2009
UK53038
PM04223
PM10899

SQLCODEN805 ADB8SQL RENAME AS SADBSAMP ADBBIND SAYS BIND PACKAGE(ADBL) **** V8 ONLY ****
PM00905
18_Dec
2009
UK53038
PM04223
PM10899

INDEX ON EXPRESSION ADB21TXC ADB21XC INCORRECT COLUMN INFO
PK84527
18_Dec
2009
UK53038
PM04223
PM10899
HIPER

DB29 - IMPLICIT OBJECTS - GEN & REGISTER 09/12/08 PTF
PECHANGE
PK97587
18_Dec
2009
UK53038
PM04223
PM10899

REBIND SYNTAX INVALID RESULTS IN DSNECP55 INVALID SYNTAX FOR PACKAGE KEYWORD PARAMETER ( SPACES BETWEEN NAMES )
PM01363
18_Dec
2009
UK53038
PM04223
PM10899

GEN/DDL OF SP FAILS WITH RC28 AND MESSAGE SPECIAL REGISTER ERRORAFTER CURRENT OR MESSAGE MISSING <SELECT-LIST> OR * AFTER
T
PK98931
28_Nov
2009
UK52369


PANEL ADB21T SORT ROWS COMMAND DOES NOT SORT CORRECTLY 09/11/25 PTF
PECHANGE
PM01473
18_Nov
2009
UK52105


LKEY DISPLAY FOR TABLE DIFFERS FROM LKEY DISPLAY FOR INDEX FOLLOWING USE OF ALTER TABLE ROTATE PARTITION
PK88898
16_Nov
2009
UK52000
PK84527

ADMIN 720 UNABLE TO ALLOCATE DEBUG DATASET ON PANEL ADB2Z2Z. FILE ALREADY IN USE.
PK90746
16_Nov
2009
UK52000
PK84527

PANEL ADB21T DOES NOT ALLOW SORT BY SCHEMA
PK95400
16_Nov
2009
UK52000
PK84527

GEN COMMAND DOES NOT GENERATE THE CREATE VIEW SYNTAX WHEN THE MASKING IS USED. MESSAGE ADB1847E ISSUED.
PK95771
16_Nov
2009
UK52000
PK84527

ADMIN CM IMPORT ABENDU4087 RC03 ONCODE350 WHEN MASK CONTAINS NO LINES
PK96017
16_Nov
2009
UK52000
PK84527

GEN / DDL AGAINST VIEW WHICH AS A "WITH CS" CLAUSE FAILS WITH "MISSING CHECK AFTER WITH" AND "TOKEN NUMBER = NNN, TOKEN =
CS"
PK96270
16_Nov
2009
UK52000
PK84527

ABEND 0C4000 HEX OCCURRED PROCESSING COMMAND 'ADB2WCL ' ON CLONE WSL WITH MASK
PK96276
16_Nov
2009
UK52000
PK84527

PANEL ADB21CDI INCORRECT HELP PANEL DESCRIPTION FOR PERCENT COLUMN AND INCORRECT OUTPUT FROM INTERPRET LINE COMMAND
PK96741
16_Nov
2009
UK52000
PK84527

LKEY DISPLAY FOR TABLE DIFFERS FROM LKEY DISPLAY FOR INDEX FOLLOWING USE OF ALTER TABLE ROTATE PARTITION
PK84534
16_Nov
2009
UK52000
PK84527

NFDB29 - UTILITIES - SUPPORT REMAINING NEW AND CHANGE UTILITY OPTIONS
PK96961
16_Nov
2009
UK52000
PK84527

GEN COMMAND DOES NOT GENERATE THE CREATE TRIGGER AND NSP SYNTAX WHEN MASKING IS USED. MESSAGE ADB1847E ISSUED.
PK98419
16_Nov
2009
UK52000
PK84527

PANEL ADB21 "SYSTEM CATALOG" L - COLLECTIONS WITH NAME AND GRANTEE FIELDS SHOWS "NO ROWS RETURNED" MESSAGE INCORRECTLY
PK80429
20_Oct
2009
UK51207


DB2 ADMIN TOOL MERGE OC JOB GETTING MESSAGE-CREATE TABLE TABLEA LIKE TABLEB NOT YET SUPPORTED- ON A VIEW WITH A LIKE CLAUSE.
PK90730
20_Oct
2009
UK51207


ABILITY TO UPGRADE LISTDEF AND TEMPLATE USER DEFINED TABLES ON PANEL ADB25 SQLCODEN206 DSNTYPE
PK91140
20_Oct
2009
UK51207


HELP PANEL ADBHAT LIST GT GRANTEE TYPE P AS PLAN RATHER THAN THEDB2 DESC OF SYSIBM.SYSTABAUTH.GRANTEETYPE P IS PLAN OR
PACKAGE
PK93309
20_Oct
2009
UK51207


PANEL ADB21CUR UPDATE RUNSTATS INFORMATION SHOWS A TRUNCATED VALUE FOR THE HIGH2KEY/LOW2KEY FOR TIMESTAMP 09/08/12 PTF
PECHANGE
PK95046
20_Oct
2009
UK51207


GEN NSP MISSING SEMI-COLON AFTER SQL_PROCEDURE_STATEMENT STORED PROCEDURE "TOKEN = EXCEPTION"
PK95063
20_Oct
2009
UK51207


UNABLE TO LOCATE ROW TO UPDATE WHEN ALTERING TABLE ADBC002E - SEVERE ERROR. MERGE TERMINATES RC12
PK95656
20_Oct
2009
UK51207


SYNTAX ERROR 41 IN ADB2M1VD SYS00023: BAD ARITHMETIC CONVERSION - LINE 49: VSQTY = SQTY%4 SPACE MANAGEMENT VDEF PANEL ADB2M1S
PK96512
20_Oct
2009
UK51207


GEN NSP MISSING SEMI-COLON AFTER SQL_PROCEDURE_STATEMENT STORED PROCEDURE "TOKEN = (" LEFT PARENTHESIS
PK76472
20_Oct
2009
UK51207


HPU UNLOAD FAILS WITH RETURN CODE 16 (REASON CODE 0X107C000)
PK84524
20_Oct
2009
UK51207


NFDB29 CREATE ALTER PART 2 ( STOGROUP, DATABASES, INSTEAD OF TRIGGER, TRUSTED ROLES & CONTEXT )
PK94597
21_Sep
2009
UK50334


IBM0361W ONCODE=350 THE STRINGRANGE CONDITION WAS RAISED. FROM ADB27AC AT ENTRY POINT CONVERT_CHAR_TO_NUM AND CONVERT_UNLOAD
PK93111
18_Sep
2009
UK50262


ADBTEP2 SQLCODEN104 ILLEGAL SYMBOL "SCHEMA". ONLY DB2 V7 IS AFFECTED. USERS RUNNING DB2 V8 NFM AND V9 ARE NOT AFFECTED.
PK79735
18_Sep
2009
UK50262


GEN OF TRIGGER RESULTS IN SQLCODEN204 / SQLSTATE42704
PK84029
18_Sep
2009
UK50262


MIG ADB1654W ISSUED WHEN "NEW TS STORAGE GROUP" AND "CREATE STORAGE GROUP" YES SPECIFIED SQLCODEN601 FOR CREATE STOGROUP
PK86518
18_Sep
2009
UK50262


PANEL ADB2AUS ALWAYS SHOWS MESSAGE "AUTHORITY INCLUDES SYSADM"
PK88041
18_Sep
2009
UK50262


SQLCODE -873 USING UT LINE COMMAND IN DB2 V8 CM
PK94470
18_Sep
2009
UK50262


GEN AND MIG OMIT SET CURRENT SQLID FOLLOWING GRANT WHEN GENERATE CATALOG STATS IS YES AND RUNSQLID IS USED
PK94699
18_Sep
2009
UK50262


GEN SQLCODEN304 DATA TYPE BIGINT HOST VARIABLE IN POSITION 32 WITH DATA TYPE INTEGER AFTER APPLYING PTF 09/08/26 PTF
PECHANGE
PK79599
18_Sep
2009
UK50262


COPY UTILITY SYNTAX ERROR ( NO TABLESPACE SPECIFIED ) FOR IMPLICIT OBJECTS RESULTS IN DSNU049I DSNUGPTS FOR KEYWORD
'TABLESPACE'
PK83355
18_Sep
2009
UK50262


NFDB29 CREATE/ALTER/DROP SUPPORT ALL NEW OPTIONS ON CREATE/ALTERSTATEMENT. SUPPORT SCHEMA ON CREATE.
PK70426
18_Sep
2009
UK50262


INCONSISTANT SQL RESULTS WHEN SELECTING FIRSTKEYCARD AND FULLKEYCARD FROM SYSIBM.SYSINDEXES USING PANEL ADB221
PK58093
20_Aug
2009
UK49451


ABENDX37 FOR THE ADBIN DDNAME IN EXEC ADBTSIN
PK83958
20_Aug
2009
UK49451


IAT4404 DATASET NOT FOUND MESSAGE WHEN USING DD AND CO "CONNECT TO REMOTE SUBSYSTEM" OPTIONS AS INITIAL SUBSYSTEM STEPLIB
USED
PK85852
20_Aug
2009
UK49451


CCSID VERIFY PANEL ADB2CSID WHEN CCSIDS ARE BOTH 37
PK86126
20_Aug
2009
UK49451


MESSAGE "TABLE PARTITIONING NEEDED FOR TABLE BUT NO PARTITIONINGINFO AVAILABLE FROM INDEX/TABLE" GOCC002E RC12
PK86506
20_Aug
2009
UK49451


UR LINE COMMAND ON PANEL ADB21XC "COLUMNS IN INDEX" LEADS TO PANEL ADB21CUR "UPDATE RUNSTATS INFORMATION" COLCARDF NOT
POPULATED
PK86535
20_Aug
2009
UK49451


ON PANEL ADB2Z2RU, MANY FIELDS CAN'T BE UPDATED
PK87606
20_Aug
2009
UK49451


MIG PANEL ADB28M DROP ISSUES WHEN "DDL N" AND "CATALOG STATISTICS Y" SPECIFIED SQLCODE100 FOR UPDATE SQL ON TARGET
PK87630
20_Aug
2009
UK49451


WRONG COMPRESS AND TRACKMOD VALUES DISPLAYED ON PANEL ADB21SPI
PK89062
20_Aug
2009
UK49451


ABEND0C4 IN ADBCUPD AFTER APAR PK70636 / PTF UK40536
PK89605
20_Aug
2009
UK49451


ADMIN MIG USING HPU SKELETON ADB28HPU ISPF ERROR. ZERRLM = INVALID CONTROL WORD PARAMETER, ADB28HPU RECORD-229.
PK92512
20_Aug
2009
UK49451


ADMIN/OC COMPRESS YES IGNORED WHEN SPECIFIED FOR SINGLE TABLE SPACE PARTITIONS
PK93025
20_Aug
2009
UK49451


ADMIN DDL/GEN ON NSP FAILED W/ ONCODE=520, SUBSCRIPTRANGE CONDITION AND NSP FAILED WITH PARSER ERROR.
PK93074
20_Aug
2009
UK49451


GEN/DDL STORED PROCEDURE FAILS INVALID TOKEN AFTER = KEYWORD - EXPECTED KEYWORD STATEMENT-INFORMATION-ITEM-NAME
DB2_NUMBER_ROWS
PK78379
20_Aug
2009
UK49451


DSP LINE COMMAND OUTPUT / DROP IMPACT REPORT OUTPUT FOR PLANS AND PACKAGES INVALIDATED BY RENAME TABLE.
PK82262
20_Aug
2009
UK49451


ALC INSERT COLUMN PANEL ADB27C DOES NOT PROMPT FOR DEFAULT VALUE WHEN DEFAULT Y SPECIFIED
PK69983
20_Aug
2009
UK49451


TEMPLATE FOR UNLDDN = TAPE RESULT IN IKJ56221I DATA SET XXX.XXX.ULD.T001 NOT ALLOCATED VOLUME NOT AVAILABLE
PK91811
30_Jul
2009
UK48848


GEN RC12 SQLCODEN512 ADB1649E ADB2REM: UNEXPECTED SQLCODE IN : OPEN C_TP WHEN REFERENCING DSNDB04
PK72446
25_Jul
2009
UK48694
PK94699
PK98931
PM17236

NATIVE STORED PROCEDURES SUPPORT FOR DB29 NFDB29
PK76172
18_Jun
2009
UK47570
PK93111

INCORRECT LOAD SYNTAX WITH TEMPLATES DSNU071I DSNU012I
PK79517
18_Jun
2009
UK47570
PK93111

MISSING DB2 R810 TEMPLATE UTILITY KEYWORD DSNTYPE MISSING FROM PANEL ADB25TS "TEMPLATE DISK OPTIONS" - ADMIN LOBTEMPLATE
ADBL1
PK84360
18_Jun
2009
UK47570
PK93111

PANEL ADB23, DATABASE NAME FILTER IS IGNORED
PK84533
18_Jun
2009
UK47570
PK93111

PERFORMANCE IMPROVEMENTS TO RTS AGAINST TABLESPACE
PK77115
18_Jun
2009
UK47570
PK93111

PANEL ADB2Z51 "DISPLAY/UPDATE LUNAMES" FUNCTIONS DO NOT SUPPORT DB2 R810 FORMAT 24 BYTE LU NAME
PK84672
18_Jun
2009
UK47570
PK93111

ALC UNLOAD METHOD DSNTIAUL DOES NOT HONOUR PANEL ADB2UPA "BATCH JOB UTILITY PARAMETERS" "MAX DASD" VALUE
PK70300
18_Jun
2009
UK47570
PK93111

ADMIN 720 CHANGE MANAGEMENT DB2 V9 SUPPORT FOR REGISTER.
PK72442
18_Jun
2009
UK47570
PK93111

GEN, OC, AND CM SUPPORT OF DB2 9 NFDB29 FSS
PK79529
18_Jun
2009
UK47570
PK93111

ALC PROCESS USES DROP/CREATE STRATEGY RATHER THAN ALTER STRATEGYWHEN TABLE HAS DATA CAPTURE CHANGES ATTRIBUTE
PK80573
18_Jun
2009
UK47570
PK93111

AFTER RUNNING ALC ON A TABLE, THE COMMENTS ON TRIGGERS ARE DISAPPEARED.
PK84171
18_Jun
2009
UK47570
PK93111

SQLCODEN551 WHEN USING CATALOG COPY AND OPTION H SCHEMAS FROM PANEL ADB21 SYSTEM CATALOG
PK82248
27_Apr
2009
UK46071


ALC JES3 MESSAGE IAT4404 DATASET NOT FOUND FOR DATASET REFERENCED BY C001 AND U001 DD WHEN ENABLE RESTORE USED ON PANEL
ADB27A
PK83736
27_Apr
2009
UK46071


PANEL ADB2Z2U2 DOES NOT REFRESH ON ENTER POST APPLY OF APAR PK68569 09/04/01 PTF
PECHANGE
PK83989
27_Apr
2009
UK46071


SAMPLE JOB ADBFB2VB DOES NOT INCLUDE MEMBER ADBUNQUO
PK79044
4_Apr
2009
UK45503

HIPER

ABENDU4091 RC0B IN ADB2WVL ADB2WVL LINE 261 SIGNAL ERROR
PK79865
4_Apr
2009
UK45503


SQLCODEN104 AS INPUT STATEMENTS ARE OUT OF SEQUENCE I.E. PART LIMITKEY STATEMENT BEFORE ALTER TABLE STATEMENT
PK77131
4_Apr
2009
UK45503


MSG SQL DD STATEMENT MISSING AND GENERATE DDL AND/OR GENERATE STATS REQUESTED ADB1192I ADB2GEN - NOW TERMINATING
PK78681
4_Apr
2009
UK45503


ADMIN DB2 V9 RESTRICT,CLONED TABLES,XML,HIDDEN COLUMNS.
PK79601
4_Apr
2009
UK45503


ALTER TABLE STORAGE GROUP WITH CM ENABLED RESULTS IN DB2 DOING A STOP/ALTER/START. EXPECTED AN ALTER ONLY.
PK80100
4_Apr
2009
UK45503


GOC2DTC //S01DDL RC16 "MISSING SEMICOLON AFTER TRIGGERED ACTION"
PK80188
4_Apr
2009
UK45503


DB2 9 ALTER INDEXSPACE BUFFERPOOL SUPPORT NFDB29
PK80798
4_Apr
2009
UK45503


DB2 ADMIN GEN INCORROUT FOR INTERPRET COMMAND FOR MQT'S WHICH HAVE BEEN ALTERED.
PK82043
4_Apr
2009
UK45503


RTS COMMAND DOES NOT QUALIFY THE INDEX NAME WITH THE CREATOR FIELD SO MORE ROWS ARE RETURNED THAN EXPECTED
PK80385
4_Apr
2009
UK45503


PANEL ADB2ZBH2 "BUFFER POOL HIT RATIOS" INFORMATION DOES NOT MATCH OUTPUT OF -DIS BUFFERPOOL DETAIL REPORT
PK81670
4_Apr
2009
UK45503


DB2 ADMIN HELP PANEL ADBH1TC TOO LARGE.
PK81961
13_Mar
2009
UK44914

HIPER

JOBSTEP T03COMP ABENDU4038 RC01 AFTER UK42507 APPLIED WITHOUT INCLUDING OC PTF UK42511 IN SAME S 09/03/10 PTF
PECHANGE
PK78001
12_Mar
2009
UK44862
PK93309

WSL COMMAND LINE COMMAND MESSAGE "INVALID CMD" ON PANEL ADB2US
PK78572
12_Mar
2009
UK44860


DB2 ADMIN IMPORTING AN INCORRECT STATEMENT USING TSO, TSO WILL LIST THE SAME PARSER ERROR MESSAGE TWICE.
PK78707
12_Mar
2009
UK44862
PK93309

PANEL ADB2Z2U2 "COUNT" FIELD TRUNCATES THE VALUE TAKEN FROM THE -DISPLAY UTIL COMMAND
PK79551
12_Mar
2009
UK44860


DB2 ADMIN LOAD SUMMARY REPORT OPTION TO SYSOUT OR DATASET.
PK80070
12_Mar
2009
UK44860


ADBTEP2 RESTART SUFFIX COLUMN IN ADBCHKPT RECORD ISSUE CAUSE INCORRECT RESTART ADB5097I RESTART REQUESTED, BUT NO CHECKPOINT
PK80471
12_Mar
2009
UK44862
PK93309

ALC ALTER INDEX BEFORE CREATE TABLE / CREATE INDEX RESULTS IN SQLCODEN204 DSNT408I ERROR AAA.AAA IS AN UNDEFINED NAME
PK74177
12_Mar
2009
UK44862
PK93309

MERGE3 RC12 SUBSCRIPTRANGE RAISED DUE TO AN INTERNAL ERROR PROGRAM ADBCCMM DETECTED AN ONCODE CONDITION 520 MERGE_TABLES
PK76441
12_Mar
2009
UK44860


ADBTEP2 MAY FAIL WITH PARAMETER STRING EXCEEDS ALLOWABLE LIMIT OF 100 (DECIMAL) CHARACTERS.
PK78569
12_Mar
2009
UK44862
PK93309

INCORRECT CURSOR PLACEMENT ON PANEL ADB222 AFTER "PROCESSING ERROR" MESSAGE ISSUED
PK79039
12_Mar
2009
UK44860


AN MESSAGE ADB3013E ERROR PROCESSING TABLE NO MATCHING PRIMARY INDEX OR INDEX ENFORCING UNIQUE CONSTRAINT
PK79254
12_Mar
2009
UK44862
PK93309

MIG FUNCTION ADB280J JCL WITHOUT SDSNLOAD IN THE STEPLIB ISSUES MESSAGE COMMAND DSN NOT FOUND OR REXX IDENTIFIER IS MISSING+
PK79487
12_Mar
2009
UK44862
PK93309

DISPLAY COLUMNS FOR HIGH2KEY AND LOW2KEY DOES NOT HAVE READABLE VALUES.
PK71139
12_Mar
2009
UK44860


ADB2WVL ABENDS WITH RC=4091
PK72452
12_Mar
2009
UK44860


WHEN CONNECTING VIA DRDA TO ANOTHER SUBSYSTEM, DISPLAY OF TABLESPACE STATUS USES CURRENT SUBSYSTEM
PK73523
12_Mar
2009
UK44862
PK93309

JCL DOES NOT USE SYSREC TEMPLATE ON LOAD WHEN TEMPLATE IS MANUALLY CHANGED, RESULTING IN DATASET ALLOCATION ERROR
PK79642
12_Mar
2009
UK44862
PK93309

REBUILD INDEX SYNTAX ERROR
PK79698
12_Mar
2009
UK44862
PK93309

ALC PANEL ADB27A 'DB2 ADMIN ALTER' OPTION 'RUN IMAGE COPY' ALWAYS NO IMAGECOPY CREATED SO TABLESPACE IS LEFT IN RW,COPY
STATUS
PK80068
12_Mar
2009
UK44862
PK93309

DB2 ADMIN SAMP LIBRARY MEMBER ADBBIND MISSING GRANT EXECUTE FOR PLAN ADB2CID TO PUBLIC.
PK80170
12_Mar
2009
UK44862
PK93309

SAMP(ADBCHKPT) CONTAINS ONLY GRANT SELECT FOR TABLE ADBCHKPT YET PANEL ADB2Z2B1 ALLOWS DELETE/INSERT/UPDATE ACTIONS
PK69710
10_Feb
2009
UK43898


CONVERT OF DATE TO TIMESTAMP FAILS WITH INPUT FIELD INVALID ERROR CODE '14' FOR DECP DATE=EUR
PK76540
10_Feb
2009
UK43898


ALC ADB27A DROP ALIAS YES DROPPED BUT NOT RECREATED
PK78834
10_Feb
2009
UK43898


CHANGE MANAGEMENT CM "INVALID TOKEN AFTER LEFT PAREN - EXPECTED COLUMN NAME" MESSAGE WHEN COLUMN NAME HAS EMBEDDED SEMICOLON
PK76150
10_Feb
2009
UK43898


PANEL ADB2314 "TABLE SPACE MAINTENANCE" DOES NOT PROVIDE FACILITIES TO FILTER PARTITIONED OBJECTS RESULTING IN DUPLICATE
UTILS
PK76668
10_Feb
2009
UK43898


PANEL ADB2ZBH2 "BUFFER POOL HIT RATIOS" FIELDS RANDIO AND RANDHR INCORRECT VALUES
PK78814
10_Feb
2009
UK43898


LISTDEF HELP PANEL ADBH5LE MISSING FOR TARG OBJ
PK71592
10_Feb
2009
UK43898


DB2 ADMIN USING ALC WITH BATCH IN JES3 RESULTS IN DATASET NOT FOUND IAT4404 MESSAGE.
PK72573
10_Feb
2009
UK43898


GOC2CMP - ERROR(S) FOUND RESULT IN RC=8 OR RC=0 MERGE REPORT NOT TRIGGERED FROM STEP T03COMP
PK74324
20_Jan
2009
UK43339
PM07573

PA COMMAND DOES NOT SHOW TYPE X ROWS FROM SYSIBM.SYSPARM ON PANEL ADB21OP ROUTINE PARAMETERS
PK72449
20_Jan
2009
UK43339
PM07573

DB2 9 CATALOG NAVIGATION ALL ADB21* PANELS NFDB29
PK57553
20_Jan
2009
UK43339
PM07573

DB2 9 DEBUGSESSION SUPPORT IN THE DB2 ADMINISTRATION TOOL
PK67196
15_Jan
2009
UK43240


AL/RDEF MISSING SECQTY WHEN OBJECT CREATED BEFORE DB2 R510
PK75901
15_Jan
2009
UK43240


WSLSIZE ON/OFF OPTION TO CONTROL THE SIZE COLUMN ON PANEL ADB2W1
PK76071
15_Jan
2009
UK43240


PANEL ADB2C11A "GENERATE ANALYZE JOB" SHOWS "RUN REORG" NOT "RUNREORG/REBUILD"
PK76116
15_Jan
2009
UK43239


COMPARE ABEND0C4 S0C4 IN ADBCVOB ADB2MSK
PK76118
15_Jan
2009
UK43239


PANEL ADB2CMRG MSG DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL DURING SECOND CHANGE LOOK-UP
PK76268
15_Jan
2009
UK43239


ADB3014E ERROR PROCESSING VIEW AAA.AAA IN CREATE STATEMENT: EITHER COLUMN HEX DOES NOT EXIST MSG ISSUED FOR HEX FUNCTION
PK77274
15_Jan
2009
UK43239


DB2 ADMIN ONCODE 350 ADB27AC UNEXPECTED EOF LOAD CNTL C001.
PK75534
15_Jan
2009
UK43239


MSGISPF105 OUTPUT OVERFLOW FROM ADB27A LINE 2233 FTINCL ADB27TL
PK76957
15_Jan
2009
UK43239


PANEL ADB21XI1 "CLUSTERING RATIO" ALWAYS BLANK
PK64855
15_Jan
2009
UK43240


MSG ' INVALID BUFFER POOL ' IN PANEL ADB21SA
PK66668
15_Jan
2009
UK43239


MERGE TO AVOID FR RECORDS BEING WRITTEN OUT WHEN COMPARE IS DONEAT TABLE LEVEL WITH REFERENCES CLAUSE (FK) CONTAINING NO
COLUMN
PK68035
15_Jan
2009
UK43239


SQLCODEN206 AS MIXED CASE COLUMNS NOT ENCLOSED IN QUOTES PANELS ADB21TSE,ADB21TIN,ADB21TUP AND ADB21TDE
PK71058
15_Jan
2009
UK43239


DB2 ADMIN LISTDEF TOO MANY DELETES ENTERED OR INSERTS FROM PANEL ADB25LE.
PK71774
15_Jan
2009
UK43239


DB2 9 ALTER INDEX BP DOES NOT ALLOW > 4K ACTIVATED PAGE NFDB29
PK72872
15_Jan
2009
UK43239


GEN OF SYSIBM.SYSRELS DOES NOT INCLUDE INDEX FOR PRIMARY KEY
PK70457
16_Dec
2008
UK42530


CM WSLVAL MESSAGE ADB3014E ERROR PROCESSING VIEW <NAME> IN CREATE STATEMENT: EITHER COLUMN <NAME> DOES NOT EXIST IN THE
PK72504
16_Dec
2008
UK42530


CM WSLVAL MESSAGE ADB3014E ERROR PROCESSING VIEW IN CREATE STATEMENT: EITHER COLUMN DOES NOT EXIST IN THE TAB(VIEW ON
VIEW
PK60445
16_Dec
2008
UK42530


PANEL ADB233 'INDEXES WITH CLUSTERING LEVEL PROBLEM' REORG OPTION SUGS TABLE SPACE REORG BUT COMMAND BUILDS INDEX SPACE REORG
PK33657
15_Dec
2008
UK42504
PK83736

PANEL ADB2MEX 'DB2 INDEX SPACE ESTIMATOR' GIVES INCORRECT RESULTS FOR NON-UNIQUE PARTITIONING INDEX
PK62626
15_Dec
2008
UK42504
PK83736

BUFFER POOL VDWQT OPTION NOT FULLY SUPPORTED IN PANEL ADB2ZBA8 AND ADB2ZBA2
PK75429
15_Dec
2008
UK42504
PK83736

DB2 ADMIN ADD DIAGNOSTICS CAPABILITY FOR AUTH-SWITCHING FUNCTION
PK74418
15_Dec
2008
UK42504
PK83736

PANEL ADB21P COMMAND LINE BIND COMMAND DOES NOT INCLUDE MEMBER AND LIB KEYWORD FOR PLANS BOUND WITH BOTH PKLIST AND MEMBER
PK75048
15_Dec
2008
UK42505


NEW FUNCTION FOR PERFORMING CHECK UTILITY PROCESSING
PK75066
15_Dec
2008
UK42506


NEW FUNCTION FOR DISPLAYING NATIVE STORED PROCEDURE INFORMATION
PK68569
15_Dec
2008
UK42504
PK83736

FILTERING NOT WORKING FROM Z:2U (PANEL ADB2Z2U2)
PK70013
15_Dec
2008
UK42507
PK81961

ADMIN LOB SUPPORT
PK72148
15_Dec
2008
UK42507
PK81961

PANEL ADB2Z2U2 DISPLAYS THE INCORRECT VALUE FOR COUNT
PK72951
15_Dec
2008
UK42504
PK83736

PANEL ADB2ZLZ CHKTIME PARM CHECKPOINT FREQ SET LOG
PK73034
15_Dec
2008
UK42504
PK83736

ADB26CT "CREATE TABLE" "AS MODEL" "YES" DEFAULT VALUES DOES NOT CORRECTLY INCLUDE DEFAULT SYNTAX
PK52679
15_Dec
2008
UK42504
PK83736

SM FUNCTION PANEL ADB2M1SI 'PAGE SET INFORMATION' SHOWS INCORRECT ALTER DATE
PK54687
15_Dec
2008
UK42510


PANEL ADB2Z2Z 'SYSTEM PARAMETERS' ISSUES MESSAGE 'THIS FUNCTION DOES NOT SUPPORT DB2 RELEASE 910' ON DB2 9 FOR OPTION 1
PK55377
15_Dec
2008
UK42504
PK83736

DISPLAY THREAD CMD CAUSES 00E60800 RC=4 RETURN AREA IS TOO SMALLDB2 IFI WARNING RETURN CODE= 4 REASON CODE=00E60800
PK66568
13_Nov
2008
UK41563


WSL CLONE APPENDS QUOTATION MARKS TO LOWERCASE COLUMNS RESULTING IN SQLCODEN206 IS NOT A COLUMN OF AN INSERTED TABLE
PK49528
13_Nov
2008
UK41563


GEN TRIGGER SYNTAX ISSUE SELECT STATEMENT QUALIFIER IDENTIFIES INSERT TABLE NOT THE FROM TABLE
PK73760
13_Nov
2008
UK41563


VALIDATE WSL DOES NOT ISSUE A MESSAGE WARNING THAT THE DATABASE REFERENCED IN A CREATE TABLESPACE DOES NOT EXIST.
PK73941
13_Nov
2008
UK41563


DB2 CONTROL CENTER USERS OF STORED PROCEDURE ADB.ADB2RE SQLCODEN805 DBRM OR PACKAGE NAMEADBL.ADB2RS NOT FOUND
PK74376
13_Nov
2008
UK41563


DB2 ADMIN PANEL ADB2CMRG MSG DSNT408I SQLCODE = -104 WHEN USING CHANGE NAME LOOKUP FOR AN IMMEDIATE CHANGE.
PK71591
13_Nov
2008
UK41563


DB2 ADMIN LISTDEF PANEL ADB25L EDIT THEN PF3 RENTER LISTDEF PANEL ADB2PSTM DISPLAYED AND THEN CANCEL DOESN'T WORK.
PK72539
13_Nov
2008
UK41563


DB2 ADMIN OC USING COMPRESS MASK TYPE MAY RESULT IN U4038 AND ONCODE 520.
PK72560
13_Nov
2008
UK41563


IMPORT CHANGES REGISTER ERROR RC=20 INVALID TOKEN IN COLUMN LISTWITH THE 'TOKEN=' SHOWING BLANK
PK72647
13_Nov
2008
UK41563


IMPORT RC20 CHANGES FILE HAS ALTER ALTER INDEX FOLLOWED BY ALTER ADD COLUMN THE ALTER ADD COLUMN
PK72740
13_Nov
2008
UK41563


SP COMMAND DOES NOT PROVIDE SECQTY ON PANEL ADB21SP
PK73792
13_Nov
2008
UK41563


PANEL ADB2RQ ATTEMPTS TO REVOKE PRIVILEGES FROM A USER WHEN A SPACE IS ENTERED INTO THE INPUT FIELD
PK38140
3_Nov
2008
UK41295


AL INDEX PANEL ADB21XA 'ALTER INDEX' DOES NOT CARRY PRIQTY OR SECQTY THROUGH TO THE ALTER WHEN MOVING FROM VCAT TO STOGROUP
DEF
PK65091
3_Nov
2008
UK41293


REVOKE IMPACT REPORT ADB2RIP DOES NOT REFLECT IMPACT OF REVOKE.
PK71767
3_Nov
2008
UK41293


ADMIN GENERATES INCORRECT FULLKEYCARDATA COLUMN DATA FOR DPSI OBJECT
PK65104
3_Nov
2008
UK41295


EXPLAIN FUNCTION ENHANCEMENT TO ACCOMMODATE DUPLICATE SQL STMTNO PRODUCED BY PL/1 SQL COPROCESSOR
PK67717
3_Nov
2008
UK41295


ALC PRIMKEY ALTER ADD COLUMN RESULTS IN SQLCODE -625/SQLCODEN625
PK68869
3_Nov
2008
UK41295


MESSAGE INVALID COMMAND FOR LINE COMMAND ? ON PANEL ADB21TC SO CUSTOMERS UNAWARE THAT AUX AND REM ARE AVAILABLE.
PK70724
3_Nov
2008
UK41293


FOR DB2 V9 CHECK INDEX WORKDDN WILL ONLY ACCEPT 1 WORKDDN
PK71291
3_Nov
2008
UK41295


ADB21TAV DOES NOT DISPLAY LKEYS HEX VALUE CORRECTLY
PK71448
3_Nov
2008
UK41293


PANEL ADB21TAB GENERATED SQL DOES NOT USE TBCREATOR AS A PREDICATE
PK71799
3_Nov
2008
UK41293


IN DATA SHARING ENVIRONMENT, WHEN ALTERING INDEX BUFFERPOOL, OPTION 4 TO CANCEL DOES NOT WORK
PK71814
3_Nov
2008
UK41293


OPTION 3:14 TO CHECK TABLESPACE MAINTENANCE RECOMMENDATIONS RESULT IN SQLCODEN802 FOR HUGE TABLESPACESTATS VALUES
PK71992
3_Nov
2008
UK41293


MSG ' INVALID ACTION CODE ' IN PANEL ADBDMTI WHEN USING / FOR LINE COMMAND IN PANEL ADBDMTT
PK72150
3_Nov
2008
UK41293


PANEL ADB25TD GENERATES ERROR UNRECOGNIZED VARIABLE FOR WORKLISTTEMPLATE
PK72723
3_Nov
2008
UK41293


GEN USES CREATEDBY FIELD AS THE SQLID WHEN PARSING RESULTING IN UNFORMATTED MQT DDL.
PK73038
3_Nov
2008
UK41293


WSL R LINE COMMAND WHEN TSO PROFILE HAS NOPREF RESULTS IN JCL ERROR IEFC624I INCORRECT USE OF PERIOD IN THE DSN FIELDSYSPRINT
PK73080
3_Nov
2008
UK41293


PANEL ADB2W1 "WORK STATEMENT LIST LIBRARY:" ISSUES A MESSAGE " NO ROWS MATCH" AFTER RACF ICH408I INSUFFICIENT ACCESS
AUTHORITY
PK73198
3_Nov
2008
UK41295


ADMIN 720 RESTRICT THE USE OF CLONED TABLE, XML, HIDDEN COLUMN FOR DB2 V9 NFDB29
PK73516
3_Nov
2008
UK41295


ALC INSERTING COLUMN IN UNICODE TABLE LOSES ATTRIBUTES AND ALTERS DATA
PK62258
3_Nov
2008
UK41295


ALC ON TABLE WITH CCSID UNICODE AND DEFAULT FOR SBCS DATA USING WSL MISSING DEFAULTS WHICH RESULTS IN FOR MIXED DATA
PK58092
10_Oct
2008
UK40642


JES3 ISSUE IAT4404 DATASET NOT FOUND ON MAIN PROCESSOR WHEN RDEF AND TEMPLATES USED FOR UNLOAD SYSPUNCH
PK64432
8_Oct
2008
UK40537


MESSAGE "INVALID NAME" ISSUED ON PANEL ADB27A "DB2 ADMIN ALTER" WHEN "ADD TO WORK STMT LIST" YES SPECIFIED
PK65511
8_Oct
2008
UK40537


ADMIN CHANGE MANAGEMENT IMPORT RC=20 ADB3003E
PK66033
8_Oct
2008
UK40537


OBJECT COMPARE, GOC2CMP, GENERATES INCORRECT OUTPUT ON UNICODE
PK66553
8_Oct
2008
UK40537


GEN/DDL MISSING NOT PADDED FOR PRE DB2 R810 CREATED INDEX WITH VARCHAR COLUMN
PK67081
8_Oct
2008
UK40537


MSG SQL DD STATEMENT MISSING AND GENERATE DDL AND/OR GENERATE STATS REQUESTED ADB1192I ADB2GEN - NOW TERMINATING
PK68462
8_Oct
2008
UK40537


DB2 ADMIN MIGRATE PERFORMANCE ENHANCEMENTS
PK69018
8_Oct
2008
UK40537


DB2 OBJECT COMPARE DDL SOURCE OR TARGET INPUT DOES NOT USE THE CCSID DEFAULT VALUE
PK70483
8_Oct
2008
UK40537


VARIOUS LINKEDIT ERRORS WHEN ADMIN PTFS ARE APPLIED WITHOUT REQUIRED OBJECT COMPARE PTFS WHEN JCLIN CHANGES
PK70536
8_Oct
2008
UK40537


WSLVAL ADB3009E ERROR PROCESSING INDEX <NAME> IN CREATE STATEMENT NUMBER OF INDEX PARTITIONS DOES NOT MATCH TABLE
PK71064
8_Oct
2008
UK40537


ADMIN MULTIPLE INPUT DELTA CHANGE FILES INTO A SINGLE CHANGE FOR CHANGE MANAGEMENT
PK51390
8_Oct
2008
UK40537


OVERWRITE FUNCTIONALITY TO INCLUDE PRIQTY/SECQTY
PK57822
8_Oct
2008
UK40537


MODIFY GEN DEFAULT SHOULD BE =N FROM CURRENT Y
PK57940
8_Oct
2008
UK40537


//CAT DDNAME SPACE=(TRK,(15,15),RLSE) RESULTS IN ABENDSX37
PK61724
8_Oct
2008
UK40537


GEN/DDL OF STORED PROCEDURE MISSING VARCHAR STRUCTURE/NULTERM SYNTAX
PK62937
8_Oct
2008
UK40537


GEN WITH MASK IN TSO MODE SPECIFYING A DATASET NAME RESULTS IN AN EMPTY DATASET
PK68932
7_Oct
2008
UK40536
PK97797

AL COMMAND AGAINST STORED PROCEDURES CAUSES EXTERNAL NAME TO BE FOLDED TO UPPER CASE
PK69934
7_Oct
2008
UK40536
PK97797

ALC ALTPART DOES NOT GIVE WARNING MESSAGE THAT THE ORDER OF THE PARTITIONING KEYS IS INVALID, JUST RETURNS YOU TO PANEL
ADB27C
PK70153
7_Oct
2008
UK40536
PK97797

ALTER GENERATES MSG ADBC197E CHECK CONDITION NOT VALID AFTER DATATYPE CHANGE
PK70386
7_Oct
2008
UK40536
PK97797

CATALOG COPY - DDL COMMAND DOES NOT REFERENCE CC VERSION USES THE ACTUAL DB2 CATALOG
PK70636
7_Oct
2008
UK40536
PK97797

ADMIN 720 ENHANCEMENTS TO ALLOW A DIFFERENT USERID TO RESTART A CHANGE OR WORK STATEMENT LIST (WSL).
PK70643
7_Oct
2008
UK40536
PK97797

XML PRE-CONDITIONING
PK70800
7_Oct
2008
UK40536
PK97797

ADB2USM MODIFY UTILITY BUILDS INCORRECT SYNTAX FOR AGE OR DATE
PK71430
7_Oct
2008
UK40536
PK97797

MSGIEW2456E SYMBOL ADB2PA6 UNRESOLVED .MSGGIM23911E LINK-EDIT PROCESSING FOR SYSMOD UK38008 FAILED . RC08
PK72209
7_Oct
2008
UK40536
PK97797

APAR PK54318 DID NOT INCLUDE ++HOLD INSTRUCTIONS FOR THE ADBSCH TABLESPACE CHANGES
PK59968
7_Oct
2008
UK40536
PK97797

AL/RDEF PANEL ADB21SAR DOES NOT PROVIDE OPTIONS TO CHANGE TO A TABLE-BASED PARTITIONING SCHEME
PK63120
7_Oct
2008
UK40536
PK97797

PANEL ADB2C11A RESTRICTS PREFIX FOR DATA SETS INPUT TO 8 CHARACTERS
PK63201
7_Oct
2008
UK40536
PK97797

TEMPLATES WORKDDN1 & WORKDDN2 NOT USED IN UNLOAD/LOAD UTILITY.
PK58542
26_Sep
2008
UK40229


ALC JOBS USING HPU VIA WSL RESULTS IN RC=303
PK65041
26_Sep
2008
UK40229


OBJECT COMPARE GENERATING ABEND U4038 FOR APPLY RUN ONLINE
PK66926
26_Sep
2008
UK40229


ERRONEOUS PRIMARY INDEX REQUIRED MESSAGE ON PANEL ADB27CR "ALTERRELATED :"
PK67894
26_Sep
2008
UK40229


ADB2W1 UNINITIALIZED VARIABLE ERROR GENERATED ISSUING S ON WSL
PK68686
26_Sep
2008
UK40229


ALC WITH NO CHANGE MANAGEMENT ALTER INSERT COLUMN RESULTS IN MESSAGE "PROCESSING ERROR" PANEL ADB27CTC "ALTER TABLE"
PK68935
26_Sep
2008
UK40229


WSL CONTENTION CHECKEND REBIND OPEN C_DEP ADBTEP2 SQLCODEN911 REASON 00C90088 NAME DSNDB06 SYSDBASE
PK70254
26_Sep
2008
UK40229


PRE-ALLOCATED ISPLOG IN LOGON PROC AND GENERATE ONLINE = YES IN OBJECT COMPARISON RESULT IN RC=12
PK70542
26_Sep
2008
UK40229


RESTART OF CHECK UTILITY WITH PARENT OBJECT NOT IN CHKP STATE DOES NOT FIND DEPENDENTS IN CHKP STATE
PK67071
25_Sep
2008
UK40220


REBIND OF PACKAGE WITH LONG VERSION NAME RESULTS IN MESSAGE "INVALID KEYWORD, )" PANEL ADB2CB "COMMAND OUTPUT DISPLAY"
PK69072
25_Sep
2008
UK40220


PANEL ADB2RIP DOES NOT REFLECT ALL VALID REVOKE INFORMATION WHENREPORT REVOKE IMPACTS IS SPECIFIED.
PK64785
25_Sep
2008
UK40220


INTERNAL DEBUG DD INCLUDED IN ERROR ADBDIAG
PK67136
25_Sep
2008
UK40220


DB2 ADMIN PARSER ERROR WHEN DECIMAL POINT IS COMMA RC=16 FOR DECIMAL = '.'
PK70919
25_Sep
2008
UK40220


PANEL ADB21KI1 INTERPRETATION OF AN OBJECT IN SYSPACKAGE DOES NOT SHOW DB2 9 RELBOUND FLAG "M" NFDB29
PK59317
25_Sep
2008
UK40220


PANEL ADB2M1SI 'PAGE SET INFORMATION' SHOWS -4 FOR PRIQTY / SECQTY IN ERROR.
PK62768
25_Sep
2008
UK40220


UNLOAD SYSREC DATASET GENERATES VERY LARGE PRIMARY QUANTITY IN THE SPACE PARM
PK65271
24_Sep
2008
UK40162


PANEL ADB2USU "SPECIFY UTILITY OPTIONS - UNLOAD" DOES NOT PROVIDE SUPPORT FOR THE DELIMITED COLDEL / DELIMITED CHARDEL
PK67748
24_Sep
2008
UK40162


DB2 ADMIN OC DDL TO DDL COMPARE USING COMPRESSED DATA SETS IEC143I 213-C8, GEN FOR OC CATALOG EXTRACT.
PK70896
27_Aug
2008
UK38969


DB2 ADMIN CREATE TRIGGER PARSER ERROR , GEN ON VIEW UNEXPECTED PANEL WITH RED ****
PK63460
15_Aug
2008
UK38992


ALC COLUMN DEC TO DEC AND INCREASING SCALE USES DROP/CREATE INSTAED OF ALTER.
PK64132
15_Aug
2008
UK38992


ADB27A, LINE 2226: FTINCL ADB2USR ISPF107 CONTROL WORD ERROR INVALID CONTROL WORD PARAMETER, ADB2USRO RECORD-67.
PK65343
15_Aug
2008
UK38992


ALC ALTER ADD COLUMN DEFAULT NULL RESULTS IN STRING 'NULL' OR MESSAGE 'DEFAULT VALUE TOO LONG' ON PANEL ADB26CTU
PK65788
15_Aug
2008
UK38992


ADMIN PRODUCE A LOAD SUMMARY REPORT AT THE END OF THE WSL RUN
PK66782
15_Aug
2008
UK38992


ALC LABEL ON VIEW MISSING AFTER DROP OF TABLE.
PK68124
15_Aug
2008
UK38992


CM ADBC002E ANALYZE MERGE NO OBJECT
PK69579
15_Aug
2008
UK39000


AUTH SWITCHING FAILS WITH SQLCODEN551
PK59593
15_Aug
2008
UK38992


USING MIG WITH VIEW CREATED WITH AN ALIAS CREATES THE VIEW WITH THE SAME TBOWNER AS THE ALIAS INSTEAD 08/04/15 PTF
PEREMOVE
PK60893
15_Aug
2008
UK38992


ADMIN ALC CHAR TO NUMERIC CONVERSION ISSUES
PK61494
15_Aug
2008
UK38992


ALTER OF IDENTITY COLUMN FROM NO CACHE TO CACHE 20 RESULTS IN DROP AND RECREATE IN CM RUN
PK61788
15_Aug
2008
UK38992


ALC DATATYPE TO TIME W/CM, LVARCHAR DATA DIDN'T GET TRUNCATED LONGVAR DATA WAS CONVERTED TO TIME INCORRECTLY
PK62429
15_Aug
2008
UK38992


OBJECT COMPARISON OF HUGE DDL RESULTS IN GOC2CMP ERROR(S) FOUND.ERROR OCCURED WHEN PARSING THE FOLLOWING STMT
PK59419
14_Aug
2008
UK38969


DB2 ADMIN -DIS COMMAND WITH CATALOG COPY AND DDF CONNECT NOT WORKING
PK65703
14_Aug
2008
UK38969


ALC ADDPART DOES NOT WARN THAT ALTER WILL RESULT IN SQLCODEN4701PARTITIONING LIMIT KEY EXCEEDS THE SYSTEM LIMIT
PK66150
14_Aug
2008
UK38969


DB2 ADMIN CREATE TRIGGER PARSER ERROR , GEN ON VIEW UNEXPECTED PANEL WITH RED ****
PK67665
14_Aug
2008
UK38969


MISSING PANEL ADB2CONF WHEN EXISTING CLUSTERING INDEX EXISTS WHEN USING THE CRE COMMAND FROM PANEL ADB21X
PK68593
14_Aug
2008
UK38969


DB2 ADMIN 720 ADB3001E ERROR PROCESSING TRIGGER OWNER.NAME IN COMMENT STATEMENT: OBJECT DOES NOT EXIST.
PK51522
14_Aug
2008
UK38969


GEN OUTPUT FORMATTING OF MQT
PK61235
14_Aug
2008
UK38969


PERFORMANCE QUERY #9 (INDICES NOT USED BY ANY PLANS OR PACKAGE) QUERY IS INVALID
PK66944
10_Jul
2008
UK38008


DB2 ADMIN IMPROVEMENTS TO RESTART OF RUN PHASE IN CHANGE MANAGEMENT.
PK67928
10_Jul
2008
UK38008


DB2 ADMIN WSL ADBTEP2 -502, CURSOR IDENTIFIED IN AN OPEN.
PK66406
9_Jul
2008
UK38008


MIG ADB28M SPECIFYING DDL=NO GENERATES DDL DATASET OR DDL IN WSL
PK66594
9_Jul
2008
UK37994


ADMIN WSL PANEL ADB2W1 GIVES INCORRECT SIZE VALUE FOR CLONED WSL
PK63320
9_Jul
2008
UK37994


INFO ON ICS FOR PAGES IN TS, CHANGED PAGES, JOB NAME AND AUTHORIZATION ID MISSING IN DB LEVEL BUT NOT TS LEVEL
PK64428
9_Jul
2008
UK37994


ADMIN REQUIRED DD CARD OR TEMPLATE IS MISSING NAME=STPRIN01
PK64854
9_Jul
2008
UK37994


PANEL ADB21TXC "INDEXES AND COLUMNS OF AAA.AAA" AND HELP PANEL ADBH1TXC "DB2 INDEXES AND COLUMNS" COLUMN "F" NO
EXPLAINATION.
PK65156
9_Jul
2008
UK38008


PRINT TABLE ON DISPLAYS INVALID CHARACTERS, ISPF DIALOG ERROR
PK65392
9_Jul
2008
UK38008


CHECK TERMINAL CODE-PAGE AGAINST ADMIN TOOL PLAN CCSID
PK65464
9_Jul
2008
UK38008


ADB2RCP COMMANDS TO DISTRIBUTED SUBSYSTEM GAVE INCONSISTENT RESULTS AS LINKED WITH CAF (DSNALI) INSTEAD OF RRSAF(DSNRLI)
PK65451
9_Jul
2008
UK38008


ENHANCEMENT TO THE AUTHORIZATION SWITCHING FUNCTION TO ALLOW RUNNING MODIFIED OR USER-PROVIDED DDL.
PK65841
9_Jul
2008
UK37994


ADB2CID - IMPORT CHANGES SQL STMT NOT COMPLETELY PARSED REGISTER ERROR. RC=20 CAUSED BY MISSING SEMICOLON ON COMMENT
PK66135
9_Jul
2008
UK37994


FOLLOW ON TO APAR PK63054 PANEL ADB25TU3 COMMENT FIELD NOT UPDATED WHEN CHANGED
PK53657
9_Jul
2008
UK37994


ADMIN MISSING HELP PANEL ADBH1TAU
PK60598
9_Jul
2008
UK38008


NEW FUNCTION CHANGES TO THE MAXE COMMAND - SUPPORT FOR STOPPING ON FAILING DB2 COMMAND BUT NOT FAILING BIND COMMAND
PK62511
9_Jul
2008
UK37994


REN FUNCTION REQUIRES CM TO BE FUNCTIONING IE. EITHER AT DEFAULTSYSTEM LEVEL OR AS OPTIONAL FOR USERID LEVEL
PK62701
9_Jul
2008
UK37994


CHANGE MANAGEMENT DELETE FUNCTION REQUIRES PLAN TO BE CALLED ADB
PK63548
9_Jul
2008
UK37994


ADMIN UTILITIES REORG STEP USING LISTDEF OPTION U.O, RC8 MISSINGSYSCOPY
PK63735
9_Jul
2008
UK37994


WHEN USING TAPE FOR IC, BR COMMAND ON PANEL ADB21I STATES INVALID COMMAND MESSAGE
PK63857
9_Jul
2008
UK37994


FIXES IN THE FOLLOWING FUNCTIONAL AREAS: 1. ALTER TABLE 2. RENAME DATABASE
PK66531
13_Jun
2008
UK37341


PLAN_TABLE CREATED FOR DB2V8 COMPAT MODE CONTAINS 51 COLUMNS INSTEAD OF 58
PK65762
30_May
2008
UK36967


GEN/DDL COMMAND RESULTS IN INCORRECT DDL WHEN EXECUTED ON DB2 9 RUNNING IN COMPATABILITY MODE
PK66211
30_May
2008
UK36963


DB2 ADMIN PARSING ERROR WHEN CREATE VIEW AND INSERT INTO TABLE WHERE THERE IS NO COLUMN LIST.
PK64669
15_May
2008
UK36514


DB2 ADMIN 720 WSL VALIDATE FAILING ON INDEX COL NAME MATCHING TABLE COL NAME
PK62500
15_May
2008
UK36514


CM ALTER OF TABLE COLUMN DEFINITION FROM NOT NULL TO NULL RESULTS IN NO CHANGES MADE TO TABLE
PK63116
15_May
2008
UK36514


CM ANALYZE CHANGES PIECESIZE FROM 4M TO 4K OR 8M TO 8K MAKING IT INVALID
PK64238
14_May
2008
UK36514


RECEIVING ONCODE350 STRINGRANGE CONDITION RAISED IN GOC2CMR AT ENTRY POINT ADD_OBJECT AT STATEMENT 2080
PK33202
14_May
2008
UK36514


IBM INTERNAL ADD MSG WHEN PARTS > 254 AND TS COMPRESS
PK59060
14_May
2008
UK36514


PANEL ADB2ICI1 GIVES WRONG INFORMATION FOR COLUMNS FOR TABLES CREATED PRIOR TO DB2V8
PK59061
14_May
2008
UK36514


ADMIN UTIL REORG DEFAULTS OPTIONS CAUSE RC=08 DSNU076I DSNURFIT MESSAGES FOR LOB TABLESPACES KEYWORD='LOG NO' INVALID
PK60194
14_May
2008
UK36514


INDEX DROP IS PERFORMED ON A CLUSTERING INDEX WHICH ENFORCES A PRIMARY KEY CONSTRAINT RESULTING IN -669
PK60697
14_May
2008
UK36514


NOT ALL LINE COMMANDS ON ADB21TN WORK ON ALL CONSTRAINT TYPES.
PK64118
14_May
2008
UK36478


GOC5 VAL, THEN ADB2CMRO=YES FOR CM IS ACCEPTED (Y IS NOT)
PK64191
14_May
2008
UK36514


MSGCEE3608I MSGCEE3611I ONCODE350 STRINGRANGE CONDITION FROM COMPILE UNIT ADBCCMM AT ENTRY POINT SORTD_IN
PK64222
14_May
2008
UK36514


OC LOAD STEP FAILS MSGDSNU1036I DSNURELD - UNABLE TO ESTIMATE SPACE REQUIREMENTS FOR WORKDDN
PK54046
14_May
2008
UK36514


ADMIN ALC USING CM GIVES RC08 STEP MERGE3 ERROR CHANGE FOUND FORTABLESPACE DSNDB04.ADRESSE BUT NO BASE DEFINITION WAS FOUND
PK55036
14_May
2008
UK36478


MODIFY UTILITY VIA A LISTDEF BUILDS INVALID SYNTAX (MISSING AGE/DATE) MESSAGE DSNU071I MAY BE ONE OF THE REPORTED
MESSAGES
PK59647
14_May
2008
UK36514


NEW FUNCTION
PK60784
14_May
2008
UK36478


WHEN CREATING A STORED PROCEDURE AND USING A MODEL THAT USES A RESULT SET > 0, PARM IS OMITTED
PK61079
14_May
2008
UK36514


ADB2W1 EXEC MSG INVALID DATA SET NAME DURING RUN WSL LINE COMMAND.
PK62075
14_May
2008
UK36514


CM ANALYZE B37 EXDLTA VEROUT DD HARDCODED
PK62240
14_May
2008
UK36478


MIGRATE LOAD STEP DOES NOT RECOGNIZE MULTI VOLUME TAPE
PK62265
14_May
2008
UK36514


ALC LOAD STEP FAILS RC=08 DSNU1015I DSNUGDYN ERROR ALLOCATING DATA SET FOR THE ULD.TNNN DATASET IKJ56228I
PK62318
14_May
2008
UK36514


ADB2GEN ABEND S80A CEE0813S INSUFFICIENT STORAGE
PK62741
14_May
2008
UK36478


PANEL ADB21TUP "BUILD SQL UPDATE PROTOTYPE" FOLDS INPUT TO UPPERCASE. PANELS ADB21TDE AND ADB21TIN INCLUDED IN APAR.
PK62771
14_May
2008
UK36514


CHANGE MANAGEMENT DOES NOT COMPLETELY SUPPORT ROTATE PARTITION
PK62821
14_May
2008
UK36478


PANEL ADB26CUU 'CREATE TABLE COLUMN NUMBER' FOLDS LOWERCASE VALUES SPECIFIED IN FIELD 'DEF. VALUE' TO UPPERCASE
PK62827
14_May
2008
UK36514


WHEN DATATYPE CHANGES, SET STATEMENT IS ENCLOSED IN QUOTES WHICH RESULTS IN CHANGE IN DATATYPE TO DISTINCT
PK63054
14_May
2008
UK36478


RENAMED TEMPLATE NOT REFLECTED IN PANEL ADB25TU3
PK63262
14_May
2008
UK36514


ADMIN ADBCVOB FAILS TO EXTRACT UDF BY ITS SPECIFIC FUNCTION NAME.
PK63625
14_May
2008
UK36514


ADMIN GEN STORAGE REDUCTION CHANGES TO HELP AVOID OUT OF STORAGECONDITIONS.
PK63671
14_May
2008
UK36514


VALIDATION REPORTS INCORRECTLY CLUSTERING INDEX. (THIS IS ADMIN COMPANION APAR FOR OC APAR PK60531.)
PK63856
14_May
2008
UK36514


ADD MIG OPTION TO CONTROL CREATING OF GRANT STATEMENTS
PK64033
14_May
2008
UK36514


ADBCCME ERROR, WHEN CM ENABLED AND COLUMN REPEATED AND ORIGINAL COLUMN DELETED WITHOUT ANY CHANGES IN COLUMN
PK38611
9_Apr
2008
UK35295


PANEL ADB21 PRODUCES MESSAGE ' NO ROWS FOUND '
PK48678
9_Apr
2008
UK35295


ALC ROWID LOAD FAILS RC=08 DSNU309I DSNUROFL NOT ALL REQUIRED UNIQUE INDEXES HAVE BEEN DEFINED GENERATED BY DEFAULT
PK53134
9_Apr
2008
UK35295


ALC NEW FUNCTION - RETAIN THE CONSTRAINT NAME WHEN CHANGING OBJECT
PK53985
9_Apr
2008
UK35295


PANEL ADB26CTU GIVES MSG ' TOO LARGE FOR PAGE SIZE ' FOR VARCHAR DATA LENGTH > 4096
PK56059
9_Apr
2008
UK35295


ALC ALTPART RESULTS IN SQLCODEN636 THE PARTITIONING KEYS FOR PARTITION N ARE NOT SPECIFIED IN ASCENDING OR DESCENDING
ORDER
PK56957
9_Apr
2008
UK35295


PANEL ADB21TSE 'BUILD SQL SELECT PROTOTYPE' DOES NOT SUPPORT LOWERCASE VARIABLES & INSERT MISSING )
PK57924
9_Apr
2008
UK35295


ALTPART IN PANEL ADB27C FAILS IN PANEL ADB2CRO WITH MSGADBC030E REGISTER FAILED REASON CODE = , REASON:
PK58110
9_Apr
2008
UK35295


AN MERGE REPORT ENDS RC=08 CHANGE FOUND FOR ALIAS AAA.AAA BUT NO BASE DEFINITION WAS FOUND
PK52352
8_Apr
2008
UK35295


RENAME INFORMATION NOT REPORTED IN OBJECT COMPARISON REPORT WHEN TRANSLATION MASK = Y
PK57147
8_Apr
2008
UK35295


CONCAT OPERATOR IN TRIGGER RESULTS IN DIAGNOSTIC TEXT IN SIGNAL SQLSTATE NOT RECOGNIZED.
PK57012
8_Apr
2008
UK35295


CM PANEL ADB2C2L 'CM - MASK LINES' DOES NOT VALIDATE THE INPUT FIELD 'TYPE'
PK06230
5_Apr
2008
UK35295


INTERNAL APAR, FOR SPLIT SCREEN PROBLEMS
PK39735
5_Apr
2008
UK35295


AFTER EXITING ADMIN TOOL WHILE USING CATALOG COPY, AND UPON RE-ENTRY, SOMETIMES PRIOR CATALOG COPY IS SEEN
PK41452
5_Apr
2008
UK35295


ALC COMMAND LABEL AND COMMENT ON COLUMN RESULTS IN ADDITIONAL ALTER ON COLUMN ATTRIBUTES INCLUDING SET DATA TYPE AND DROP
TABLE
PK55875
5_Apr
2008
UK35295


DB2 ERROR ADBTEP2 -104 DURING WSL MIGRATE
PK56189
5_Apr
2008
UK35295


CC OR GEN OF SYSIBM SYSJARDAT RC=4 THE DEFINITION OF TABLE SYSIBM.SYSJARDATA IS NOT COMPLETE IN DB2 TABLE WILL BE
SKIPPED
PK56285
5_Apr
2008
UK35295


ABEND0C8 IN ADB27AC ROUTINE CONVERT_UNLOAD SECONDARY SYMPTOM ONCODE340 SIZE CONDITION
PK56652
5_Apr
2008
UK35295


ALC CHANGE OF COLUMN FROM DECIMAL (3,0) TO (11,7) INCORRECTLY CHANGES DATA WITH INCORRECT PRECISION
PK57311
5_Apr
2008
UK35295


INVALID SYNTAX FOR INDEX DEFINED WITH LIMIT KEY MAXVALUE KEYWORDWHEN GEN OR DDL COMMAND USED.
PK58480
5_Apr
2008
UK35295


PANEL ADB221E "EDIT SQL STATEMENT" TRUNCATES DATA
PK58491
5_Apr
2008
UK35295


GEN TABLE FIELDPROC RESULTS IN IBM0361W ONCODE=350 THE STRINGRANGE CONDITION WAS RAISED.
PK61017
5_Apr
2008
UK35295


ADMIN ADB2WVL ABEND4038 ONCODE=520 DURING WSL VALIDATE
PK50865
5_Apr
2008
UK35295


ANALYZE FAILS ON STEP MERGE3 WITH UNABLE TO LOCATE ROW TO UPDATEWHEN ALTERING TABLE
PK56969
5_Apr
2008
UK35295


CM NO REBIND WHEN ADDING INDEX
PK57169
5_Apr
2008
UK35295


ABENDU4091 RC0B ADB28MC IN STEP CNVRT DURING CONVERSION OF LOAD TABLE STATEMENTS
PK57452
5_Apr
2008
UK35295


ALC NULL TO NOT NULL NO DEFAULT DATA LOAD ISSUES
PK57984
5_Apr
2008
UK35295


VALIDATE WSL FAILS RC=08 ADB3001E ERROR FOR LABEL ON VIEW
PK58262
5_Apr
2008
UK35295


CM COMMENT ON SUPPORT
PK58343
5_Apr
2008
UK35295


MIG JOB SST3CH GENERATED WITH EXEC STATEMENT PRECEEDING THE JOB STATEMENT ONLY WHEN USING MASK OR IGNORE FILE
PK37537
4_Apr
2008
UK35281


INCORRECT SPACE ALLOCATION ON SYSREC OR SYSCOPY WHEN UTILITY PROGRAMS RUN ON A SINGLE PARTITION
PK38044
4_Apr
2008
UK35281


ADB27SP ERROR RUNNING REORG FROM PANEL ADB2314X
PK36982
4_Apr
2008
UK35275


LAUNCHPAD UPDATES ARE NOT VISIBLE WHEN STORED IN OBJECT COMPARE LIBRARY ( DEFAULT ACTION )
PK55074
4_Apr
2008
UK35281


GEN ABENDS0C8 ONCODE340 SIZE CONDITION ADB2REM AT ENTRY POINT ENTRY POINT GEN_TRIGGER AT STATEMENT 9081 CC12
PK57238
4_Apr
2008
UK35275


WHEN USING TEMPLATES AND A TEMPLATE IS DELETED IN PANEL ADB25T PANEL ADB25TU3 DOES NOT REFRESH TO REFLECT TEMPLATE IS
DELETED
PK57556
4_Apr
2008
UK35281


UTIL OPTION FROM DATABASE WITH 1 TABLESPACE ABENDS WHEN CHOOSINGA TABLE, WITH MORE THAN 2 TABLESPACES, CANNOT CHOOSE TABLES
PK58800
4_Apr
2008
UK35281


WSL RETURNS RC=00 WHEN POSITIVE SQLCODE RETURNED.
PK59645
4_Apr
2008
UK35275


DB2 ADMIN PANEL ADB21SAV MAY HAVE TOO MANY QUOTES FOR LIMITKEY VALUE
PK60826
4_Apr
2008
UK35275


ADMIN ALC - JCL HAS IF ..ELSE..ENDIF WITHOUT EXPRESSION & STMT
PK60950
4_Apr
2008
UK35281


HANG FROM PANEL ADB2M1S 'PAGE SET STATISTICS' WHEN ISSUING THE PRT TABLE ON FILE
PK51562
4_Apr
2008
UK35281


DUPLICATE REORG1 STEP WHEN USING UTIL OPTION FROM LISTDEF PANEL ADB25L OPTION U.O
PK53487
4_Apr
2008
UK35281


ISPT034 TABLE IS NOT OPEN TBQUERY ISSUED FOR TABLE OO THAT IS NOT OPEN WHEN USING SM 'STANDARD MAINTENANCE' PANEL ADB25LU
PK55876
4_Apr
2008
UK35275

HIPER

DB2 ADMIN ADB2CUST CUSTOMIZATION ENTERED INVALID KEYWORD IN ISPF TABLE 08/05/12 PTF
PECHANGE
PK56884
4_Apr
2008
UK35275


WARNING MESSAGE REGARDING DROPPED SYNONYM AND ALIAS POPS UP EVENWHEN YES IS SPECIFIED TO REPORT THEM
PK58839
4_Apr
2008
UK35275


REBIND PACKAGE FAILS INVALID KEYWORD, E WHEN PACKAGE PREVIOUSLY BOUND WITH DYNAMICRULES DEFINERUN
PK59430
4_Apr
2008
UK35275


ADMIN CHANGE MANAGEMENT SUPPORT FOR GOC VALIDATE OPTION
PK60026
4_Apr
2008
UK35275


UTILITY UT RUNSTATS PRIMARY COMMAND ADDED
PK60749
4_Apr
2008
UK35275


PANEL ADB21XAV 'ALTER INDEX - LIMITKEYS' FOLDS THE LIMIT KEYS TOUPPERCASE IN ERROR.
PK61156
4_Apr
2008
UK35281


SQLCODEN922 RESULTS IN LOOP WHICH RESULTS IN CEE0813S INSUFFICIENT STORAGE SITUATION
PK61744
4_Apr
2008
UK35281


GEN ISSUE RESULTS IN GOCC025E - DUPLICATE RECORD WAS DETECTED FOR OBJECT WHERE THE OBJECT NAME IS A VIEW
PK61861
4_Apr
2008
UK35275


ADB27C NOT SHOWING ALL VALID COMMANDS AFTER ALTERING 2 TABLES
PK33762
13_Feb
2008
UK33691


PANEL ADB25TE HAS A 70 BYTE LIMIT FOR THE DSN FIELD
PK43611
13_Feb
2008
UK33673


FF720 FFPK35127 GOC APPLY JOB FAILS SQLCODE148 ALTER FOR TABLE IN FOREIGN KEY RELATIONSHIP SQLCODEN148 FORWARD FIT FOR
PK35127
PK45874
13_Feb
2008
UK33673


ADB2W1 PANEL IN ADMIN TOOLS GIVES INCORRECT AND MISLEADING SIZE AND CHANGED DATE WITH INTERMITTENT RESULTS
PK49259
13_Feb
2008
UK33691


SYSUT1 DATASET ALLOCATED VIA TEMPLATE WHEN WSL YES AND TEMPLATE NO AND VIA DD STATEMENT IF WSL NO AND TEMPLATE NO REBUILD
INDEX
PK50886
13_Feb
2008
UK33673


ADMIN GEN TO CAPTURE ZPARM &SPRMNUPT= NUMBER OF UTILITY PARTS FOR DB2 APAR PK51853
PK52392
13_Feb
2008
UK33691


PANEL ADB2RIP REVOKE IMPACT REPORT INCORRECTLY LISTS CASCADED REVOKES FOR A TABLE AUTHORIZATION
PK54667
13_Feb
2008
UK33691


MSGDSNU329I DSNURWUF - FIELD 'XXXX' IS NOT DEFAULTABLE AND RC08 RUNNING LOAD STEP CREATED BY OC
PK56153
13_Feb
2008
UK33691


INCOROUT RIP SYSADM PRIV
PK56463
13_Feb
2008
UK33691


PANEL ADB21KB 'BIND PACKAGE' DOES NOT SUPPORT MIXED CASE VALUES RESULTING IN DSNT238I BIND COPY ERROR PACKAGE DOES NOT EXIST
PK57137
13_Feb
2008
UK33691


PANEL ADB26COV 'ALTER STORED PROCEDURE' ALLOWS INPUT FOR FIELD ' WLM ENV' RESULTS IN SQLCODEN104 ON DB2 9 ILLEGAL SYMBOL
"WLM"
PK57328
13_Feb
2008
UK33691


RESTART COMMENTS IN ALC GENERATED COMMENTS INCORRECT
PK57329
13_Feb
2008
UK33691


INVALID LINE COMMAND ON ADB27CA
PK47381
13_Feb
2008
UK33673


CM INCONSISTENCY BETWEEN WHAT PENDING CHANGES LISTS AND WHAT REGISTER DOES
PK47433
13_Feb
2008
UK33691


R720 ONLY REL COMMAND ON PANEL ADB27CA 'ALTER TABLES' DOES NOT FIND RELATED VIEWS ON VIEWS
PK52212
13_Feb
2008
UK33673


IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WHEN CONCATENATED CHANGES FILES IMPORTED AND ANALYZED
PK53132
13_Feb
2008
UK33673


VALIDATE WSL STEP IN CHANGE MANAGEMENT GENERATED JCL FAILS RC=08WITH MSG ERROR PROCESSING ALIASAAA IN A DROP STATEMENT
PK54318
13_Feb
2008
UK33691


ADB5146E UNEXPECTED SQLCODE IN :DELETE ADBPART ADB5034E ADBT005WDELETE FAILED FOR ADBCHKPT CONTROL RECORD 00C90088 304 ADBSCH
PK55152
13_Feb
2008
UK33673


IEC141I 013-18 DOES NOT CAUSE CM IMPORT JOB TO FAIL
PK55556
13_Feb
2008
UK33691


RTS COMMAND SHOWS SPACE FIELD INCORRECTLY FORMATTED IN PANEL ADB21SS AND ADB21SSI
PK56393
13_Feb
2008
UK33691


PANEL ADB21KR 'REBIND PACKAGE' AND PANEL ADB21PR 'REBIND APPLICATION PLAN' REOPT SYNTAX SUPPORT
PK56877
13_Feb
2008
UK33673


ALC AND CM WITH ADDINDEX RESULTS IN ISPV006 DATA TRUNCATION OCCURRED DATA FOR CHAR FORMAT VARIABLE "OBJTYPE" WAS TOO
LONG.
PK57011
13_Feb
2008
UK33673


CM IMPORT IBM0361W ONCODE=350 UNIT ADBCDTS AT ENTRY POINT REMOVE_LEADING_ZEROS UNIT ADBCDTS AT ENTRY POINT CATREC_TABLE
PK57316
13_Feb
2008
UK33673


ABENDS80A-10 OCCURRING WHEN USING DB2 ADMINISTRATION TOOL
PK57352
13_Feb
2008
UK33691


ALC HANG FROM PANEL ADB27C
PK57758
13_Feb
2008
UK33691


RESTART DOES NOT RESTART AT THE CORRECT STEP FOR GOC WITH TEMPLATES X37 AND USER ERROR ON EDIT OF SPACE
PK57779
13_Feb
2008
UK33673


ADMIN ANALYZE CHANGE WITH VALIDATE WSL Y FAILED WITH ONCODE 150
PK38614
17_Jan
2008
UK33039


UR LINE COMMAND FAILS SQLCODEN151 IN DB2 R810 CM ATTEMPTING TO UPDATE THE SYSIBM.SYSCOLUMNS.FOREIGNKEYCOLUMN
PK36496
17_Jan
2008
UK33039


REVOKE IMPACT DOES NOT SHOW CORRECT CASCADE FOR USER AUTHS ON VIEW
PK49066
17_Jan
2008
UK33039


INVALID TOKEN AFTER PART INTEGER - EXPECTED ENDING CLAUSE
PK49250
17_Jan
2008
UK33039


MASKING ISSUE WITH STOGROUP FOR INDEX OBJECTS
PK50143
17_Jan
2008
UK33039


SQLCODE401 WHEN USING EXPLAIN FROM PANEL ADB222
PK52524
17_Jan
2008
UK33039


GOCM011E UNKNOWN MASK TYPE "OWNER" FOUND IN MASK FILE RECORD IF ADMIN DEFAULT CAPITALIZE OBJECT NAMES = NO AND USE LOWER CASE
PK53214
17_Jan
2008
UK33039


DDL GENERATED IS INVALID FOR LIMITKEY WHEN DSNHDECP DECIMAL=COMMA IS USED. E.G. (99,, 9999,,)
PK54716
17_Jan
2008
UK33039


MAXE(0) DOES NOT HALT PROCESSING
PK54798
17_Jan
2008
UK33039


RH FUNCTION RETURNS -134 IN DB2V7 DUE TO HEX(CD.COLVALUE)
PK55155
17_Jan
2008
UK33039


PE SITUATION WITH APAR'S PK51388/PK23965 ( ABSTRACT TO BE CLARIFIED UPON REVIEW ).
PK56140
17_Jan
2008
UK33039


GEN ON QUOTED VIEW NAMES RESULTS WITH RC=16 UNRESOLVED SYMBOL. INDEX =001
PK54077
17_Jan
2008
UK33039


CREX DOES NOT WORK PROPERLY WHEN TABLESPACE IS PARTITIONED AND CHANGE MANAGEMENT ID IS SET TO NONE
PK55019
17_Jan
2008
UK33039


ADBHWLDA PANEL NEEDS REPLACED
PK39317
10_Dec
2007
UK32090


GEN OF TABLESPACE FAILS ONLY USING REMOTE CC CATALOG COPY. UNRESOLVED SYMBOL PARSING DDL VIEW STATEMENT.
PK43612
8_Dec
2007
UK32069


INTERNAL APAR BASED ON DEFECT 6148. ADB2GENM PANEL MISSING WHEN INVOKING GEN WITH MASKING FROM ADB2GENS AND ADB2GEN6 PANELS.
PK39179
8_Dec
2007
UK32069


IBM INTERNAL CM COMMENT AND LABELS BEING GENERATED
PK47753
8_Dec
2007
UK32069


SQLCODE614 ON CREATE INDEX ADBCHGX2 WHEN DB2 R810 CM
PK51898
8_Dec
2007
UK32069


SAMPLE JOB ADBTMPDB CONTAINS AS TEMP RESULTING IN A SQLCODE -104SQLCODEN104 WHEN EXECUTED ON DB2 910
PK52525
8_Dec
2007
UK32069


MEMBER ADBTSIN IN *EXEC LIBRARY INCORRECTLY SPECIFIES TRK DURING ALLOCATION
PK53137
8_Dec
2007
UK32069


CHANGE MANAGEMENT PANEL ADB2C14 'CM - IMPORT CHANGES' DOES NOT SAVE VALUES ACROSS SESSIONS
PK53574
8_Dec
2007
UK32069


PANEL ADB2C11 'CM - CHANGES' DOES NOT ISSUE A MESSAGE WHEN INAPPROPRIATE LINE COMMANDS ARE ISSUED.
PK53897
8_Dec
2007
UK32069


WHEN USING MIGRATE AND SEQUENTIAL MASK, 2ND JOB WAITS FOR MASK DATASET WHICH DOES NOT GET RELEASED
PK54034
8_Dec
2007
UK32069


WHEN USING TABLE MIGRATE AND DDL=N AND DATA=Y, MIGRATE ONLY MIGRATES 1 TABLE PER TABLESPACE
PK54148
8_Dec
2007
UK32069


ADMIN ALC CONVERT STEP HAS DEBUG LINES THAT NEED REMOVED
PK54266
8_Dec
2007
UK32070
PK55876

NEW FUNCTION
PK37360
7_Dec
2007
UK32064


ADBTEP2 CEE3703I IN HANC CONTROL BLOCK, THE EYE CATCHER IS DAMAGED. ENTRY POINT SETUPOUT ABEND U4038-1 RC12
PK34232
7_Dec
2007
UK32064


CC FUNCTION JOB FAILS SQLCODEN873/SQLCODE873 WHEN CCSID EBCDIC USED TO CREATE OBJECTS
PK35839
7_Dec
2007
UK32064


ADMIN TOOL DATABASE DISPLAY FROM A DDF CONNECT FAILS WITH AN ABEND
PK40408
7_Dec
2007
UK32064


-STO COMMAND DOES NOT HAVE COMPLETE PART KEYWORD RESULTS IN MESSAGE DSN9002I UNBALANCED PARENTHESES WHEN SM LINE COMMAND USED
PK41336
7_Dec
2007
UK32064


PANEL ADB27C REQUIRED THE LENGTH FIELD BE FILLED IN FOR BUILT-IN DATA TYPE ROWID
PK45602
7_Dec
2007
UK32064


ADMIN TOOL UPDATE OPT HINTS CORRUPTS PLAN TABLE DATA FIELDS LIKE MATCHCOLS INDEXONLY SORTN_UNIQ ETC AFFECTED
PK46444
7_Dec
2007
UK32064


SAMPLE JOB ADBFB2VB IS MISSING SEVERAL EXECS
PK48402
7_Dec
2007
UK32064


MASKING FOR MODEL TABLES
PK49835
7_Dec
2007
UK32064


REBIND STATEMENTS FROM EARLIER WSL RUN REISSUED, ADBHOLD TABLE MANAGEMENT
PK51527
7_Dec
2007
UK32064


ALC CHANGE FROM DATE TO TIMESTAMP COLUMN IN TABLE DEFINED AS CCSID UNICODE RESULTS IN DSNU299I REASON=X'00E40323' ERROR
PK51649
7_Dec
2007
UK32064


ALTER PARTITIONED TABLE RESULTS IN INVALID PART# ON PANEL ADB21TAV
PK52144
7_Dec
2007
UK32064


GEN OR DDL COMMAND GIVES INCORRECT DDL FOR TABLESPACES IF THEY WERE CREATED WITH SECQTY 0, SECQTY IS OMITTED
PK53273
7_Dec
2007
UK32064


CHANGE MANAGEMENT GENERATED WSL MISSING REBIND FOR PLAN/PACKAGE EFFECTED BY DROP INDEX STATEMENT
PK53386
7_Dec
2007
UK32064


WHEN USING MIG, AND USING OPTIONS DDL=N DATA=Y CHECK=Y JCL GENERATED MISSING ENDIF ON FIRST IF STATEMENT
PK53420
7_Dec
2007
UK32064


ABEND04E RC00D70014 RUNNING COPY CATALOG
PK53526
7_Dec
2007
UK32064


WHEN USING MIG, AND OPTION YES FOR BATCH MIGRATE, AND F3 IS PRESSED WITHOUT ENTERING MASK, ADB28M PANEL ERROR APPEARS
PK54722
23_Oct
2007
UK30567

HIPER

ADB2CUST EXEC REMOVES CMOWN CUSTOMIZATION PARAMETER
PK16325
12_Oct
2007
UK30223


ADMIN TOOL ADB28T PANEL ADDRI AND MIGRI COMMAND GIVE DIFFERENT RESULT
PK46996
12_Oct
2007
UK30223


SQLCODE -805 AFTER INSTALLING A GROUP OF MAINTENANCE SQLCODEN805 SQLCODE805N
PK44995
12_Oct
2007
UK30223


ADMIN DSNT404I SQLCODE 562 SQLCODE562 INCORRECT GRANT ON ALTER OF SIMPLE TABLE TO SEGSIZE = 64
PK46757
12_Oct
2007
UK30223


PANEL ADB21I RETURN "INVALID VALUE" FROM COMMAND RT OR RO AFTER SELECTING A IMAGE COPY OF AN INDEX
PK46964
12_Oct
2007
UK30223


MSG "NO TABLESPACESTATS TABLE" OR "NO INDEXSPACESTATS TABLE" UNDER DB2 9 ON PANEL ADB2314T OR ADB2314I
PK47315
12_Oct
2007
UK30223


PROBLEMS HANDLING LOWERCASE OBJECT NAMES
PK49242
12_Oct
2007
UK30223


ADMIN ALC -663 LIMIT KEY VALUE FOR INDEX DOESN'T REFLECT COLUMN BEING DROPPED
PK51325
12_Oct
2007
UK30223


OBJECT COMPARE GETS PARSING WHEN CREATE TABLE HAS A SEMICOLON IN A STRING CONSTANT OR COMMENT RC20 ADBC033E UNSUCCESSFUL
PK51809
12_Oct
2007
UK30223


CM IMPORT CHANGE WITH MASK AND COLUMN NAMES ENCLOSED IN QUOTES RESULTS IN TRIPLE QUOTES AROUND COLUMN NAME
PK51878
12_Oct
2007
UK30223


CM INCORRECT LOAD SYNTAX WHEN RENAMING COLUMNS
PK52043
12_Oct
2007
UK30223


CM MESSAGE 'ALTER INCONSISTENCY IN ROWTYPE, LGTH OR PREFIX' WHEN CHANGES FILE CONTAINS A LABEL STATEMENT
PK52323
12_Oct
2007
UK30223


ALIAS DROP WHEN CHANGE MANAGEMENT RUN EXECUTED
PK39404
11_Oct
2007
UK30220


ALC MSG 'ADB27AC INTFIN DD STATEMENT MISSING' WHEN MULTIPLE ITEMS ADDED TO A WSL
PK38010
11_Oct
2007
UK30220


PANEL ADB21CDU 'UPDATE RUNSTATS INFORMATION' UPDATE FAILS SQLCODE+100 SQLCODEN100 AS WHERE CLAUSE CONTAINS INCORRECT VALUE
PK36502
11_Oct
2007
UK30220


DROP / CREATE SCENARIO USING HPU UNLOAD METHOD CAN SHOW APF FAILURE IF :BL2RLIB.TAG IS POPULATED
PK37888
11_Oct
2007
UK30220


PANEL ADB21PB "BIND PLAN" AND PANEL ADB21KB "BIND PACKAGE" DO NOT SUPPORT IMMEDWRITE(PH1) OR IMMEDWRITE(PH2)
PK42478
11_Oct
2007
UK30220


ALC TO ADD FOREIGN KEY CREATED INCORROUT DROP FOREIGN KEY STM STATEMENT WSL GETS SQLCODEN104 SQLCODE -104
PK44209
11_Oct
2007
UK30220


S LINE COMMAND ON PANEL ADB21P "APPLICATION PLANS" AND ADB21K "PACKAGES" DOES NOT RETURN ALL ROWS.
PK45524
11_Oct
2007
UK30220


PANEL ADB26CTQ INPUT PARMS IGNORED FOR ALC / UP OPERATION CHANGING PRIMARY KEY TO AN IDENTITY COLUMN, TYPE J OBJECT
PK46146
11_Oct
2007
UK30220


PANEL ADB2E 'EXPLAIN' OPTION U 'UPGRADE THE PLAN_TABLE TO CURRENT DB2 VERSION' DOES NOT ALLOW TABLE CREATOR TO BE SPECIFIED
PK46622
11_Oct
2007
UK30220


EXPLAIN FUNCTION FAILS SQLCODEN104 WITH FORSELECT / FORINSERT WHEN SQL IS IN COBOL AREA-A
PK47989
11_Oct
2007
UK30220


ISSUING COMMAND 'PANEL ADB2GEN' IN PANEL ADB21 THEN PRESSING ENTER CAUSES A LOOP/WAIT STATE
PK48965
11_Oct
2007
UK30220


IMPROVEMENTS TO MESSAGING IN ADB2CUST EXEC WHEN ERRORS OCCUR
PK50247
11_Oct
2007
UK30220


DB2 ADMIN DEFAULTS PANEL (ADB2P2) DOES NOT ACCEPT CHANGE TO OPTION ACTION WHEN NO ROWS FOUND ===> M
PK50956
11_Oct
2007
UK30220


ADMIN 710 PARSER ISSUE WITH CCSID 870 AND CONCANTENATION OPERATOR TRANSLATES TO X'6A6A'
PK53131
11_Oct
2007
UK30220


AL ON INDEX RESULTS IN PANEL ERROR CMG999 AND MSGID=NXXX WITH RC=12
PK39559
24_Sep
2007
UK29502


SQLCODEN516 RETURNED AFTER RLF WARNING MESSAGE ISSUED ON PANEL ADB2PRPW 'DB2 PREDICTE GOVERNOR WARNING'
PK42325
24_Sep
2007
UK29502


PANEL ADB20@ 'LINE COMMANDS' FIND COMMAND INCONSISTANT
PK50239
24_Sep
2007
UK29502


PANEL ADB21TAV FOLDS LIMIT KEY TO UPPER CASE WHEN DISPLAYING THELIMIT KEY
PK40312
19_Sep
2007
UK29373


CRE TABLE LINE COMMAND AND 'AS MODEL' YES ON PANEL ADB26CT 'CREATE TABLE' GIVES DUPLICATE COLUMNS ON PANEL ADB26CTF
PK40373
19_Sep
2007
UK29373


PANEL ADB21XA 'ALTER INDEX' ZERRMSG ISPP178 WHILE ATTEMPTING TO STORE VARIABLE 'PART' WHEN STORTYPE CHANGED FROM E TO I
PK41709
19_Sep
2007
UK29373


ADB26CUU 'CREATE TABLE COLUMN NUMBER' DOES NOT HONOR THE 'FOR BIT DATA' FIELD F/F FOR R710 PK34740
PK42454
19_Sep
2007
UK29373


ALC SQLCODEN669 WHEN MODIFYING COLUMN IN PRIMARY KEY
PK45198
19_Sep
2007
UK29373


FF720 ADMIN TOOL DOES NOT RETURN TO DB2 SELECTION SCREEN AFTER AN INVALID SUBSYSTEM WAS CHOSEN F/F FOR R710 PK24182
FFPK24182
PK48216
19_Sep
2007
UK29373


SQLCODE626 ON GLOBAL CHANGE TO ALL PARTITIONS IN PANEL ADB21XA
PK39160
19_Sep
2007
UK29373


IBM INTERNAL IMPORT SOMETIMES FAILS WHEN MASK OPTION IS USED
PK39186
19_Sep
2007
UK29373


IBM INTERNAL DURING ADBTEP2 PROCESSING, THE ERROR MESSAGES ADB5044E WAS RECEIVED.
PK41051
19_Sep
2007
UK29373


ABEND0C4 IN ADB2SYS RUNNING ADB2CUST
PK41898
19_Sep
2007
UK29373


ADMIN CM RUN FOR A CHANGE RESULTS IN FUNCTION=ADB2WCM TBOPEN RC=8 OR NO RCVR RUNTIME ANALYZE STEPS FOR CHANGE WITH RCVR
PK45685
19_Sep
2007
UK29373


IBM INTERNAL DB2 V8 MINVALUE / MAXVALUE SUPPORT IN LIMIT KEY, PK45155 IS THE ADB COREQ AND WILL CONTAIN THE ADB PARTS
PK46966
19_Sep
2007
UK29383


ADB2C4O DOES NOT ALLOW MORE THAN ONE LINE TO BE INSERTED OR REPEATED.
PK47508
19_Sep
2007
UK29373


NEW WARNING MSG ON CM PROMOTE OF NEW BASE VERSION
PK47725
19_Sep
2007
UK29373


ADMIN CM DELETING CHANGES FROM CHANGES DATABASE
PK50330
19_Sep
2007
UK29373


ADB25TU INSTEAD OF GOC5 OR ADB2C11A AS BACKGROUND PANEL
PK39648
18_Sep
2007
UK29373


ALTER LABEL STMT BEING EXECUTED AS COMMENT
PK39565
18_Sep
2007
UK29373


ADMIN TOOL PANEL ADB21TFK APPEARS TO BE REPORTING DUPLICATE ENTRIES .
PK35435
18_Sep
2007
UK29373


ALC ALTER CONTAINS UNQUOTED TIMESTAMP STRING RESULTS IN AN SQLCODE -104 SQLCODEN104
PK42557
18_Sep
2007
UK29373


PANEL ADB21C 'COLUMNS' T LINE COMMAND LISTS MULTIPLE TABLES ON PANEL ADB21T 'TABLES, VIEWS, AND ALIASES'
PK43133
18_Sep
2007
UK29373


ADD PANEL ADB21T LINE COMMAND FOR NON-RECURSIVE RELATIONAL INTEGRITY CONSTRAINTS
PK43411
18_Sep
2007
UK29373


FF720 CATALOG COPY ALIAS TYPE A ON PANEL ADB2CCS SELECT COPY OF DB2 CATALOG REFERENCES LOCAL TABLES NOT REMOTE TABLES
PK45433
18_Sep
2007
UK29373


ADMIN TOOL ADB21TAB PANEL DOES NOT VERIFY NEW COLUMN ATTRIBUTES AND DOES NOT ISSUE AN ERROR MESSAGE,F/F
PK33918,PK33710,PK35588
PK51388
18_Sep
2007
UK29373


ALC CREATES AN ADDITIONAL COMMENT ON STATEMENT IN ADDITION TO THE NEEDED ALTER STATEMENT
PK46271
18_Sep
2007
UK29373


THE DB2 ADMINISTRATION TOOL APAR PK24488 DID NOT ADDRESS ALL OF THE REPORTED ISSUES WITH THE CON LINE COMMAND.F/F OF PK32744
PK47792
18_Sep
2007
UK29373


PANEL AUTO REFRESH FAILURE
PK50583
18_Sep
2007
UK29373


ALTER NOT WORKING CORRECTLY WHEN REMOVING A FIELDPROC
PK50999
18_Sep
2007
UK29373


ADMIN TOOL INCONSISTENT OPTIONS PRESENTED FOR RUNSTATS WHEN MULTIPLE TABLESPACES ARE SPECIFIED
PK36773
17_Sep
2007
UK29298


ALC CHANGE FROM VARCHAR TO CHAR COLUMN RESULTS IN ABEND=S04E REASON=00E40323 AND MSG DSNU334I DSNURWRF ERROR CODE '12'
PK38499
17_Sep
2007
UK29298


ALC PRODUCES MULTIPLE JOBCARDS WHEN USING OPTION 2 USE GENERATEDBATCH JOBS ON PANEL ADB27CTC 'ALTER TABLE'
PK31446
17_Sep
2007
UK29298


PK16178 FOLLOW UP
PK34029
17_Sep
2007
UK29298


ALC UNLOAD TEMPLATE NOT USING USER SPECIFIED TEMPLATE
PK35639
17_Sep
2007
UK29298


ALC SQLCODE -206 WHEN ADDING QUOTED COLUMN TO OBJECT AS COLUMN NAME IS TRIPLE QUOTED I.E. """QUOTED COL"""
PK39331
17_Sep
2007
UK29298


ALC PANEL ADB27A 'UNLOAD METHOD' R AND 'GENERATE TEMPLATE STATEMENTS" YES RESULTS IN DSNU047I DSNURELD SYSREC MISSING
PK42202
17_Sep
2007
UK29298


ALC ALTER OF COLUMN AND DELETE AND RESTORE MEMBER NAMES ARE INCORRECTLY GENERATED WITH THE WRONG NAME
PK42372
17_Sep
2007
UK29298


ALC DSNU299I DSNURWBG CHARACTER CONVERSION FROM CCSID 65534 TO CCSID 1208 FAILED WITH ERROR CODE 00
PK43383
17_Sep
2007
UK29298


CURSOR POSITIONING ON PANEL ADB27AC AFTER PRESSING ENTER TWICE
PK49241
17_Sep
2007
UK29298


ALC UNICODE TABLE LOAD FAILS REASON=X'00E40323'
PK47684
17_Sep
2007
UK29298


USING TEMPLATES ADMIN ALC WITH JES3 GIVES IAT6108 JOB F226154J (JOB29334) FAILED BY INTERPRETER
PK50237
17_Sep
2007
UK29298


PANEL ADB21TAV 'ALTER PARTITIONED TABLE' FOLDS THE INPUT TO UPPERCASE
PK39301
14_Sep
2007
UK29241


REVOKE COMMAND ON PANEL ADB2AR "RESOURCE AUTHORIZATIONS" PRODUCED SQL WITH INVALID SYNTAX SQLCODEN104 SQLCODE -104
PK33876
14_Sep
2007
UK29241


WSL PROCESSING ADDING ADBPAUSE CAUSED RESTART ISSUE
PK35795
14_Sep
2007
UK29241


REVOKE IMPACT REPORT SHOWING CASCADE OF A BINDAGENT AUTHORITY
PK35810
14_Sep
2007
UK29241


ADB2RIP PERFORMANCE ISSUES WHEN REPORTING AT THE SYSTEM AUTHORIZATION LEVEL, OPTION ZA
PK40962
14_Sep
2007
UK29241


ADMIN PARSER PROBLEM WITH VIEWS INVALID COLUMN RESOLUTION
PK41712
14_Sep
2007
UK29241


FF720 SQLCODE332 EXECUTING SELECT (*) FROM A TABLE THAT CONTAINS A GRAPHIC COLUMN F/F FOR R710 PK21177 FFPK21177
PK44010
14_Sep
2007
UK29241


INTERNAL APAR FOR "DB2 V8 MINVALUE/MAXVALUE SUPPORT IN LIMIT KEY"
PK44389
14_Sep
2007
UK29234


FF720 ROTATE FIRST TO LAST PARTITION FAILS WITH SQLCODE904 F/F FOR R710 PK15743 FFPK15743
PK47696
14_Sep
2007
UK29241


PROBLEMS HANDLING LOWERCASE OBJECT NAMES
PK40121
14_Sep
2007
UK29232


PRE-CONDITIONING ENHANCEMENTS FOR CERTAIN NATIONAL LANGUAGES TO PREPARE FOR CORRECT LOOK-UP HANDLING AND MESSAGE DISPLAY."
PK44656
14_Sep
2007
UK29241


FF720 GRANT OF OVER 300 OBJECTS CAN RESULT IN "SHORT ON STORAGE"CAUSING THE TASK TO FAIL WITH ABENDU4088 RC3EC F/F FOR
PK34171
PK40109
12_Sep
2007
UK29147


GEN/DDL COMMAND AGAINST OBJECTS MIGRATED FROM DB2 R610 WHICH HAVE SYSIBM.SYSCOLUMNS.DATATYPEID OF 0 HAVE MISSING QUOTES DATE
PK28882
12_Sep
2007
UK29136


AL/RDEF TEMPLATE NAME NOT RESOLVING &JO / &JOBNAME RESULTS IN DSNU1032I DSNUGTDS INVALID QUALIFIER RC=8
PK35132
12_Sep
2007
UK29147


ADMIN TOOL GEN COMMAND PRODUCES NO RESULTS WHEN ONLY PLANS AND PACKAGES ARE REQUESTED
PK39636
12_Sep
2007
UK29147


GOC WSL APPLY STEP HAD IKJ56225I DATA SET ALREADY IN USE, TRY LATER+ MESSAGE BUT STEP ENDED RC=00
PK41691
12_Sep
2007
UK29139


FF720 ADMIN PANELS ADB2W AND ADB2W1S FOR WORK STATEMENT LIST DO NOT GIVE PROPER ERROR MESSAGES OR PRESENT CORRECT MEMBER
NAME
PK41792
12_Sep
2007
UK29136


FF720 DID NOT ADDRESS ALL OF THE ISSUES RELATED TO :NICK CONTAINING MULTIPLE ENTRIES FOR :BL2RLIB F/F FOR 710 PK33763
PK41838
12_Sep
2007
UK29139


FF720 INVALID UNIT PARM ON SYSREC DD GENERATED BY SKELETON ADB2UTH1 FOR UNLOAD DATASET F/F FOR R710 PK32311 FFPK32311
PK42584
12_Sep
2007
UK29147


V810 COMPATIBILITY MODE CM USING ADMIN ICS LINE COMMAND IMAGE COPY STATUS FOR THE DATABASE GET SQL -416 SQLCODEN416
PK42690
12_Sep
2007
UK29136


WSL VALIDATE END RC=08 WHEN TABLE DEFINED WITH RESTRICT ON DROP
PK42802
12_Sep
2007
UK29136


UR LINE COMMAND RESULTS IN MSGISPP178 RC16 PANEL ERROR IN PANEL ADB21TUR
PK43086
12_Sep
2007
UK29136


APAR PK37851 DID NOT RESOLVE ALL OF THE ISSUES WITH THE REVOKE IMPACT REPORT PANEL ADB2DIP FOR PACKAGES
PK44013
12_Sep
2007
UK29139


FF720 ADMIN VER 7.2 TO FORWARD FIT FOR APAR PK37725 FROM R710 F/F FOR FFPK37725
PK44101
12_Sep
2007
UK29147


ICS LINE COMMAND ON PANEL ADB21X 'INDEXES' GIVES MESSAGE 'NO ROWS RETURNED' IN ERROR.
PK45732
12_Sep
2007
UK29147


RECOVER TO COPY WSL MISSING REQUIRED DD FOR DB2 R710 RESULTS IN MSGDSNU047I DSNUCRIX A REQUIRED DD CARD OR TEMPLATE IS
MISSING
PK45764
12_Sep
2007
UK29136


AL STORED PROCEDURE DOES NOT SUPPORT REMOVING RUN OPTIONS AS NO ABILITY TO PASS AN EMPTY STRING RUN OPTIONS ''
PK49786
12_Sep
2007
UK29147


GOCC025E - DUPLICATE RECORD WAS DETECTED WHEN ANALYZING A TABLE WITH TRIGGERS
PK50622
12_Sep
2007
UK29147


WSL DATASET NOT FREED UNTIL LOGOUT
PK38470
12_Sep
2007
UK29139


AL COMMAND VIA WSL HAS INVALID ADM SYNTAX
PK38999
12_Sep
2007
UK29139


IBM INTERNAL APAR, ADB21DC - DESCRIBE COLUMNS PANEL TRUNCATES OBJECT (TBNAME)
PK39380
12_Sep
2007
UK29139


FF720 AL / RDEF USING ONLY IC UTILITY PRODUCES DSN THAT EXCEEDS 44 CHARACTERS FFPK35445
PK39002
12_Sep
2007
UK29139


IBM INTERNALAPAR, ADB21TPK -PRIMARY KEY FOR TABLE PANEL TRUNCATES OBJECT IN TITLE
PK38992
12_Sep
2007
UK29139


IBM INTERNALAPAR, ADB25 UTIL GEN LISTDEF/TEMPLATE PANEL CUTS OFF TEMPLATE TABLE
PK38438
12_Sep
2007
UK29139


IBM INTERNAL FF PANEL ADB2ZZMN (ADMIN V7R2, DB2V7) PARM CLAIMDTADOES NOT RETAIN UPDATED VALUES.
PK40914
12_Sep
2007
UK29139


FF720 ADMIN TOOL WORK STATEMENT LIST CLONE PANEL ADB2W1Q DOES NOT RETAIN THE USER ENTERED VALUES F/F FOR PK23656 FFPK23656
PK41692
12_Sep
2007
UK29147


PANEL ADB21I RETURN "INVALID VALUE" FROM COMMAND RT OR RO AFTER SELECTING A IMAGE COPY OF AN INDEX F/FIT V710 PK34127
PK42992
12_Sep
2007
UK29139


CM RUN REPORTS ' ADBC099E : WSL MISMATCH ' WHEN A TABLE CONTAINS RESTRICT ON DROP
PK44730
12_Sep
2007
UK29139


RECEIVING SQLCODE104 DURING THE PROCESSING OF REVOKE PLAN PRIVILEGES PANEL ADB2RP .
PK45343
12_Sep
2007
UK29147


CHANGE MANAGEMENT ANALYZE FAILS WITH MSG SYNTAX ERROR DURING STATEMENT SCAN
PK46735
12_Sep
2007
UK29139


NOVALUE CONDITION RAISED IN ADB2M1M WHEN USING SM MOVE FUNCTION
PK46744
12_Sep
2007
UK29139


ALTER SEQUENCE NO ORDER / NOORDER NOT CREATED WHEN ORDER ATTRIBUTE CHANGED
PK46747
12_Sep
2007
UK29139


PANEL ADBH1PL"HELP: XXXX PACKAGE LIST" DESCRIBES TIMESTAMP COLU MN ON PANEL ADB21PL "PACKAGE LIST" AS "WHEN PACKAGE WAS
BOUND"
PK46753
12_Sep
2007
UK29139


PANEL ADB2USU DOES NOT ALLOW A MAXIMUM LENGTH DATASET NAME AND ISSUES MESSAGE INVALID DSN - LENGTH
PK48219
12_Sep
2007
UK29139


PANEL ADB2W1 "WORK STATEMENT LIST LIBRARY:", WSL LIST REPOSITIONS TO TOP OF LIST AFTER EVERY ACTION
PK48433
12_Sep
2007
UK29139


ADB25TU3 'SPECIFY UTILITY TEMPLATE USAGE' FIELD 'GENERATE TEMPLATE STATEMENTS' CHANGED BY ADB2US 'TABLE SPACE
UTILITIES'
PK49228
12_Sep
2007
UK29139


ADMIN PARM REFRESH VARIABLE SET TO NO AFTER CREATE TABLE IS PERFORMED
PK49665
12_Sep
2007
UK29147


PART SPECIFICATION FOR PARTITIONED TABLE MAY BE WRONG BECAUSE LK/TP RECORDS ARE NOT SORTED CORRECTLY.
PK42146
7_Aug
2007
UK27984


CATALOG COPY GENERATES INCORRECT PRIQTY SECQTY VALUES,0C4 IN GEN
PK38820
23_Jul
2007
UK27385


FF720 CHECK DATA UTILITY WITH TEMPLATE EXECUTED VIA ADBTEP2 USEDDIFFERENT SPACE UNITS FOR DATASETS USED F/F FOR R710
PK33759
PK33759
23_Jul
2007
UK27385


CHECK DATA UTILITY WITH TEMPLATE EXECUTED VIA ADBTEP2 USED DIFFERENT 'SPACE UNITS' FOR DATASETS USED
PK36061
23_Jul
2007
UK27385


ADMIN GEN ON VIEWS GIVES INCORRECT NUMBER OF VIEWS GENERATED
PK37936
23_Jul
2007
UK27385


PANEL ADB2RIP REVOKE IMPACT REPORT DOES NOT REPORT VIEWS WHICH WILL BE DROPPED WHEN USER AUTHORITY REVOKES
PK45154
23_Jul
2007
UK27385


WSL CLONE WITH -1 RESULTS IN ERROR
PK46642
23_Jul
2007
UK27385


PANEL AUTO REFRESH FAILURE
PK39574
3_Jul
2007
UK26807


WSL COMPLETES WITH RC(0), DOES NOT REFLECT LOAD RC(4)
PK40333
3_Jul
2007
UK26807


DB2 ADMIN TOOL, GEN OPTION, BUILDS DDL FOR A COLUMN NAME OF A RESERVED WORD WITHOUT QUOTES
PK40465
3_Jul
2007
UK26807


CLONE WSL FEATURE SQLCODEN664 WHEN SOURCE WSL CONTAINS PRIQTY/SECQTY -1 AND PANEL ADB2W1Q 'TABLE SPACE AND INDEX ATTRIBUTES'
YES
PK37300
3_Jul
2007
UK26807


ADB2GEN GIVES INCORRECT RESULTS WHEN TRANSITIONING FROM DECIMAL AS PERIOD TO DECIMAL AS COMMA
PK38399
3_Jul
2007
UK26807


SQLCODEN601 AFTER ADBTEP2 ISSUED MESSAGE UNEXPECTED SQLCODE IN : LOCK ADBPART(1)
PK38457
3_Jul
2007
UK26807


ADMIN TOOL GEN DOES NOT PRODUCE PARTITION ENDING AT CONSTANT VALUE CORRECTLY
PK39159
3_Jul
2007
UK26807


ALC COMMAND GENERATES LOAD CONTROL STATEMENTS WITHOUT THE NEEDEDASCII KEYWORD RESULTS IN DSNU334I DSNURCON INPUT FIELD
INVALID
PK35484
3_Jul
2007
UK26807


DURING ALC UPDATE OF A COLUMN NAME CONTAINING SPECIAL CHARACTERS RECEIVED ADBC173E DDL CONV : OLD COLNAME MISMATCH
PK36373
3_Jul
2007
UK26807


ALC CONVERT STEP CNVRT50 FAILS CC=1008 AND MESSAGE ADBC138E COL NAME TOO LONG
PK39731
3_Jul
2007
UK26807


WSL CLONE OVERWRITE USING PERCENTAGES AND SMALL PRIQTY / SECQTY RESULTS IN PRIQTY 0 AND/OR SECQTY 0
PK41255
3_Jul
2007
UK26807


ABEND0C8 ENCOUNTERED WITHIN GEN PROCESSING OF LARGE SET OF DDL CONTAINING OVER 20K OF REBINDS
PK41473
3_Jul
2007
UK26807


FF720 ADB2GEN ABEND0C8 REASON 8 WHEN GEN COMMAND ISSUED AGAINST LARGE VIEW IBM0342S ONCODE=340 THE SIZE CONDITION WAS
RAISED.
PK41482
3_Jul
2007
UK26807


WSL CLONE WITH CATALOG REPLACE OPTION CREATES INCORRECT SECONDARY ALLOCATION OF ZERO FOR INDEXES CREATED IN DB2 V5
PK41472
3_Jul
2007
UK26807


FF720 ADMIN TOOL ADB2GEN INCORRECTLY PARSES DDL F/F FOR R710 PK33487 FFPK33487
PK41474
3_Jul
2007
UK26807


FF720 GOC GOC2DTC DOES NOT SUPPORT LOWER CASE DDL FAILS RC16 WITH FUNCTION DOES NOT SUPPORT COMMENT STATEMENT FFPK37547
PK41677
3_Jul
2007
UK26807


GEN OR DDL LINE COMMAND ON A TABLE WITH CCSID EBCDIC AND COLUMN DEFINED AS MIXED DATA FAILS TO SHOW MIXED DATA SUBTYPE
PK42114
3_Jul
2007
UK26807


FF720 OBJECT COMPARE DOES NOT PROCESS PRIQTY AND SECQTY WITH A VALID VALUE OF -1 CORRECTLY F/F FOR R710 PK34687 FFPK34687
PK42320
3_Jul
2007
UK26807


PRIQTY SECQTY -1 "MISSING" IN DDL/GEN COMMAND OUTPUT
PK43474
3_Jul
2007
UK26807


INTERNAL INTERNAM APAR,THE SET CURRENT SQLID= VALUE SHOWS THE SCHEMA NAME INSTEAD OF THE OWNER.
PK43609
3_Jul
2007
UK26807


DB2 OBJECT COMPARE GOC2CMP ABENDS U4038 ON GTT GLOBAL TEMPORAY TABLE T03COMP ABENDU4038 REASON 00000001
PK43610
3_Jul
2007
UK26807


FF720 GOC WITH DB2XML XMLVARCHAR GIVES GOC2DTC UNSUCCESSFUL COMPLETION UNEXPECTED TOKEN IN TABLE DEFINITION TOKEN F/F
PK43613
3_Jul
2007
UK26807


INTERNAL APAR , USERS CAN SEE STATEMENTS IN WORK STATEMENT LISTSWHICH ARE MISSING FOR ADMIN FIX FOR PK36504 FFPK36504 FF720
PK46872
3_Jul
2007
UK26807


IBM INTERNAL APAR,DUPLICATE IN KEYWORD (-637) IN CREATE TABLE DURING ALC
PK39308
3_Jul
2007
UK26807


FF720 OBJECT COMPARE LOOP WHEN MASK USED FOR OBJECTS GETTING DUPLICATE NAMES AND ALIAS IS ALSO FOUND AS A VIEW FFPK35962
PK37837
3_Jul
2007
UK26807


IBM INTERNAL
PK38279
3_Jul
2007
UK26807


IBM INTERNAL ADDS STOP ON CONVERSION ERROR OPTION TO THE CM ANALYZE PANEL
PK38750
3_Jul
2007
UK26807


IBM INTERNAL APAR, DUPLICATE DATA SET NAME &&CATOUT IN RUN JOB
PK43421
3_Jul
2007
UK26807


INTERNAL APAR FOR DEFECT 6062
PK34511
30_Jun
2007
UK26740


LKEY COMMAND GIVES "NOT A PARTITIONED TABLE" MESSAGE FOR A INDEXPARTITIONED OBJECTS
PK36556
30_Jun
2007
UK26742


JCL ERROR ENCOUNTERED AFTER CLONE OF TEMPLATE CONTAINING A CONCATENATION FOR SYSIN, " //DD* " , BLANKS REMOVED .
PK41506
30_Jun
2007
UK26740


FF720 ALC COMMAND DOES NOT CHANGE COLUMN FROM NOT NULL TO NOT NULL WITH DEFAULT F/F OF PK32667 FFPK32667
PK41736
30_Jun
2007
UK26740


FF720 PANEL AUTO REFRESH FAILURE F/F FOR R710 PK27946 FFPK27946
PK40711
30_Jun
2007
UK26740


THE ENHANCEMENT OF CHANGE MANAGEMENT PROCESS OF APPLYING PENDINGCHANGES.
PK45418
30_Jun
2007
UK26742


SQ LINE COMMAND PRODUCES GARBAGE CHARACTERS
PK41612
5_Jun
2007
UK25859

HIPER

MISSING HOLDDATA FOR ADMIN BIND AND SAMPLE MEMBER 07/04/04 PTF
PECHANGE
PK38923
3_May
2007
UK23722


ADMIN GENERATES MULTIPLE REBINDS STATEMENTS ON SAME PACKAGE AFTER ALTER ALTERS
PK38921
3_May
2007
UK23722


DDL LINE COMMAND FAILURE PRODUCES MSG: BIND OR REBIND IS NEEDED FOR PACKAGE ADB2REM
PK37618
4_Apr
2007
UK23722


ABD2GEN ABENDS WITH S0C4 IBM0534S ONCODE=8094 PROTECTION EXCEPTION COMPILE UNIT ADB2REG ENTRY POINT UPDATE_SYMBTAB
PK37849
4_Apr
2007
UK23722


DOCUMENTATION FOR USER DEFINED INDEX FOR DB2 ADMINISTRATION TOOLIS MISLEADING V8 V7 ADBCX SYSIBM SYSINDEXES SYSVIEWDP
PK38316
4_Apr
2007
UK23722


IBM INTERNAL
PK38450
4_Apr
2007
UK23722


IBM INTERNAL
PK33198
4_Apr
2007
UK23722


ALC ALLOCATION OF ULD/ULC ON TAPE CAUSES IKJ56221I VOLUME NOT AVAILABLE IKJ56221I VOLUME IS ALLOCATED TO ANOTHER JOB OR
USER
PK35826
4_Apr
2007
UK23722


ADMIN AL / RDEF FAILS IN LOAD WITH MESSAGE DATASET NOT FOUND
PK42707
4_Apr
2007
UK23722


AE PK37618
PK36230
6_Mar
2007
UK22767
PK41612

PK36230 IS THE FOLLOW-ON APAR FOR H0IH720.
PK34918
16_Jan
2007
UK21299

HIPER

H0IH720 ROLLUP APAR (DB2 ADMINISTRATION TOOL)

Top of page