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: 12 March 2025
DB2 Administration Tool Version 4.2
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK07196
27_Jul
2005
UK05779


DATA TRUNCATION ON CHANGE OF DECIMAL COLUMN SIZE
PK04889
25_May
2005
UK03838


OBJECT COMPARE GOC2CMP IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ95962
31_Jan
2005
UK00143


IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED FROMCOMPILE UNIT ADB2FMT FROM ADB2GEN
PQ97074
31_Jan
2005
UK00143


ADMIN ALTER COLUMN INVOLVING A TRIGGER GIVES ERROR UNRESOLVED SYMBOL
PQ98779
31_Jan
2005
UK00143


ADB2GEN GETS USER ABEND CODE 4038 REASON CODE 00000001 ON VIEW IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ98471
30_Jan
2005
UK00143


ALTER INDEX PANEL ADB21XA WILL NEITHER ACCEPT NOR DISPLAY SQTY VALUE LARGER THAN 6 DIGITS
PQ96972
27_Dec
2004
UK00063


ADMIN TOOL GEN LINE COMMAND GIVES ERRONEOUS ERROR MESSAGES FOR A VIEW
PQ96383
3_Dec
2004
UQ95846


COUNTER PART OF PQ96382 (I.E. RETRO-FIT OF PQ93863)
PQ95552
9_Nov
2004
UQ94878


ADMIN TOOL GEN LINE COMMAND GETS U4038 IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED IN ADB2GEN
PQ94400
28_Oct
2004
UQ94487


RESZ LINE COMMAND FAILS FROM PANEL ADB2M1S IF IN A PRIOR USE OF PANEL ADB2US THE GENERATE WORK STATEMENT LIST WAS SET TO Y
PQ94178
13_Oct
2004
UQ93990


ADMIN TOOL ADB21TXC PANEL DOES NOT FIND OR SORT COLUMNS OR INDEXES
PQ93644
13_Oct
2004
UQ93990


ADMIN TOOL BUILDING INVALID JCL WHEN USING TEMPLATES
PQ95047
13_Oct
2004
UQ93990


ALTER TABLESPACE WITH PARTITIONING INDEX TO ADD PARTITION DROPS SORT DIRECTION ( DESC ) FROM INDEX COLUMNS
PQ95107
13_Oct
2004
UQ93990


DISPLAY OF INDEXSPACE FAILS FROM PANEL ADB21SAC
PQ95275
12_Oct
2004
UQ93990


PANEL ADB21XA IGNORES UPDATED PARTITION VALUE(S) IF ENTER IS PRESSED WITHOUT SPECIFYING RDEF PRIMARY COMMAND.
PQ94792
5_Oct
2004
UQ93655


A FOLLOW-UP TO PQ91227
PQ94067
28_Sep
2004
UQ93374


ADMIN DDL AND GEN LINE COMMAND FOR A STORED PROCEDURE DOES NOT PRESERVE THE JARSCHEMA OR JAR_ID CATALOG VALUES
PQ92552
28_Sep
2004
UQ93374


GENERATED JOBS FAIL FOR UTILITIES. DDNAMES EXCEED 8 CHARACTERS, AND MORE THAN 255 STEPS ARE GENERATED PER JOB.
PQ93779
28_Sep
2004
UQ93374


ADMIN PANEL ADB2PSTM PANEL APPEARS WITH SET CURRENT SQLID WITH PROMPT ON AND RESET TO DEFAULT AT STARTUP NO ON ENTRY TO
ADMIN
PQ93383
14_Sep
2004
UQ92872


MSGISPT034 IN ADB2U RC0 WHEN ATTEMPTING REORG FROM PERFORMANCE QUERY PANEL ADB237 - ISPF DIALOG ERROR
PQ93617
9_Sep
2004
UQ92709


PARSER V5, MISSING SUPPORT FOR ALTER TABLE STATEMENT - DB2 V8 PARSER V4, UNRESOLVED SYMBOL FOR GRAPHICS IN ADB2GEN OUTPUT
PQ93703
9_Sep
2004
UQ92709


EXEC ADB222E FAILS WHEN OPTION 2.2 IS USED FOR AN INPUT DATASET WITH RECFM=V AND THE LENGTH OF A LINE IS 71.
PQ92279
9_Sep
2004
UQ92709


RUNNING OBJECT COMPARE WSL RESULTS IN ONCODE150 MESSAGE STRINGSZE CONDITION FROM ADB27AC
PQ93524
9_Sep
2004
UQ92709


AN ERROR IN INTERGER DIVISION OF SPACE CALCULATION FOR MIGRATION TABLE
PQ93672
9_Sep
2004
UQ92709


INVOKING SPACE ESTIMATOR FROM PANEL ADB21SA FAILS WITH PANEL ADB2MESG ERROR OR PANEL ADB2MEXG ERROR
PQ91226
7_Sep
2004
UQ92709


ADMIN TOOL ALTER COLUMN ADD COMMENT NOT ADDED WHEN COLUMN ALSO ADDED TO A VIEW
PQ91227
7_Sep
2004
UQ92709


PANEL ADB2ZZNM DOES NOT DISPLAY NEW DB2 V710 ZPARM UTLRSTRT
PQ92711
7_Sep
2004
UQ92709


MISSING QUOTATION MARKS ON TIMESTAMP IN A MULTI-COLUMN INDEX
PQ92805
7_Sep
2004
UQ92709


PANEL ADB27C OMITS ADDFK FROM COMMAND LIST AFTER UP COMMAND IS USED TO UPDATE PRIMARY KEY
PQ91997
25_Aug
2004
UQ92227


ADMIN TOOL IMPROPERLY GENS IMPLICIT AUXILIARY TABLE FOR A LOB COLUMN
PQ90855
25_Aug
2004
UQ92231


MISSING COLUMN IN PRIMARY KEY AFTER ALTER
PQ89586
17_Aug
2004
UQ91886


INCORRECT DDL GENERATED FOR CREATE TABLE WHEN CONSTRAINT NNN PRIMARY KEY SPANS ACROSS SEVERAL LINES
PQ84624
16_Aug
2004
UQ91882


ADMIN TOOL GEN LINE COMMAND GETS UNRESOLVED SYMBOL INDEX=0001 WHEN DONE ON VIEW DEFINED ON SYNONYM WITH DIFFERENT OWNERID
PQ87122
16_Aug
2004
UQ91882


ADMIN TOOL GEN AND DDL LINE COMMAND DOES NOT ALWAYS PRESERVE THETRIGGER OLD AND NEW TRANSITION QUALIFIERS
PQ91661
6_Aug
2004
UQ91886


ADMIN PANEL ADB2UT LX COMMAND PRODUCES WRONG SYSREC AND SYSIN DATA SET NAMES
PQ91717
6_Aug
2004
UQ91886


ADMIN PANEL ADB2EL SHOWS ALL VERSIONS OF A PACKAGE FOR AN LP LINE COMMAND
PQ90154
5_Aug
2004
UQ91439


PANEL ADB21I RETURNS ' NO ROWS MATCH ' WHEN USING PARTITION NUMBER IN THE SEARCH ARGUMENT AREA OF THE PANEL
PQ90674
5_Aug
2004
UQ91439


B37 ABENDS ENCOUNTERED DURING UNLOAD STEPS OF ALT TS OR REDF
PQ91163
5_Aug
2004
UQ91439


ADMIN TOOL CRE CREATE LIKE LINE COMMAND MISSING SOME DDL
PQ91579
5_Aug
2004
UQ91439


ADMIN TOOL PANEL ADB21SAR RESULTS IN SQLCODE -103
PQ91793
29_Jul
2004
UQ91439


ADMIN TOOL ADB21T VS LINE COMMAND LEAVES OUT OPEN PARENTHESIS )
PQ89605
19_Jul
2004
UQ90780


IFREQ FOR PQ89417 (DB2 OBJECT COMPARISON TOOL)
PQ88521
19_Jul
2004
UQ90780


SQLCODE644 FROM ALTER INDEX - PANEL ADB2M1AX GENERATES PART 0 IN THE ALTER FOR A NON-PARTITIONED INDEX
PQ88026
19_Jul
2004
UQ90780


INCORRECT ERROR MSG FROM ADB21TAB AND PRIQTY/SECQTY NOT IN CREATE INDEX STATEMENT
PQ89633
19_Jul
2004
UQ90780


PANEL ADB2ELIH FAILS TO DISPLAY PLANNO WHEN INSERTING OPTIMIZATION HINTS VIA SQL INSERT OR UPDATE
PQ88894
14_Jul
2004
UQ90655


ADMIN TOOL GEN OR DDL LINE COMMAND GETS IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED FOR ADB2PA
PQ88531
1_Jul
2004
UQ90285


MSGIGD17051I RESULTS FROM SPACE ALLOCATIONS EXCEEDING 65535 TRACKS
PQ89808
1_Jul
2004
UQ90325


MOVE LINE COMMAND TO MOVE A TABLESPACE FROM USER / VCAT DEFINED TO STOGROUP DEFINED CAN FAIL
PQ88390
1_Jul
2004
UQ90325


ADMIN TOOL PANEL ADB21K GRANT COMMAND RESULTS IN TOO MANY OBJECTS ERROR MESSAGE FOR MULTIPLE PACKAGE GRANTS
PQ87492
1_Jul
2004
UQ90325


ABEND0C4 DURING THE USE OF ISPF BROWSE FACILITY WHEN BROWSING SQL SELECTION OF DB2 CATALOG.
PQ88941
28_Jun
2004
UQ90121


ADMIN GEN OF STORED PROCEDURE SHOULD SHOW EXTERNAL NAME
PQ89750
28_Jun
2004
UQ90121


OBJECT COMPARE GETS AN ABEND S0C8
PQ89751
28_Jun
2004
UQ90121


ADMIN TOOL STORAGE MANAGER PANEL ADB2MES GETS SQLCODE802
PQ90437
23_Jun
2004
UQ89894


MSGIKJ56700A ENTER VALUE FOR KEYWORD CTAB
PQ82509
7_Jun
2004
UQ89310


ADMIN TOOL BUILDS UTILITY JOBS WITH SAME GROUP DB2 SQLID CAUSINGDSNU014I DSNUGASU JOB WITH DUPLICATE UTILID CURRENTLY
EXECUTING
PQ88395
7_Jun
2004
UQ89310


WHEN CLONING A WSL, AN "INVALID DATA SET NAME" MESSAGE IS ISSUED
PQ84368
27_May
2004
UQ88994


ADMIN ADB2GEN GETS USER ABEND CODE 4038 REASON CODE 00000001 IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ88946
27_May
2004
UQ88994


PANEL ADB2SYS DEFAULT CURSOR POSITION ON COMMAND LINE
PQ87964
27_May
2004
UQ88994


NO WARNING GIVEN WHEN ADDING NOT NULL COLUMN WITH NO DEFAULT TO THE MIDDLE OF A TABLE
PQ88675
27_May
2004
UQ88994


ADMIN PANEL ADB21SOR GIVES ERRONEOUS ERROR MESSAGE
PQ88710
20_May
2004
UQ88685


USER NAMES WERE CAPITALIZED BY PARSER
PQ88948
20_May
2004
UQ88683

HIPER

EXEC ADB222E FAILED WHEN OPTION 2.2 RAN WITH STATEMENTS WRAPPING AROUND TO THE THIRD LINE OR BEYOND
PQ87497
20_May
2004
UQ88685


ADMIN TOOL ALTER INDEX BUFFERPOOL FOR DATASHARING LEAVES A PLUS SIGN "+" IN THE DDL TEXT
PQ87947
20_May
2004
UQ88685


NO DEFAULT VALUE FOR AGE WHEN BOTH AGE AND DATE VALUES ARE NULL (SKELETON ADB2USM)
PQ88204
20_May
2004
UQ88685


ADMIN TOOL PANE ADB25LE ALLOWS FOR ONLY 99 LISTDEF INCLUDE OR EXCLUDE OBJECT SPECIFICATIONS
PQ88596
20_May
2004
UQ88685


SQLCODE -538 WHEN UPDATE PK/FK COLUMN VIA ALC-REL
PQ87448
20_May
2004
UQ88685


ADMIN PANEL ADB2ELIH IH AND UH LINE COMMANDS IGNORE THE PLANNO COLUMN FOR OPTIMIZER HINT UPDATES
PQ82821
13_May
2004
UQ88489


FOR MIXED=NO AND ENSCHEME=EBCDIC TABLE WITH UNICODE AND COLUMN WITH FOR MIXED DATA RESULTS IN FOR SBCS DATA WITH GEN COMMAND
PQ83316
13_May
2004
UQ88489


INCORRECT DDL GENERATED FROM A USER DEFINED FUNCTION WITH TABLE LIKE XXXXXX AS LOCATOR CLAUSE
PQ88571
13_May
2004
UQ88489


SQLCODE104 (-104) FROM A CREATE TABLE WITH A CHECK CONSTRAINT CLAUSE GREATER THAN 38 CHARACTERS (FINAL ")" IS OMITTED).
PQ86490
10_May
2004
UQ88489


REVOKE RESULTS IN SQLCODE104 (-104) WHEN PANEL ADB2RT PRE-FILLS FROM FIELD WITH 'PUBLIC A'
PQ86757
10_May
2004
UQ88489


ADMIN TOOL PANEL ADB21J SHOWS SAME NAMED TRIGGERS FROM OTHER DATABASES
PQ87387
7_May
2004
UQ88489


ADMIN TOOL ALTER COLUMN DECIMAL WITH A COMMA IN SPECIFICATION GETS SQLCODE104 DUE TO DECIMAL POINT IS COMMA IS DSNZPARM
PQ82871
5_May
2004
UQ88111


ALTER TABLE PUTS INVALID DATA IN CHECK CONSTRAINT IF PROMPT ON AND EDIT USED AND CONSTRAINT OVER ONE LINE
PQ86097
5_May
2004
UQ88111


OBJECT COMPARE CAN SHOW VIEW DIFFERENCES
PQ83286
5_May
2004
UQ88111


INCORRECT DDL GENERATED FOR A TABLE WITH A SPECIAL CHARACTER IN THE CONSTRAINT WHICH WILL CAUSE MSGDSNT408I AND SQLCODE104
PQ86275
5_May
2004
UQ88111


ADMIN TOOL GEN COMMAND FOR A STORED PROCEDURE DOES NOT INCLUDE THE PARAMETER STYLE LEADING TO SQLCODE628 -628
PQ78100
3_May
2004
UQ87998


INCORRECT DDL GENERATED FOR CREATE TABLE WHEN CONSTRAINT NNN PRIMARY KEY SPANS ACROSS SEVERAL LINES
PQ86730
3_May
2004
UQ87998


PANEL ADB2M1AS DISPLAYS INCORRECT SECONDARY ALLOCATION OF ZERO FOR TABLESPACES CREATED IN DB2 V5
PQ87609
3_May
2004
UQ87998


PANEL ADB2M1SI REPORTS SECONDARY QUANTITY 0 FOR DB2 R510, OR OLDER, OBJECTS WHERE SQTY > SECQTYI = 0.
PQ87514
3_May
2004
UQ87998


MISSING JOB CARD DURING ALC CHANGE CAUSING DROP/RECREATE WITH MULTIPLE JOBS USING HPU UNLOAD.
PQ87713
3_May
2004
UQ87998


ADMIN TOOL RECOVER TOCOPY LINE COMMAND IS MISSING UTILITY RECOVERY OPTIONS
PQ81945
2_May
2004
UQ87998


MSGADB252S IF DDF IS NOT ACTIVE, WHEN TRY TO USE DC OR DL SYSTEMADMINISTRATION COMMANDS
PQ81467
2_May
2004
UQ87998


MSGDSNU047I DSNURULD - A REQUIRED DD CARD OR TEMPLATE IS MISSINGNAME=SYSCOPY, WHEN ADMIN GENERATES INCORRECT JCL TO RUN REORG
PQ83872
28_Apr
2004
UQ87625


DB2 OBJECT COMPARE BATCH JOB FAILS WHEN TRIES TO REUSE THE IFF DATA SET CREATED BY DB2 ADMIN
PQ83873
28_Apr
2004
UQ87625


DB2 ADMIN BATCH JOB FAILS WHEN TRIES TO REUSE THE IFF DATA SET CREATED BY DB2 OBJECT COMPARE
PQ87857
27_Apr
2004
UQ87625


A FOLLOW-UP TO PQ83209
PQ87215
26_Apr
2004
UQ87772


IFREQ FOR PQ80689 - ADB2PA MODULE AFFECTED
PQ87104
22_Apr
2004
UQ87645


IBM INTERNALLY-FOUND PROBLEMS, SQLCODE -104
PQ83209
21_Apr
2004
UQ87625


ADMIN TOOL CALCULATES UNLOAD DATASET SIZE TOO SMALL FOR CERTAIN TABLESPACE STRUCTURES AND MAY LEAD TO ABENDSB37
PQ86811
21_Apr
2004
UQ87625


ALC OPERATION TO INSERT A NEW COLUMN ENDS WITH MSGISPT034 SYNTAXCONDITION RAISED RC40 IN ADB27A
PQ86389
21_Apr
2004
UQ87625


PROBLEMS WITH CHECKING FOR TRIGGERS WHEN RUNNING ALC ON A TABLE IN DB2 VERSION 5 SETTING.
PQ86343
15_Apr
2004
UQ87413


INDEX SPACE ESTIMATOR PANEL ADB2MEX DOES NOT PRE-FILL THE KEY LENGTH FIELD FROM PRIOR PANEL KEY DEFINITION(S)
PQ81791
14_Apr
2004
UQ87645


DB2 ADMIN ALC COMMAND IN BATCH ON ANY COLUMN ON THE TABLE CHANGES IDENTITY COLUMN FROM ALWAYS TO BY DEFAULT
PQ83708
14_Apr
2004
UQ87645


IN PANEL ADB21 LOWER CASE LETTERS IN SQL CAUSE SQLCODE206 -206 WHEN RUN IN JAPANESE KATAKANA ENVIRONMENT
PQ84064
14_Apr
2004
UQ87645


INCOMPLETE LISTS OF PLAN PACKAGES CREATED FROM SEVERAL PANELS
PQ85937
14_Apr
2004
UQ87645


DATABASE FIELD IS NOT POPULATED IN PANEL ADB2GS FROM PRIOR PANEL ADB2AUD FOR GR ( GRANT ) LINE COMMAND
PQ86759
14_Apr
2004
UQ87645


ADMIN TOOL PANEL ADB2PSTM EDIT ON A BIND STATEMENT CAUSES DB2 MESSAGE DSNE931E - INVALID SYMBOL
PQ85315
14_Apr
2004
UQ87645


LOWER CASE LETTER SQL IN KATAKANA ENVIRONMENT CAUSES SQLCODE206
PQ86344
14_Apr
2004
UQ87413


ADMIN TOOL SCHEMA FROM GEN LINE COMMAND DOES NOT RESET AFTER END OF FUNCTION AND PERSISTS IN OTHER LINE COMMANDS
PQ81470
8_Apr
2004
UQ87224


INVOKING ADMIN FAILS WHEN USING ADBL CLIST WITH THE SHOW PARAMETER
PQ86271
7_Apr
2004
UQ87224


IFREQ REQUIREMENT FOR DB2 OBJECT COMPARISON TOOL APAR PQ78322 AND PQ80530
PQ83404
5_Apr
2004
UQ87224


INCORRECT TRIGGER DDL GENERATED BY DB2 ADMIN
PQ84781
5_Apr
2004
UQ87224


IFREQ APAR FOR DB2 OBJECT COMPARISON TOOL APAR PQ84430
PQ87046
5_Apr
2004
UQ86885


INTERNALLY-FOUND PROBLEM RELATED TO PANEL ADB2USO1
PQ84354
4_Apr
2004
UQ87645


PANEL ADB21XRH AND ADB21XI1 SHOW INCORRECT VALUE FOR AN INDEX CLUSTERRATIO FROM SYSINDEXES_HIST TABLE
PQ86384
4_Apr
2004
UQ87413


ADMIN TOOL ADB2UT PANEL WITH LO (LOAD STAND ALONE) OPTION FLAGS WRONG FIELDS THAT ARE IN ERROR
PQ84119
1_Apr
2004
UQ87224


PANEL ADB21XPH INDEX PART HISTORY INCORRECTLY SHOWS CARD VALUE FROM SYSINDEXPART WITH SYSINDEXPART_HIST CARDF VALUE
PQ85198
1_Apr
2004
UQ87224


PANEL ADB21XPI DISPLAYS INCORRECT SECONDARY ALLOCATION OF ZERO FOR INDEXES CREATED IN DB2 V5
PQ86188
1_Apr
2004
UQ87224


ADMIN TOOL ALTER COLUMN ON A PARTITIONED TABLESPACE AND ADDING THE SAME COLUMN TO INDEX IN WORK STATEMENT LIST GETS
SQLCODE667
PQ86422
1_Apr
2004
UQ87224


ADMIN TOOL ALC (ALTER COLUMN) LINE COMMAND WHEN USING A RUN SQLID OF <NONE> NONE CAN CAUSE ERROR IN WORK STATEMENT LIST
PQ86295
31_Mar
2004
UQ86885


A PANEL NAVIGATION PROBLEM, PANEL ADB2USOO NOT ACCESSABLE
PQ79223
31_Mar
2004
UQ86885


ADMIN PANEL ADB2US UTILITY WHEN REVIEW/MODIFY YES SPECIFIED IT CAUSES ERRORS IN THE REORG STATEMENT GENERATION AND PROCEDURE
PQ81798
31_Mar
2004
UQ86885


DB2 ADMIN PROHIBITS TO CHOOSE LOG NO AND SHRLEVEL NONE WITH OC - REORG W/INLINE COPY
PQ85135
31_Mar
2004
UQ86885


ADMIN PANEL ADB2USV GIVES INVALID DSN - LENGTH MESSAGE FOR A DB2COPY DATA SET 44 CHARACTERS LONG
PQ85209
31_Mar
2004
UQ86885


INCORRECT TABLESPACE PARTITION NUMBER TO BE USED FOR UTILITY EXECUTION IS DISPLAYED IN MESSAGE ON PANEL ADB2US
PQ86310
24_Mar
2004
UQ86596


MESSAGE ADBC200E ISSUED FROM ADB27AC WHEN RUNNING OBJECT COMPAREAND DELETING COLUMNS THAT ARE PART OF THE PRIMARY KEY
PQ85244
15_Mar
2004
UQ86164


SQLCODE107 AND MSGDSNT408I FROM PANELS ADB21TAK OR ADB21TAN IF CONSTRAINT NAME EXCEEDS DB2 MAXIMUM SIZE OF 18 CHARACTERS
PQ79088
15_Mar
2004
UQ86164


PANEL ADB21OSR RETURNS ISPF DIALOG ERROR WHEN INVALID COMMAND IS ENTERED
PQ83637
15_Mar
2004
UQ86164


E COMMAND IN PANEL ADB25LE RESULTS IN SQLCODE104 WHEN COMMA IS DEFINED AS DECIMAL POINT
PQ84131
15_Mar
2004
UQ86164


OBJECT COMPARE FAILS WHEN PARSING COLUMN WITH NAME OF PRIMARY
PQ84446
15_Mar
2004
UQ86164


ADMIN TOOL ALC PANEL ADB27CR FAILS WITH IBM0361W ONCODE=350 STRINGRANGE CONDITION WAS RAISED FROM COMPILE UNIT ADB27AC
PQ85025
15_Mar
2004
UQ86164


SQLCODE104 FROM PANEL ADB2314T USING OPTION 3.14 WHEN COMMAS AREDEFINED AS DECIMALS
PQ82969
15_Mar
2004
UQ86164


MISSING QUOTATION MARKS ON TIMESTAMP IN A MULTI-COLUMN INDEX
PQ83077
15_Mar
2004
UQ86164


ADB2W1Q CLONE PANEL GETS ISPF ERROR RC=0, WRITE/NOWRITE CONFLICTTBOPEN FOR TABLE SPECIFIES CONFLICTING WRITE/NOWRITE OPTION
PQ83144
15_Mar
2004
UQ86164


ADB2CUST EXEC FAILS WITH SYNTAX ERROR WHEN EXECUTING THE VARIABLE BLOCK ( VB ) VERSION
PQ83145
15_Mar
2004
UQ86164


ALLOCATION FAILED FOR ALLOC DA(WORKLIST) NEW CATALOG LRECL(80)..DUE TO WRONG TSO PREFIX FOR WORKLIST DATA SET CLONE IN ADMIN
PQ83463
27_Feb
2004
UQ85810


MSGDSN9015I - -DCMP PARAMETER 'S' IS UNACCEPTABLE FOR KEYWORD 'DEST' WHEN DB2 ADMIN STARTS DB2 TRACE WITH DEST(S)
PQ84296
26_Feb
2004
UQ85810


GARBAGE CHARACTER AT BOTTOM OF PANEL ADB2 AFTER USING GR LINE COMMAND ON TABLE AND PF3 BACK TO MAINT PANEL
PQ82110
25_Feb
2004
UQ85810


ISPF ZERRMSG : ADB252S AND ZERRLM : PROGRAM IS STOPPED DUE TOAN INTERNAL ERROR, ONCODE=9050 WHEN CAN DB2 THREAD ON
ADB2Z2D2
PQ81746
18_Feb
2004
UQ85268


IBM INTERNALLY FOUND PROBLEMS - TRANSLATE FUNCTION WITH MORE THAN 126 PAIRS OF VALUES
PQ82510
18_Feb
2004
UQ85268


SM ALTER ON PARTITION INDEX OMITS PART CLAUSE ON ALTER
PQ83354
18_Feb
2004
UQ85268


PANEL ADB21SP DISPLAYS 32767 FOR SECONDARY SPACE ALLOCATION INSTEAD OF USING SECQTYI COLUMN FOR CORRECT VALUE
PQ83947
18_Feb
2004
UQ85268


CREATE TABLE PROCESS INCLUDES THE ' WITH DEFAULT ' CLAUSE EVEN THOUGH DEFAULT N WAS SPECIFIED FOR A NOT NULL COLUMN
PQ82861
18_Feb
2004
UQ85268


IBM INTERNAL APAR - SEE PROBLEM DESCRIPTION IN THE CLOSING TEXT
PQ83497
18_Feb
2004
UQ85268


ADMIN PANEL ADB27C ALTER COLUMN MAY NOT DISPLAY RELATED OBJECT INFORMATION MESSAGE THAT RELATED OBJECTS MAY REQUIRE UPDATE
PQ81724
18_Feb
2004
UQ85268


IBM INTERNAL APAR - SEE PROBLEM DESCRIPTION IN CLOSING TEXT.
PQ83265
12_Feb
2004
UQ85126

HIPER

ADBTEP2 CAN GIVE WRONG OUTPUT WHEN RUN ON SYSTEMS WITH CCSID OTHER 37
PQ82985
12_Feb
2004
UQ85126


ADBTEP2 GETS MESSAGE DSN9001I #DSN7- KEYWORD 'PARM' IS INVALID
PQ81224
28_Dec
2003
UQ84033


INCORRECT CONTROL CARDS ARE GENERATED AFTER AL/RDEF ADDING A PARTITION, AND REQUESTING AN IMAGE COPY
PQ82112
28_Dec
2003
UQ84033


INDEX SPACE NAME IS INCORRECT ON PANEL ADB21XS WHEN RTS LINE COMMAND WAS ISSUED ON PANEL ADB21X
PQ78614
27_Dec
2003
UQ84037


ADMIN TOOL GIVES CATALOG ROW STACK FULL RUN WILL TERMINATE MESSAGE WITH LARGE INPUT
PQ79192
27_Dec
2003
UQ84004


PQ79192 IS AN IFREQ FOR PQ79629 (QUALIFIER MIS-COMPARED ON TRIGGER WHEN TARGET DDL FROM CATALOG DIDN'T SHOW QUALIFIER).
PQ81476
27_Dec
2003
UQ84037


ADMIN REBIND OF PACKAGE OR PLAN ACCEPTS VALUE OF 0 (ZERO) FOR CCSID ENCODING SCHEME IT SHOULD USE DSNHDECP DEFAULT LIKE
SPUFI
PQ80161
27_Dec
2003
UQ84033


USING PANEL ADB21G OPTION S DUPLICATE ROWS ARE DISPLAYED ON PANEL ADB21S FOR PARTITIONED TABLESPACES
PQ80626
27_Dec
2003
UQ84033


TYPO ON ADB2Z2D PANEL. SHOULD BE TSO INSTEAD OF BATCH IN THE: CONNECTION NAME ==> (NAME OR *, DEFAULT IS ......
PQ74680
26_Dec
2003
UQ84037


GEN LINE COMMAND ON A TABLE WHICH USES A TRIGGER RESULTS IN A LOOP
PQ81477
26_Dec
2003
UQ84033


ALC CREATES INVALID LOAD CONTROL CARDS RESULTING IN ABENDS043 RC00E40323
PQ77423
24_Dec
2003
UQ84032


SQLCODE -626 FOR ALTER BUFFERPOOL IN DATA SHARING
PQ79732
24_Dec
2003
UQ84032


ALTER INDEX USING THE ALL PARTS LINE FAILS WITH LARGE NUMBER OF PARTITIONS
PQ78011
16_Dec
2003
UQ83229


MSGDSNU062I ATTEMPTING TO RUN RUNSTATS ON TEMP OBJECT FROM PERFORMANCE QUERY 3.1 - TABLESPACES WITHOUT RUNSTATS
INFORMATION
PQ80259
16_Dec
2003
UQ83229


INCORRECT JCL GETS GENERATED WHEN REORG IS CHOSEN, PANEL ADB233,ON THE PARTITIONED INDEXES WITH CLUSTERING
PQ80978
16_Dec
2003
UQ83229


PANEL ADB21SP DISPLAYS 32767 FOR SECONDARY SPACE ALLOCATION INSTEAD OF USING SECQTYI COLUMN FOR CORRECT VALUE
PQ78167
15_Dec
2003
UQ83148


PANEL ADB21K PL LINE COMMAND THE LIST OF PLAN PACKAGES DISPLAYEDADB21PL IS INCOMPLETE
PQ78014
15_Dec
2003
UQ83148


REBINDALL FAILS WITH ISPF DIALOG ERROR ISPV023 WHEN ATTEMPTING TO REBIND A LARGE NUMBER OF PACKAGES
PQ80607
15_Dec
2003
UQ83148


PL AND P LINE COMMANDS ON PANEL ADB21L SHOULD DISPLAY * LOCATIONS IN ADDITION TO " " ONES
PQ79041
13_Dec
2003
UQ83104


ADMIN TOOL DOES NOT IDENTIFY DATASETS THAT ARE HSM MIGRATED AND DOES NOT PROVIDE MEANINGFUL MESSAGE
PQ81391
13_Dec
2003
UQ83104


DB2 ADMIN DOES NOT RECALL HMIG OUTPUT DATA SETS WHEN GEN REQUESTED
PQ80914
13_Dec
2003
UQ83102


ISPF ZERRMSG : ADB252S AND ZERRLM : PROGRAM IS STOPPED DUE TOAN INTERNAL ERROR, ONCODE=8094 WITH LONG VARCHAR IN THE TABLE
PQ80397
13_Dec
2003
UQ83102

HIPER

PF3 FROM ADB2PSTM PANEL WHILE USING SQLID COMMAND RESULTS IN A REVISIT TO THE ADB2PSTM PANEL
PQ81242
13_Dec
2003
UQ83104


TWO ERROR CASES: DB2 COMMANDS TERMINATED WITH SEMICOLON, AND AN INVALID ALTER TABLE STATEMENT.
PQ81806
12_Dec
2003
UQ83091


ADMIN TOOL ALLOWS GENERATION OF COPY INDEX UTILITY EVEN IF COPY FLAG ON INDEX IS SET TO NO
PQ79432
11_Dec
2003
UQ83061


ADMIN TOOL ADB2GEN GETS PARSING ERROR DURING MIGRATION ON A VIEWADB2GEN - ENDED NORMALLY TOKEN NUMBER = 0326, TOKEN =A
PQ81265
11_Dec
2003
UQ83061


ADMIN ADB2GEN HAS PARSING ERRORS ON VIEWS AND MAY HANG DURING TRIGGER GENERATION TOKEN NUMBER = 0218, TOKEN =AS
PQ81284
11_Dec
2003
UQ83061


VIEW QUALIFIER INVALID DURING COMPARE PROCESS, WHEN OPTION <NONE> IN USE TO SUPPRESS SET SQLID STATEMENTS.
PQ78957
8_Dec
2003
UQ82917


ADMIN TOOL TABLE OWNER FIELD IN PANEL ID ADB21TAN IS TOO SHORT IT IS 7 CHARACTERS WHEN IT SHOULD BE 8
PQ78805
8_Dec
2003
UQ82917


ADMIN PANEL ADB21SAR FORCES ENTRY OF STOGROUP WHEN VCAT STORAGE METHOD SPECIFIED NUMPARTS AND SEGSIZE WITH AL AND RDEF
PQ79490
8_Dec
2003
UQ82917


SECURITY VIOLATION ALLOCATING DATASET FOR ZPARMS DISPLAY USING ADMIN OPTION 2Z AND TSO PROFILE NOPREFIX
PQ80268
8_Dec
2003
UQ82917


INCORRECT DDL GENERATED WITH CRET ON PANEL ADB21T AND NOCACHE ENTERED ON PANEL ADB26CTQ
PQ79150
8_Dec
2003
UQ82917


CREATE TABLE PROCESS OMITS THE ' WITH DEFAULT ' CLAUSE EVEN THOUGH DEFAULT Y WAS SPECIFIED FOR A NOT NULL COLUMN
PQ79557
8_Dec
2003
UQ82917


CRE COMMAND CREATES INVALID DDL IF EXISTING TABLE WAS DEFINED WITH DATA CAPTURE CHANGES
PQ79959
3_Dec
2003
UQ82809


TWO OPTIONS ON ADMIN MAIN MENU ADB2 FOR INTERFACE TO OTHER DB2 PRODUCTS AND OFFERINGS ARE OVERWRITTEN BY PANEL ADB21TSE
PQ80730
3_Dec
2003
UQ82809


CREV LINE COMMAND ON PANEL ADB21T CAN RESULT IN A VIEW THAT CONTAINS INVALID CHARACTERS X'4D15'
PQ80652
3_Dec
2003
UQ82809


PANEL ADB27A WHEN TEMPLATE USAGE SPECIFIED THE TEMPLATE DDNAME MAY APPEAR FOR THE WRONG UTILITY
PQ80899
3_Dec
2003
UQ82809


AL ON A TABLE MISTAKENLY PERMITS A NOT NULL COLUMNWHEN N FOR "ALLOW NULLS" WAS CHOSEN
PQ79372
2_Dec
2003
UQ82749


VOLCNT IS NOT GENERATED IN UTILITY TEMPLATE NOR IN JCL BUILT USING THE TEMPLATE
PQ81463
2_Dec
2003
UQ82743

HIPER

PANEL ADB21K RETURNS NO ROWS ON VERSION COLUMN
PQ76947
30_Nov
2003
UQ82651


SQ LINE COMMAND FOR A TRIGGER PACKAGE FAILS WITH SYNTAX ERROR 40 IN ADB21KSQ. IN ADDITION, PK/FK RELATED ISSUES ARE ADDED.
PQ80933
30_Nov
2003
UQ82653


PQ80933 ADDRESSES THE DB2 ADMIN TOOL SIDE OF THE PROBLEM REPORTED BY DB2 OBJECT COMPARISON TOOL APAR PQ78913
PQ79839
20_Nov
2003
UQ82387


FOR THE BROWSE LINE COMMAND ON PANEL ADB2BRIF AND ADB2DF THE DB2TABLE NAME DOES NOT APPEAR ON THE BROWSE SCREEN
PQ80384
15_Nov
2003
UQ82228


SHOW VERSION COLUMN WITH PACKAGES IN PANEL ADB21K
PQ80394
15_Nov
2003
UQ82228


ALLOW IN OPERATOR AND LIST OF VALUES FOR PANEL ADB21.
PQ80395
15_Nov
2003
UQ82228


DISPLAY COLLECTIONS EVEN IF THE PACKAGE COUNT IS ZERO
PQ79018
14_Nov
2003
UQ82184


ISSUES IN MIG, RELATED TO COMMENTS, JOB STEP NAMES, DATASET CLEAUP WERE REPORTED.
PQ80231
12_Nov
2003
UQ82100


A POP-UP WINDOW APPEARED IN PANEL ADB28M WHEN IT SHOULD NOT.
PQ80005
12_Nov
2003
UQ82109


ADMIN ALC WITH R REPEAT LINE COMMAND WITH NO CHANGE TO COLUMN NAME CAUSES MESSAGE ' DUPLICATE COLUMNS ' IN PANEL ADB27C
PQ78995
10_Nov
2003
UQ81995


SMART ALTER FOR TABLES WITH FOREIGN KEYS HAS PROBLEMS
PQ80045
9_Nov
2003
UQ81992


GEN PRODUCES WRONG GRANT FOR A GLOBAL TEMPORARY TABLE SHOULD USEGRANT ALL PRIVILEGES
PQ79699
7_Nov
2003
UQ81945


OBJECT COMPARE ALTER OF BUFFERPOOL, USING, PRIQTY, SECQTY, ERASEGBPCACHE ON OBJECT SHOULD ISSUE -STOP ON OBJECT
PQ79045
6_Nov
2003
UQ81920


VOLUME COMMAND MISSING FROM ADMIN
PQ79944
5_Nov
2003
UQ81862


DROP RESTRICT ON DROP HELP TEXT
PQ77660
30_Oct
2003
UQ81674


NEW FUNCTION HPU PHASE II
PQ79828
28_Oct
2003
UQ81575


QUALIFIERS TOO LONG MESSAGE FROM PANEL ADB21SAJ WHEN PROCESSING A LONG INDEX NAME
PQ78445
27_Oct
2003
UQ81474


NEW FUNCTION: ABILITY TO NOT GENERATE SET SQLID STATEMENTS
PQ77806
12_Oct
2003
UQ81032


AN IBM INTERNALLY FOUND PROBLEM, THE FORWARD-FIT OF PQ72846 TO V420, AND CODE PREREQUISITE FOR GOC PQ78224
PQ78993
8_Oct
2003
UQ80943


SOS SHORT ON STORAGE - CAN OCCUR USING GEN AS PRIMARY COMMAND, WITH MASKING , IN PANEL ADB21D. ABENDU4088 RC03EC RC3EC
PQ78893
8_Oct
2003
UQ80935


INCORRECT INFORMATION WAS RETURNED WHEN LINE COMMAND "T" WAS ISSUED FOR A ALIAS DEFINED ON TABEL IN A REMOTE DB2
PQ79005
8_Oct
2003
UQ80936


TRIGGERS ARE NOT RECREATED WHEN CHANGING TABLESPACE TYPE FROM SEGMENTED TO PARTITIONED
PQ78342
3_Oct
2003
UQ80848


ADMIN GEN COMMAND FOR VIEW DOES NOT SPECIFY NEW OWNER OR USE A MASK FOR NEW OWNER CORRECTLY OR COMPLETELY
PQ77729
2_Oct
2003
UQ80793


MIG COMMAND RESULTS IN -1 FOR KB ALLOCATED AND KB USED SPACE ALLOCATIONS IN PANEL ADB28S FOR J PREFIX DATASETS
PQ78615
2_Oct
2003
UQ80793


ADMIN PANEL ADB2UT OPTION UX PRODUCES INCORRECT REORG UNLOAD ONLY STATEMENT WHEN MULTIPLE TABLES ARE USED
PQ75484
27_Sep
2003
UQ80633


UNRESOLVED SYMBOL = COUNT REPORTED BY GEN AND DDL COMMANDS WHEN A VIEW CONTAINS COUNT(*) AS TOT IN A SUB-SELECT
PQ78047
27_Sep
2003
UQ80633


ERROR "FUNCTION : ADB2U, LINE 846: SPC = PGSIZE*NACTIV" WHEN UT/VC/RT WAS ISSUED AGAINST A TABLESPACE/TABLE WITH CLOB
PQ77888
15_Sep
2003
UQ80163


PROVIDE SYSNONYM MASKING FOR WORK STATEMENT LIST (WSL) CLONING
PQ78237
15_Sep
2003
UQ80190


NO ROWS RETURNED USING RTS ( REAL TIME STATISTICS ) LINE COMMAND IN PANEL ADB21X
PQ77771
15_Sep
2003
UQ80163


ABEND0C8 FIXED POINT OVERFLOW EXCEPTION RC8 WITH ONCODE340 SIZE CONDITION RAISED .
PQ77808
15_Sep
2003
UQ80190


RTS COMMAND IN PANEL ADB21X RESULTS IN SQLCODE104 WHEN COMMA IS DEFINED AS DECIMAL POINT
PQ77955
15_Sep
2003
UQ80161


MIGRATE JOB FAILS WITH U4091 '0B' IN CONVERT STEP WHEN MORE THAN 19 TABLES ARE BEING MIGRATED
PQ78131
15_Sep
2003
UQ80161


PANEL ADB2M1S DISPLAYS -1 FOR KB ALLOCATED AND FOR PCT USED COLUMNS WHEN TABLESPACE SIZE APPROACHES 4G
PQ77545
15_Sep
2003
UQ80158


DB2 ADMIN GENERATES DROP TABLE WHEN USER DELETES COLUMN FROM PRIMARY KEY AND THE INDEX
PQ78175
15_Sep
2003
UQ80159


SSID-SPECIFIC PROFILE VARIABLE ENHANCEMENT
PQ77493
15_Sep
2003
UQ80158


A NEW FUNCTION TO BE DESCRIBED LATER
PQ77761
12_Sep
2003
UQ80159


ABENDU4088 OUT OF STACK STORAGE WHEN PROCESSING MANY SQL STATEMENTS FROM DB2ACMD
PQ77843
4_Sep
2003
UQ79920


SPACE ALLOCATION ISSUE FOR UTILITY JOB WHEN USING WORK STATEMENTLIST AND TEMPLATES FOR SYSREC IN ADMIN
PQ75486
4_Sep
2003
UQ79920


HPU SUPPORT IN ADMIN
PQ77758
4_Sep
2003
UQ79920


MSGADBC186E FROM ADB27AC DURING ALC FOR DROP OF A COLUMN IN A TABLE WITH A FOREIGN KEY
PQ75730
3_Sep
2003
UQ79920


IBM NEW FUNCTION: SSID SPECIFIC PROFILE VARIABLES
PQ76007
25_Aug
2003
UQ79652


FOR LINE COMMANDS THE ADMIN TOOL INTERMITTENTLY ADDS SEMICOLONS TO END OF SQL STATEMENT RESULTING IN SQLCODE098
PQ76855
24_Aug
2003
UQ79652


ALIAS FOR REMOTE SYSTEM DISPLAYED, WHEN USING ALIAS LINE COMMANDON LOCAL TABLE NAME
PQ77658
21_Aug
2003
UQ79652


ADBTEP2 RETURNS A RC 303 ( REPORTED IN 5697G6400 )
PQ76951
15_Aug
2003
UQ79456


DDL STACK FULL - GENERATED DDL INCOMPLETE
PQ75777
7_Aug
2003
UQ79263


CREATE INDEX PANEL ABD21XAS FORCES USER TO ENTER PCTFREE FREEPAGE GBPCACHE VALUES INSTEAD OF USING DEFAULT
PQ76267
5_Aug
2003
UQ79187


DDL AND GEN LINE COMMAND IN ADMIN TOOL DOES NOT PRODUCE THE EXTERNAL NAME FOR LANGUAGE SQL TYPE STORED PROCEDURE
PQ75456
5_Aug
2003
UQ79173


THREE PROBLEMS: ONCODE=350 WHEN RUNNING A WORKLIST JOB, ADBTEP2 FAILED TO STOP FOR NEGATIVE RC, COMMAS AS DECIMALS
PQ76240
5_Aug
2003
UQ79187


GEN CREATES A COMMENT WHICH IS NOT PRECEDED BY HYPHENS
PQ74242
3_Aug
2003
UQ79135


UR LINE COMMAND DID NOT DISPLAY CLUSTERRATIO INFORMATION
PQ76445
28_Jul
2003
UQ78931


PANEL ID ADB2ZZMN SYSTEM PARAMETERS HAS AUTOBIND AND WORKLOAD MANAGER FIELDS IN ERROR
PQ76656
28_Jul
2003
UQ78934


PANEL ADB26CTF DOES NOT ALLOW A VALUE OF 255 FOR THE SIZE OF A CHARACTER COLUMN
PQ76329
18_Jul
2003
UQ78710


RTS LINE COMMAND FOR A TABLESPACE RESULTS IN SQLCODE104
PQ74847
9_Jul
2003
UQ78380


CONNECTION TO DISTRIBUTED SYSTEM FAILS WITH SQLCODE863
PQ75210
9_Jul
2003
UQ78380


PANEL ADB21S ALWAYS RETURNS TO ROW ONE AFTER PF3 FROM ANY LINE COMMAND DISPLAY
PQ74659
3_Jul
2003
UQ78264


CLONED WSL FAILS WITH RC8 WHEN RUNNING UNLOAD UTILITY
PQ73812
17_Jun
2003
UQ77769

HIPER

AN APAR FOR IBM INTERNALLY FOUND PROBLEMS
PQ73505
2_May
2003
UQ76592

HIPER

ROLL-UP APAR FOR DB2 ADMIN TOOL V420 GA

Top of page