DB2 Administration Tool Version 4.2

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: 9 May 2023

APAR	CLOSE DATE	PTF(s)	HIPER?	Abstract
DB2 Administration Tool Version 4.2
PK04889	25_May 2005	UK03837		OBJECT COMPARE GOC2CMP IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ95962	31_Jan 2005	UK00142		IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED FROMCOMPILE UNIT ADB2FMT FROM ADB2GEN
PQ97074	31_Jan 2005	UK00142		ADMIN ALTER COLUMN INVOLVING A TRIGGER GIVES ERROR UNRESOLVED SYMBOL
PQ98779	31_Jan 2005	UK00142		ADB2GEN GETS USER ABEND CODE 4038 REASON CODE 00000001 ON VIEW IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ96972	27_Dec 2004	UK00062		ADMIN TOOL GEN LINE COMMAND GIVES ERRONEOUS ERROR MESSAGES FOR A VIEW
PQ96383	3_Dec 2004	UQ95845		COUNTER PART OF PQ96382 (I.E. RETRO-FIT OF PQ93863)
PQ95552	9_Nov 2004	UQ94877		ADMIN TOOL GEN LINE COMMAND GETS U4038 IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED IN ADB2GEN
PQ94178	13_Oct 2004	UQ93989		ADMIN TOOL ADB21TXC PANEL DOES NOT FIND OR SORT COLUMNS OR INDEXES
PQ95275	12_Oct 2004	UQ93989		PANEL ADB21XA IGNORES UPDATED PARTITION VALUE(S) IF ENTER IS PRESSED WITHOUT SPECIFYING RDEF PRIMARY COMMAND.
PQ94067	28_Sep 2004	UQ93373		ADMIN DDL AND GEN LINE COMMAND FOR A STORED PROCEDURE DOES NOT PRESERVE THE JARSCHEMA OR JAR_ID CATALOG VALUES
PQ93617	9_Sep 2004	UQ92708		PARSER V5, MISSING SUPPORT FOR ALTER TABLE STATEMENT - DB2 V8 PARSER V4, UNRESOLVED SYMBOL FOR GRAPHICS IN ADB2GEN OUTPUT
PQ93703	9_Sep 2004	UQ92708		EXEC ADB222E FAILS WHEN OPTION 2.2 IS USED FOR AN INPUT DATASET WITH RECFM=V AND THE LENGTH OF A LINE IS 71.
PQ91997	25_Aug 2004	UQ92226		ADMIN TOOL IMPROPERLY GENS IMPLICIT AUXILIARY TABLE FOR A LOB COLUMN
PQ89586	17_Aug 2004	UQ91885		INCORRECT DDL GENERATED FOR CREATE TABLE WHEN CONSTRAINT NNN PRIMARY KEY SPANS ACROSS SEVERAL LINES
PQ84624	16_Aug 2004	UQ91881		ADMIN TOOL GEN LINE COMMAND GETS UNRESOLVED SYMBOL INDEX=0001 WHEN DONE ON VIEW DEFINED ON SYNONYM WITH DIFFERENT OWNERID
PQ87122	16_Aug 2004	UQ91881		ADMIN TOOL GEN AND DDL LINE COMMAND DOES NOT ALWAYS PRESERVE THETRIGGER OLD AND NEW TRANSITION QUALIFIERS
PQ91781	29_Jul 2004	UQ91438		PQ87492 RETROFIT IN ADB410
PQ89605	19_Jul 2004	UQ90779		IFREQ FOR PQ89417 (DB2 OBJECT COMPARISON TOOL)
PQ88521	19_Jul 2004	UQ90779		SQLCODE644 FROM ALTER INDEX - PANEL ADB2M1AX GENERATES PART 0 IN THE ALTER FOR A NON-PARTITIONED INDEX
PQ88894	14_Jul 2004	UQ90657		ADMIN TOOL GEN OR DDL LINE COMMAND GETS IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED FOR ADB2PA
PQ88531	1_Jul 2004	UQ90284		MSGIGD17051I RESULTS FROM SPACE ALLOCATIONS EXCEEDING 65535 TRACKS
PQ89808	1_Jul 2004	UQ90324		MOVE LINE COMMAND TO MOVE A TABLESPACE FROM USER / VCAT DEFINED TO STOGROUP DEFINED CAN FAIL
PQ88941	28_Jun 2004	UQ90120		ADMIN GEN OF STORED PROCEDURE SHOULD SHOW EXTERNAL NAME
PQ89750	28_Jun 2004	UQ90120		OBJECT COMPARE GETS AN ABEND S0C8
PQ84368	27_May 2004	UQ88993		ADMIN ADB2GEN GETS USER ABEND CODE 4038 REASON CODE 00000001 IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ88946	27_May 2004	UQ88993		PANEL ADB2SYS DEFAULT CURSOR POSITION ON COMMAND LINE
PQ88710	20_May 2004	UQ88684		USER NAMES WERE CAPITALIZED BY PARSER
PQ88948	20_May 2004	UQ88682	HIPER	EXEC ADB222E FAILED WHEN OPTION 2.2 RAN WITH STATEMENTS WRAPPING AROUND TO THE THIRD LINE OR BEYOND
PQ82821	13_May 2004	UQ88488		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	UQ88488		INCORRECT DDL GENERATED FROM A USER DEFINED FUNCTION WITH TABLE LIKE XXXXXX AS LOCATOR CLAUSE
PQ88571	13_May 2004	UQ88488		SQLCODE104 (-104) FROM A CREATE TABLE WITH A CHECK CONSTRAINT CLAUSE GREATER THAN 38 CHARACTERS (FINAL ")" IS OMITTED).
PQ87387	7_May 2004	UQ88488		ADMIN TOOL ALTER COLUMN DECIMAL WITH A COMMA IN SPECIFICATION GETS SQLCODE104 DUE TO DECIMAL POINT IS COMMA IS DSNZPARM
PQ82871	5_May 2004	UQ88110		ALTER TABLE PUTS INVALID DATA IN CHECK CONSTRAINT IF PROMPT ON AND EDIT USED AND CONSTRAINT OVER ONE LINE
PQ86097	5_May 2004	UQ88110		OBJECT COMPARE CAN SHOW VIEW DIFFERENCES
PQ83286	5_May 2004	UQ88110		INCORRECT DDL GENERATED FOR A TABLE WITH A SPECIAL CHARACTER IN THE CONSTRAINT WHICH WILL CAUSE MSGDSNT408I AND SQLCODE104
PQ86275	5_May 2004	UQ88110		ADMIN TOOL GEN COMMAND FOR A STORED PROCEDURE DOES NOT INCLUDE THE PARAMETER STYLE LEADING TO SQLCODE628 -628
PQ78100	3_May 2004	UQ87997		INCORRECT DDL GENERATED FOR CREATE TABLE WHEN CONSTRAINT NNN PRIMARY KEY SPANS ACROSS SEVERAL LINES
PQ86730	3_May 2004	UQ87997		PANEL ADB2M1AS DISPLAYS INCORRECT SECONDARY ALLOCATION OF ZERO FOR TABLESPACES CREATED IN DB2 V5
PQ87609	3_May 2004	UQ87997		PANEL ADB2M1SI REPORTS SECONDARY QUANTITY 0 FOR DB2 R510, OR OLDER, OBJECTS WHERE SQTY > SECQTYI = 0.
PQ81945	2_May 2004	UQ87997		MSGADB252S IF DDF IS NOT ACTIVE, WHEN TRY TO USE DC OR DL SYSTEMADMINISTRATION COMMANDS
PQ87215	26_Apr 2004	UQ87771		IFREQ FOR PQ80689 - ADB2PA MODULE AFFECTED
PQ83209	21_Apr 2004	UQ87624		ADMIN TOOL CALCULATES UNLOAD DATASET SIZE TOO SMALL FOR CERTAIN TABLESPACE STRUCTURES AND MAY LEAD TO ABENDSB37
PQ81791	14_Apr 2004	UQ87644		DB2 ADMIN ALC COMMAND IN BATCH ON ANY COLUMN ON THE TABLE CHANGES IDENTITY COLUMN FROM ALWAYS TO BY DEFAULT
PQ83708	14_Apr 2004	UQ87644		IN PANEL ADB21 LOWER CASE LETTERS IN SQL CAUSE SQLCODE206 -206 WHEN RUN IN JAPANESE KATAKANA ENVIRONMENT
PQ81470	8_Apr 2004	UQ87223		INVOKING ADMIN FAILS WHEN USING ADBL CLIST WITH THE SHOW PARAMETER
PQ86271	7_Apr 2004	UQ87223		IFREQ REQUIREMENT FOR DB2 OBJECT COMPARISON TOOL APAR PQ78322 AND PQ80530
PQ83404	5_Apr 2004	UQ87223		INCORRECT TRIGGER DDL GENERATED BY DB2 ADMIN
PQ84781	5_Apr 2004	UQ87223		IFREQ APAR FOR DB2 OBJECT COMPARISON TOOL APAR PQ84430
PQ84119	1_Apr 2004	UQ87223		PANEL ADB21XPH INDEX PART HISTORY INCORRECTLY SHOWS CARD VALUE FROM SYSINDEXPART WITH SYSINDEXPART_HIST CARDF VALUE
PQ84560	1_Apr 2004	UQ87223		MIG COMMAND FROM PANEL ADB21D OR ADB21S RECEIVES SQLCODE206 MSGDSNT408I IN DB2 R510 ENVIRONMENT
PQ85198	1_Apr 2004	UQ87223		PANEL ADB21XPI DISPLAYS INCORRECT SECONDARY ALLOCATION OF ZERO FOR INDEXES CREATED IN DB2 V5
PQ85244	15_Mar 2004	UQ86163		SQLCODE107 AND MSGDSNT408I FROM PANELS ADB21TAK OR ADB21TAN IF CONSTRAINT NAME EXCEEDS DB2 MAXIMUM SIZE OF 18 CHARACTERS
PQ79088	15_Mar 2004	UQ86163		PANEL ADB21OSR RETURNS ISPF DIALOG ERROR WHEN INVALID COMMAND IS ENTERED
PQ83637	15_Mar 2004	UQ86163		E COMMAND IN PANEL ADB25LE RESULTS IN SQLCODE104 WHEN COMMA IS DEFINED AS DECIMAL POINT
PQ84131	15_Mar 2004	UQ86163		OBJECT COMPARE FAILS WHEN PARSING COLUMN WITH NAME OF PRIMARY
PQ83463	27_Feb 2004	UQ85809		MSGDSN9015I - -DCMP PARAMETER 'S' IS UNACCEPTABLE FOR KEYWORD 'DEST' WHEN DB2 ADMIN STARTS DB2 TRACE WITH DEST(S)
PQ84295	26_Feb 2004	UQ85809		INDEX SPACE NAME IS INCORRECT ON PANEL ADB21XS WHEN RTS LINE COMMAND WAS ISSUED ON PANEL ADB21X
PQ84296	26_Feb 2004	UQ85809		GARBAGE CHARACTER AT BOTTOM OF PANEL ADB2 AFTER USING GR LINE COMMAND ON TABLE AND PF3 BACK TO MAINT PANEL
PQ81746	18_Feb 2004	UQ85267		IBM INTERNALLY FOUND PROBLEMS - TRANSLATE FUNCTION WITH MORE THAN 126 PAIRS OF VALUES
PQ82510	18_Feb 2004	UQ85267		SM ALTER ON PARTITION INDEX OMITS PART CLAUSE ON ALTER
PQ83354	18_Feb 2004	UQ85267		PANEL ADB21SP DISPLAYS 32767 FOR SECONDARY SPACE ALLOCATION INSTEAD OF USING SECQTYI COLUMN FOR CORRECT VALUE
PQ83265	12_Feb 2004	UQ85125	HIPER	ADBTEP2 CAN GIVE WRONG OUTPUT WHEN RUN ON SYSTEMS WITH CCSID OTHER 37
PQ78614	27_Dec 2003	UQ84036		ADMIN TOOL GIVES CATALOG ROW STACK FULL RUN WILL TERMINATE MESSAGE WITH LARGE INPUT
PQ79192	27_Dec 2003	UQ84005		PQ79192 IS AN IFREQ FOR PQ79629 (QUALIFIER MIS-COMPARED ON TRIGGER WHEN TARGET DDL FROM CATALOG DIDN'T SHOW QUALIFIER).
PQ81476	27_Dec 2003	UQ84036		ADMIN REBIND OF PACKAGE OR PLAN ACCEPTS VALUE OF 0 (ZERO) FOR CCSID ENCODING SCHEME IT SHOULD USE DSNHDECP DEFAULT LIKE SPUFI
PQ74680	26_Dec 2003	UQ84036		GEN LINE COMMAND ON A TABLE WHICH USES A TRIGGER RESULTS IN A LOOP
PQ81962	26_Dec 2003	UQ84034		SUPPORT IN DB2 ADMIN TOOL FOR THE COEXISTENCE OF NEW AND OLD DDNAMES FOR PARALLEL OPERATIONS IN DB2 OBJECT COMPARISON TOOL
PQ78011	16_Dec 2003	UQ83228		MSGDSNU062I ATTEMPTING TO RUN RUNSTATS ON TEMP OBJECT FROM PERFORMANCE QUERY 3.1 - TABLESPACES WITHOUT RUNSTATS INFORMATION
PQ80259	16_Dec 2003	UQ83228		INCORRECT JCL GETS GENERATED WHEN REORG IS CHOSEN, PANEL ADB233,ON THE PARTITIONED INDEXES WITH CLUSTERING
PQ80978	16_Dec 2003	UQ83228		PANEL ADB21SP DISPLAYS 32767 FOR SECONDARY SPACE ALLOCATION INSTEAD OF USING SECQTYI COLUMN FOR CORRECT VALUE
PQ78167	15_Dec 2003	UQ83147		PANEL ADB21K PL LINE COMMAND THE LIST OF PLAN PACKAGES DISPLAYEDADB21PL IS INCOMPLETE
PQ78014	15_Dec 2003	UQ83147		REBINDALL FAILS WITH ISPF DIALOG ERROR ISPV023 WHEN ATTEMPTING TO REBIND A LARGE NUMBER OF PACKAGES
PQ80607	15_Dec 2003	UQ83147		PL AND P LINE COMMANDS ON PANEL ADB21L SHOULD DISPLAY * LOCATIONS IN ADDITION TO " " ONES
PQ79041	13_Dec 2003	UQ83103		ADMIN TOOL DOES NOT IDENTIFY DATASETS THAT ARE HSM MIGRATED AND DOES NOT PROVIDE MEANINGFUL MESSAGE
PQ81391	13_Dec 2003	UQ83103		DB2 ADMIN DOES NOT RECALL HMIG OUTPUT DATA SETS WHEN GEN REQUESTED
PQ79432	11_Dec 2003	UQ83060		ADMIN TOOL ADB2GEN GETS PARSING ERROR DURING MIGRATION ON A VIEWADB2GEN - ENDED NORMALLY TOKEN NUMBER = 0326, TOKEN =A
PQ81265	11_Dec 2003	UQ83060		ADMIN ADB2GEN HAS PARSING ERRORS ON VIEWS AND MAY HANG DURING TRIGGER GENERATION TOKEN NUMBER = 0218, TOKEN =AS
PQ81284	11_Dec 2003	UQ83060		VIEW QUALIFIER INVALID DURING COMPARE PROCESS, WHEN OPTION <NONE> IN USE TO SUPPRESS SET SQLID STATEMENTS.
PQ78957	8_Dec 2003	UQ82916		ADMIN TOOL TABLE OWNER FIELD IN PANEL ID ADB21TAN IS TOO SHORT IT IS 7 CHARACTERS WHEN IT SHOULD BE 8
PQ80400	8_Dec 2003	UQ82916		RTS REAL TIME STATISTICS LINE COMMAND INCORRECTLY LISTS TABLESPACES WHEN SMAE NAME IS USED IN DIFFERENT DATABASES
PQ79959	3_Dec 2003	UQ82808		TWO OPTIONS ON ADMIN MAIN MENU ADB2 FOR INTERFACE TO OTHER DB2 PRODUCTS AND OFFERINGS ARE OVERWRITTEN BY PANEL ADB21TSE
PQ76947	30_Nov 2003	UQ82650		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	UQ82652		PQ80933 ADDRESSES THE DB2 ADMIN TOOL SIDE OF THE PROBLEM REPORTED BY DB2 OBJECT COMPARISON TOOL APAR PQ78913
PQ79018	14_Nov 2003	UQ82183		ISSUES IN MIG, RELATED TO COMMENTS, JOB STEP NAMES, DATASET CLEAUP WERE REPORTED.
PQ80045	9_Nov 2003	UQ81991		GEN PRODUCES WRONG GRANT FOR A GLOBAL TEMPORARY TABLE SHOULD USEGRANT ALL PRIVILEGES
PQ79944	5_Nov 2003	UQ81863		DROP RESTRICT ON DROP HELP TEXT
PQ78445	27_Oct 2003	UQ81473		NEW FUNCTION: ABILITY TO NOT GENERATE SET SQLID STATEMENTS
PQ77806	12_Oct 2003	UQ81031		AN IBM INTERNALLY FOUND PROBLEM, THE FORWARD-FIT OF PQ72846 TO V420, AND CODE PREREQUISITE FOR GOC PQ78224
PQ78993	8_Oct 2003	UQ80942		SOS SHORT ON STORAGE - CAN OCCUR USING GEN AS PRIMARY COMMAND, WITH MASKING , IN PANEL ADB21D. ABENDU4088 RC03EC RC3EC
PQ78342	3_Oct 2003	UQ80847		ADMIN GEN COMMAND FOR VIEW DOES NOT SPECIFY NEW OWNER OR USE A MASK FOR NEW OWNER CORRECTLY OR COMPLETELY
PQ77729	2_Oct 2003	UQ80792		MIG COMMAND RESULTS IN -1 FOR KB ALLOCATED AND KB USED SPACE ALLOCATIONS IN PANEL ADB28S FOR J PREFIX DATASETS
PQ75484	27_Sep 2003	UQ80632		UNRESOLVED SYMBOL = COUNT REPORTED BY GEN AND DDL COMMANDS WHEN A VIEW CONTAINS COUNT(*) AS TOT IN A SUB-SELECT
PQ77888	15_Sep 2003	UQ80162		PROVIDE SYSNONYM MASKING FOR WORK STATEMENT LIST (WSL) CLONING
PQ78237	15_Sep 2003	UQ80189		NO ROWS RETURNED USING RTS ( REAL TIME STATISTICS ) LINE COMMAND IN PANEL ADB21X
PQ77771	15_Sep 2003	UQ80162		ABEND0C8 FIXED POINT OVERFLOW EXCEPTION RC8 WITH ONCODE340 SIZE CONDITION RAISED .
PQ77808	15_Sep 2003	UQ80189		RTS COMMAND IN PANEL ADB21X RESULTS IN SQLCODE104 WHEN COMMA IS DEFINED AS DECIMAL POINT
PQ77833	15_Sep 2003	UQ80164		DB2 ADMIN GOES INTO A LOOP WHEN "=" WAS ENTERED ON ADB21TSE
PQ77955	15_Sep 2003	UQ80160		MIGRATE JOB FAILS WITH U4091 '0B' IN CONVERT STEP WHEN MORE THAN 19 TABLES ARE BEING MIGRATED
PQ78131	15_Sep 2003	UQ80160		PANEL ADB2M1S DISPLAYS -1 FOR KB ALLOCATED AND FOR PCT USED COLUMNS WHEN TABLESPACE SIZE APPROACHES 4G
PQ76951	15_Aug 2003	UQ79455		DDL STACK FULL - GENERATED DDL INCOMPLETE
PQ76267	5_Aug 2003	UQ79186		DDL AND GEN LINE COMMAND IN ADMIN TOOL DOES NOT PRODUCE THE EXTERNAL NAME FOR LANGUAGE SQL TYPE STORED PROCEDURE
PQ75456	5_Aug 2003	UQ79172		THREE PROBLEMS: ONCODE=350 WHEN RUNNING A WORKLIST JOB, ADBTEP2 FAILED TO STOP FOR NEGATIVE RC, COMMAS AS DECIMALS
PQ76240	5_Aug 2003	UQ79186		GEN CREATES A COMMENT WHICH IS NOT PRECEDED BY HYPHENS
PQ74242	3_Aug 2003	UQ79134		UR LINE COMMAND DID NOT DISPLAY CLUSTERRATIO INFORMATION
PQ76445	28_Jul 2003	UQ78930		PANEL ID ADB2ZZMN SYSTEM PARAMETERS HAS AUTOBIND AND WORKLOAD MANAGER FIELDS IN ERROR
PQ74847	9_Jul 2003	UQ78379		CONNECTION TO DISTRIBUTED SYSTEM FAILS WITH SQLCODE863
PQ75210	9_Jul 2003	UQ78379		PANEL ADB21S ALWAYS RETURNS TO ROW ONE AFTER PF3 FROM ANY LINE COMMAND DISPLAY
PQ74659	3_Jul 2003	UQ78263		CLONED WSL FAILS WITH RC8 WHEN RUNNING UNLOAD UTILITY
PQ75063	19_Jun 2003	UQ77809		ENQ ON ISPF PROFILE DATASET USING WSL ( WORK STATEMENT LIST ) INMIG ( MIGRATE ) OPERATION
PQ75113	19_Jun 2003	UQ77809		PANEL ADB21XA ALTER INDEX ERROR CONDITION WAS RAISED ZERRMSG ADB252S PROGRAM IS STOPPED DUE TO AN INTERNAL ERROR ONCODE = 9
PQ59167	17_Jun 2003	UQ77768		PANEL ADB2GEN DOES NOT GEN A GRANT ACCESS ON VIEW UNLESS THE CREATE VIEW OPTION IS SPECIFIED AS YES.
PQ60024	17_Jun 2003	UQ77768		GEN OF A TRIGGER WITH NEW OWNER SPECIFIED FAILS TO APPLY NEW OWNER TO OBJECTS WITHIN TRIGGER ACTION TEXT
PQ65927	17_Jun 2003	UQ77768		NEWOWNER IS NOT APPLIED TO ALL OBJECTS DURING GEN PROCESSING. FOR EXAMPLE: VIEW OWNER IS NOT CHANGED.
PQ71228	17_Jun 2003	UQ77768		SQLCODE20100 FROM GEN WHEN TRIGGER OWNER IS DIFFERENT THAN THE TABLE OWNER
PQ71340	17_Jun 2003	UQ77768		ONCODE9050 FROM PANEL ADB21TSE DURING SELECT PROTOTYPE PROCESSING CONTAINING A WHERE CLAUSE
PQ72005	17_Jun 2003	UQ77768		DDL GENERATED BY GEN COMMAND WITH REBIND=Y DOES NOT INCLUDE REBIND DDL.
PQ72009	17_Jun 2003	UQ77768		DDL / GEN OF A VIEW CONTAINING A REFERENCE TO AN INTERNAL FUNCTION GENERATES INVALID SQL SYNTAX.
PQ73409	17_Jun 2003	UQ77768		DDL LINE COMMAND ON A VIEW PRODUCES DDL FOR DEPENDENT VIEW
PQ74192	17_Jun 2003	UQ77768		GEN AND DDL COMMAND GET SYNTAX ERRORS ON VIEW WHEN IT CONTAINS AWHERE CLAUSE ARITHMETIC EXPRESSION GROUPED WITH PARENTHESIS
PQ74300	17_Jun 2003	UQ77768		NAME TOO LONG AFTER APPLYING MASKS MESSAGE RECEIVED IS ADBM015E
PQ74241	12_Jun 2003	UQ77663		FOR THE GR (GRANT) LINE COMMAND PANEL ADB2GP IS NOT POPULATED WITH THE EXISTING BIND AND EXECUTE OPTION VALUES
PQ74330	12_Jun 2003	UQ77663		DS LINE COMMAND RESULTS IN SQLCODE104 WHEN COMMA IS DEFINED AS DECIMAL POINT
PQ74609	12_Jun 2003	UQ77663		DROP IMPACT REPORT INCORRECT FOR TRIGGER OBJECTS WHICH REQUIRE MORE THAN A SINGLE CATALOG ENTRY ( SEQNO > 1 )
PQ74882	12_Jun 2003	UQ77663		WHEN AL LINE COMMAND IS USED TO ADD A ROWID COLUMN GENERATED BY DEFAULT ON PANEL ADB21TAB NO INDEX NEEDED MESSAGE IS ISSUED
PQ74240	11_Jun 2003	UQ77663		DDL AND GEN LINE COMMANDS DO NOT WORK FOR AN AUXILIARY TABLE AN INVALID VALUE MESSAGE FOR TABLE TYPE X IS GIVEN
PQ71951	6_Jun 2003	UQ77493		ALTER STORED PROCEDURE PANEL ADB26COV DOES NOT ALLOW SQL AND COMPJAVA LANGUAGE TYPES
PQ66751	5_Jun 2003	UQ77478		ADBTEP2 SERVICEABILITY
PQ66796	5_Jun 2003	UQ77493		WORKLIST CLONE FAILS WITH RC20 IN ADB2WCL
PQ71348	5_Jun 2003	UQ77493		ADBDMT SAVED ONTO SGOCTLIB NOT SADBTLIB
PQ73376	5_Jun 2003	UQ77493		SQLCODE104 RECEIVED EXECUTING A WORK STATEMENT LIST ( WSL ) IF EDIT WAS USED TO MODIFY OR INSERT A MULTI-LINE COMMENT
PQ73860	5_Jun 2003	UQ77493		JOB ENDS WITH RC0 EVEN THOUGH ADB27AC OBTAINED ABENDB37
PQ74000	5_Jun 2003	UQ77493		MSGAWCL901E RECEIVED WHEN CLONING WSL CONTAINING CREATE TABLE WITH A LONG PRIMARY KEY
PQ74076	5_Jun 2003	UQ77493		DDL LINE COMMAND FOR A VIEW PRODUCES ADB2GEN REPORT PRIOR TO THEVIEW DDL
PQ74376	5_Jun 2003	UQ77493		RDEF RECEIVED SQLCODE601 FROM CREATE INDEX DURING CHANGE FROM SEGMENTED TO PARTITIONED TABLESPACE.
PQ73994	28_May 2003	UQ77246		ALC FOR ROWID GENERATED ALWAYS REQUIRES INDEX AND FOR GENERATED BY DEFAULT CREATED WITHOUT THE INDEX
PQ73886	17_May 2003	UQ76964		DB2 ADMIN TABLE ALTER ALC USING DSNTIAUL FOR UNLOAD DOES NOT PRESERVE PREVIOUS COLUMN VALUES
PQ71087	16_May 2003	UQ76954		WORKLIST NAME ENTERED ON PANEL ADB27A IS NOT USED FOR WORK STATEMENT LIST NAME ON POPUP PANEL ADB2GENW
PQ72722	16_May 2003	UQ76954		TABLESPACE NAME MISSING ON REORG, OPTION O, AFTER EXITING FROM OPTION FROM PERFORMANCE QUERIES
PQ73169	16_May 2003	UQ76954		SQLCODE104 FROM PF3 EXIT FROM PANEL ADB2EEE , EDIT EXPLAIN STATEMENT, PANEL OF ADMIN TOOL
PQ73413	16_May 2003	UQ76954		DURING MIGRATE A CREATE STOGROUP STATEMENT IS NOT GENERATED WHEN REQUESTED ON PANEL ADB28M
PQ73532	16_May 2003	UQ76954		UNNECESSARY RESTRICTIONS ON NATIONAL USE CHARACTERS IN ZPARM PANELS
PQ73810	16_May 2003	UQ76954		ISPLLIB DD CONCATENATION INCORRECT FOR ISPF BASE LIBRARY DUE TO MISSING DATASET NAME CAUSING JCL ERROR
PQ69227	18_Apr 2003	UQ76118		SECQTY OF ZERO NOT ALLOWED DURING CREATE TABLESPACE OR CREATE INDEX WITHIN PANELS ADB26CSU AND ADB26CXU.
PQ71043	17_Apr 2003	UQ76076		TOLERATION APAR ON DB2 V8 - WILL MOVE ON TO A PTF.
PQ72300	17_Apr 2003	UQ76111		PANEL ERROR WITH RC20 IN ADB2314T IF CHANGE CURRENT SQLID PRECEEDS OPTION 14 - TABLE SPACE MAINTENANCE RECOMMENDATIONS
PQ72401	17_Apr 2003	UQ76111		UTILITY OPTION VG, RECOVER GDG, HAS TOO MANY STEPS WITHIN JOB AND FAILED WITH MVS 255 STEP LIMIT.
PQ72846	17_Apr 2003	UQ76111		PANELID ADB2Z OPTION 2T - DISPLAY/MANAGE TRACES SHOWS RC8 REASONCODE 00E60820 IF NO TRACES ARE ACTIVE
PQ72875	17_Apr 2003	UQ76111		PANEL ADB21K ERROR USING BC BIND COPY OPTION
PQ72944	17_Apr 2003	UQ76061		NEW FUNCTION - REFERENCE GOC PQ72681
PQ65987	9_Apr 2003	UQ75857		DB2 ADMIN TOOL DISK SPACE CALCULATIONS ARE NOT ALWAYS CORRECT
PQ70422	28_Mar 2003	UQ75509		OPTION 9 WITHIN PERFORMANCE QUERY DOES NOT RETURN ALL UNUSED INDEXES WHEN DBNAME FILTERING IS NOT USED.
PQ70302	27_Mar 2003	UQ75436		INCORRECT DESCRIPTION DISPLAYED ON PANEL ADB21II1 FOR " RECOVERY STATUS CHANGE REASON " WHEN REORG LOG(NO)
PQ72461	27_Mar 2003	UQ75436		THE ADB2ZBAA PANEL SHOWS DWQT TWICE SECOND SHOULD BE VDWQT BUT ALTER BUFFERPOOL COMMAND IS CORRECT
PQ71680	21_Mar 2003	UQ75509		ADD COMMAND IN PANEL ADB27CA RESULTS IN SQLCODE104 WHEN COMMA ISDEFINED AS DECIMAL POINT
PQ72186	18_Mar 2003	UQ75169	HIPER	IBM INTERNALLY FOUND PROBLEM
PQ70623	15_Mar 2003	UQ75081		DDL COMMAND OF A ALIAS GENERATES INCORRECT SYNTAX. THE LOCATIONNAME IS FOUND QUALIFYING THE ALIAS NAME, NOT THE DB2 OBJECT.
PQ71055	15_Mar 2003	UQ75080		BATCH REORG FOR LOB TABLESPACES CONTAIN INVALID KEYWORDS RESULTING IN MSGDSNU076I AND MSGDSNU012I RC08
PQ71309	15_Mar 2003	UQ75077		RDEF COMMAND DOES NOT USE NEW CLUSTER INDEX VALUES WHEN ALSO REDUCING THE NUMBER OF PARTITIONS
PQ71618	15_Mar 2003	UQ75078		IBM INTERNALLY FOUND PROBLEM. SEE PROBLEM DESCRIPTION.
PQ67712	26_Feb 2003	UQ74646		WHEN PRESSING PF11 OR ENTER, HELP PANEL NAVIGATION DOES NOT RETURN CORRECTLY IN ALL CASES.
PQ69501	26_Feb 2003	UQ74646		AFTER SELECTING MORE TABLESPACES TO MIGRATE ON PANEL ADB28ASD , PF8 PROCESSES SELECTIONS INSTEAD OF DISPLAYING MORE DATA.
PQ70844	26_Feb 2003	UQ74646		GENERATED SQL STATEMENTS FAIL TO EXECUTE AFTER EDIT SESSION FROMPROMPT ON OPTION. EXECUTION RESULTS: MSGDSNT408I AND SQLCODE104
PQ67758	25_Feb 2003	UQ74469		IMPROVE DROP RESTRICT ON DROP
PQ70222	25_Feb 2003	UQ74441		BIND AND REBIND STATEMENTS CONTAIN DOTS ".." CAUSING INVALID SYNTAX - ERROR RETURNED IS INVALID KEYWORD
PQ70269	25_Feb 2003	UQ74474		REORG CONTROL STATEMENT IS MISSING TABLESPACE NAME
PQ70474	24_Feb 2003	UQ74426		IBM INTERNAL APAR. SEE PROBLEM DESCRIPTION IN APAR CLOSING TEXT.
PQ70373	12_Feb 2003	UQ74098		USING WORK STATEMENT LIST AND ALC - JOB GENERATED CONTAINS DUPLICATE DD STATEMENTS IN ISPFBAT STEP
PQ68006	4_Feb 2003	UQ74098		USING MIG FUNCTION AT THE DATABASE LEVEL, PANEL ADB28S DOES NOT INCLUDE ALL TABLESPACES BEING MIGRATED
PQ69361	4_Feb 2003	UQ74098		MIG FUNCTION FAILS IN ADB28M WITH RC43 IF A PDS IS SPECIFIED AS A MASK DATASET
PQ69525	31_Jan 2003	UQ73721		PANEL ADB23 , OPTION 1, INCLUDES TABLESPACES WITH " DEFINE NO " SPECIFIED IN THE TABLESPACE DEFINITION.
PQ69680	31_Jan 2003	UQ73726	HIPER	SPACE MANAGER FUNCTIONS DO NOT REPORT SECQTYI SECONDARY SPACE ALLOCATIONS CORRECTLY
PQ69474	30_Jan 2003	UQ73721		USING LAUNCHPAD ? FOR DB2 SUBSYSTEM PROMPT PANEL RESULTS IN MSGIKJ56500I WHEN ONLY ONE DB2 SUBSYSTEM EXISTS
PQ69966	30_Jan 2003	UQ73675		IBM INTERNALLY FOUND PROBLEMS
PQ70122	29_Jan 2003	UQ73721		WHEN RETURNING TO PANEL ADB2M1S AFTER AL PROCESSING FROM PANEL ADB2M1AS PRIOR VALUES NOW SHOW AS " -1 " FOR VSTAT VIEW.
PQ70013	28_Jan 2003	UQ73721		MSGISPT034 FROM ADB2U LINE 267 BUILDING REORG JOB FROM PANEL PATH STARTING WITH SM SPACE MANAGEMENT FUNCTIONS
PQ69079	15_Jan 2003	UQ73282		ADBL CLIST SUPPORTS LIBDEF(NO) OPTION
PQ69239	15_Jan 2003	UQ73272		ROWID DATA TYPE NOT BEING RECOGNIZED DURING TABLE LINE COMMAND ALC PROCESSING WHEN ADDING A NEW COLUMN.
PQ68362	13_Jan 2003	UQ73159		REORG OF 1000 TABLESPACES EXCEEDS 255 STEPS PER JOB
PQ68410	13_Jan 2003	UQ73159		EXISTING DB2 CATALOG PATH COLUMN NOT USED DURING BIND OR RE-BIND PACKAGE WITHIN PANEL ADB21KB.
PQ69119	13_Jan 2003	UQ73160		IBM FOUND PROBLEMS THAT ARE PRE FOR PQ65316 (OBJECT COMPARISON)
PQ66239	19_Dec 2002	UQ72795		' INVALID VALUE ' RESULTS FROM PANEL ADB27A WHEN WORK STATEMENT LIST IS YES AND UNLOAD METHOD IS ' D ' FOR DSNTIAUL
PQ66550	19_Dec 2002	UQ72795		ATTEMPT TO CONNECT TO REMOTE SUBSYSTEM USING DISTRIBUTED DB2 DB2 SYSTEMS OPTION DOES NOT RECOGNIZE ENTRY IN ADB2DB2D TABLE
PQ68039	13_Dec 2002	UQ72604		MASKING FAILS WHEN CLONING A WSL CONTAINING ENTRIES CREATED BY THE REBINDALL , BINDALL OR FREEALL PRIMARY COMMAND
PQ68011	12_Dec 2002	UQ72562		PANEL ADB2UX RECEIVING ERROR RC20 MSGISPP255: A BLANK OR NULL MUST IMMEDIATELY FOLLOW LIGHT PEN ATTRIBUTE
PQ68109	12_Dec 2002	UQ72562		PANEL ADB26CTU RETURNS ' VALUE OUT OF RANGE ' FOR CHAR COLUMN OFLENGTH 255 FOR ALTER OR INSERT LINE COMMANDS
PQ68251	12_Dec 2002	UQ72562		INCOMPLETE DATA DISPLAY FROM SM COMMAND IN PANEL ADB2M1S FOR NPIINDEX TYPE X ENTRIES.
PQ69017	10_Dec 2002	UQ72491	HIPER	CORRECT A LINKEDIT PROBLEM FOR ADB28MM
PQ67587	4_Dec 2002	UQ72327		THREE-PART LONG COLUMN NAME MAY BE TRUNCATED BY GEN OR MIG
PQ68664	4_Dec 2002	UQ72331		DROP RESTRICT ON DROP INCORRECTLY GENERATED AGAINST A VIEW RESULTS IN MSGDSNT408I SQLCODE156
PQ66357	23_Nov 2002	UQ72068		IBM-FOUND PROBLEMS, INCLUDING MIXED CASE SUPPORT IN ADB26COV
PQ68028	22_Nov 2002	UQ72062		DB2 ADMIN TOOL V410 NEW FUNCTION
PQ67645	19_Nov 2002	UQ71883		MOVE FROM STOGROUP TO VCAT SOMETIMES OMITS RENUNC WHEN IT IS NECESSARY TO CHANGE THE HLQ OF THE ASSOCIATED PAGESET.
PQ67899	19_Nov 2002	UQ71884		MSGIBM0421S ONCODE520 SUBSCRIPTRANGE IN ADB2PA FOR AN ALTER TABLE STATEMENT WITH DEFAULT
PQ67813	12_Nov 2002	UQ71699		RC 307 ERRONEOUSLY RETURNED FROM ADBTEP2 ON RESTART
PQ63592	11_Nov 2002	UQ71652		SPACE MANAGER SM GOES INTO LOOP WHEN DISPLAYING MULTI VOLUME TABLESPACE .
PQ67145	11_Nov 2002	UQ71658		IBM INTERNALLY FOUND PROBLEMS
PQ67202	11_Nov 2002	UQ71660		PANEL ADB2ZZMN WILL NOT ALLOW NEW MAXIMUM VALUES FOR DB2 ZPARM VALUES NUMLKUS AND NUMLKTS
PQ67816	11_Nov 2002	UQ71661		ABEND0C4 IN ADB2WCL ATTEMPTING TO CLONE A WORK STATEMENT LIST
PQ65892	2_Nov 2002	UQ71437		DB2 ADMIN TOOL V4 -- NEW CLONING OVERWRITE FEATURE FOR SPACE ATTRIBUTES PRIQTY AND SECQTY
PQ62571	21_Oct 2002	UQ71055		JCL ERRORS CAN OCCUR IN VARIOUS UTILITY JOBS WHEN MORE THAN 99 JOBSTEPS CAUSE GENERATED STEPNAME TO EXCEED 8 CHARACTERS.
PQ65288	21_Oct 2002	UQ71052		LINE COMMAND SEL ON PANEL ADB21T FOR LOB TABLE RETURNS SQLCODE238
PQ63040	16_Oct 2002	UQ70899		THE CONVERSION PROGRAM BLANKS OUT THE IGNOREFIELDS YES KEYWORD WHICH CAUSES THE LOAD TO FAIL ON THE TARGET.
PQ65654	16_Oct 2002	UQ70910		WRONG UNLOAD UTILITY COMMAND GENERATED FOR TABLE WHEN USING THE WORKLIST OPTION.
PQ65942	16_Oct 2002	UQ70910		CREATE INDEX WITH CX COMMAND WITH NO PIECESIZE VALUE RESULTS IN SQLCODE104
PQ65950	16_Oct 2002	UQ70910		SQLCODE104 USING CDI LINE COMMAND FROM PANEL ADB21T WHEN COMMA IS USED AS DECIMAL
PQ66189	16_Oct 2002	UQ70910		MSGDSNU035I RESULTS FROM ONLINE REORG SHRLEVEL REFERENCE FROM MISSING SYSREC DD AND PARAMETER ' NOSYSREC ' IS NOT SPECIFIED.
PQ63459	14_Oct 2002	UQ70805		PART KEYWORD MISSING FROM UNLOAD STEP DURING MIGRATION OF A SINGLE PARTITION OF A PARTITIONED TABLESPACE
PQ66972	12_Oct 2002	UQ70780		WSL CLONING CHANGES THE CREATOR.NAME IN THE ADMIN ALTER CONVERT STATEMENT.
PQ66500	10_Oct 2002	UQ70712		ENHANCED DATA CONVERSION ROUTINES
PQ65620	9_Oct 2002	UQ70694		ALC FUNCTION CREATES AN INVALID TEMPLATE WHEN THE UNLOAD UTILITY IS USED
PQ65975	9_Oct 2002	UQ70711		RH COMMAND IN PANEL ADB21T RESULTS IN MSGADB900 NOT FOUND IN 'ISPMLIB' LIBRARY
PQ66163	9_Oct 2002	UQ70709		MSGISPP178 FROM PANEL ADB26CE OCCURS USING CRE LINE COMMAND TO CREATE A DISTINCT DATATYPE . RC16 .
PQ66392	3_Oct 2002	UQ70447		IBM-FOUND PROBLEMS IN GEN AND RELATED AREAS
PQ65495	25_Sep 2002	UQ70186		IF ALC IS USED TO DELETE A COLUMN OF A TABLE, WHICH IS PART OF PRIMARY KEY, THE CREATE INDEX IS NOT GENERATED IN DDL REBUILD.
PQ63651	13_Sep 2002	UQ69824		BUFFERPOOL FIELD IS TOO SHORT ON PANEL ADB2USOO TO ACCEPT BP16K1FOR ONLINE REORG UTILITY JOB.
PQ65282	13_Sep 2002	UQ69824		CREATE TABLE FAILS WITH SQLCODE104 IF SMALLINT COLUMN FOLLOWS CHAR COLUMN WHERE S - FOR SBCS WAS SELECTED.
PQ65431	13_Sep 2002	UQ69836		FOR IBM-FOUND PROBLEMS
PQ62517	4_Sep 2002	UQ69574		MESSAGE 'VALUE OUT OF RANGE (1-9999)' BEING RETURNED WHEN UPDATEFOR PRIMARY QUANTITY IN PANEL ADB2ZZMN.
PQ63064	4_Sep 2002	UQ69576		AN INTERNAL APAR FOR IBM FOUND PROBLEMS IN DB2 ADMIN TOOL V3
PQ64228	21_Aug 2002	UQ69225	HIPER	INTERNAL IBM-FOUND PROBLEMS
PQ63458	12_Aug 2002	UQ68910		ADDING A CHECK CONSTRAINT MAY FAIL SINCE CREATOR OF CONSTRAINT IS LISTED AS TABLE OWNER
PQ63098	10_Aug 2002	UQ68874		DB2 ADMIN TOOL V4 NEW FUNCTION AUTH SWITCHING
PQ63076	23_Jul 2002	UQ68340	HIPER	DB2 ADMINISTRATION TOOL VERSION 4 ROLLUPS

Top of page