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 October 2008
DB2 Tools for z/OS
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK68200




SUPPORT FOR IMS V11
PK82079
3_Apr
2009
UK45502


PROVIDE SUPPORT FOR HALDB WITH DATAREFRESHER.
PK81724
6_Mar
2009
UK44642

HIPER

AFTER PK69786/UK41766, DECZLDX0 MAY EXPERIENCE AN ABENDS0C7 WHEN THE CMPSC INSTRUCTION IS EXECUTED.
PK80254
13_Feb
2009
UK44045


PANEL DECP00 DOES NOT DISPLAY ALL THE DATA ENTRY LINES AND IN SOME SYSTEMS CAUSES AN ISPF FAILURE WHEN IT EXCEEDS THE 24
LINES
PK69786
20_Nov
2008
UK41766
PK81724

ADD EDITPROC DRIVER FOR COMPRESSION/ENCRYPTION COMPATIBILITY. ABEND S0C4 RUNNING ENCRYPTION TOOL WITH Z/OS 1.10
PK75337
20_Nov
2008
UK41773


DATA ENCRYPTION FOR IMS NEEDS TO HANDLE HDC (DFSZLDX0) NOT JUST HDCE (HCOZLDX0) FOR IMS DATA COMPRESSION.
PK56108
30_Nov
2007
UK31816


ADD AN EXIT DRIVER FOR IMS COMPRESSION AND ENCRYPTION EXITS
PK55140
6_Nov
2007
UK30982


ABEND U2990 AFTER APPLYING PTF UK29636 FOR APAR PK48886
PK55137
5_Nov
2007
UK30945


ABEND0C4 IN DEVIMSXC X'710' IN BMC UNLOAD COBOL EXIT
PK33728
8_Oct
2007
UK30015


APPLICATION RECOVERY TOOL V10 SUPPORT
PK48886
26_Sep
2007
UK29636
PK55140

SUPPORT AES ENCRYPTION IN IMS
PK48784
18_Jul
2007
UK27224


ABEND U2990 OUT OF DECENA01 CAUSES IMS CONTROL REGION TO ABEND U2990
PK45596
25_May
2007
UK25541


IMPROVE RETURNCODE08, RC=08, HANDLING FROM A CALL TO ICSF ENCRYPTION FUNCTION CSNBSYE.
PK43736
18_May
2007
UK25251


DATA ENCRYPTION FOR IMS IS CORRUPTING THE LAST 6 BYTES OF A DEDBSEGMENT (THIS DEPENDS ON SEGMENT LENGTH)
PK38227
8_Feb
2007
UK20511


INTERNAL APAR FOR PK34242
PK37305
15_Jan
2007
UK21270


CMG999 MESSAGE ISPV010 - ISPV010 MESSAGE NOT FOUND IN 'ISPMLIB',OTHER PROBLEMS WITH RUNNING BATCHTSO STEP OF GENERATED JCL
PK36035
27_Dec
2006
UK20926


CANNOT GENERATE AN INCREMENTAL IMAGE COPY (IIC)
PK34242
12_Dec
2006
UK20511


PROVIDE V5 LEVEL OF ADMIN V7 APAR PK26695 .
PK30335
7_Oct
2006
UK18618


ADMIN TOOL ATTEMPTS TO USE SMART ALTER WHEN ADDING A COLUMN TO THE END OF A TABLE WITH AN EDITPROC
PK16767
7_Oct
2006
UK18618


MIGRATE FUNCTION SKELETON ADB28RL1 USED TO BUILD THE TARGET LOADJOB CONTAINS ERRORS
PK29872
27_Sep
2006
UK18366


WSL CLONE FUNCTION RC=16 MESSAGE ADBQ901E TOKEN =DECIMAL FOR ALTER STATEMENT
PK27421
3_Aug
2006
UK16888


ADMIN TOOL ADB21PR PANEL CORRUPTS PACKAGE LIST ENTRIES
PK20807
2_Aug
2006
UK16888


MIG OF MORE THAN 13 TABLESPACES RESULTS IN MSGISPF107
PK22603
23_Jul
2006
UK16507


PANEL ADB26CTQ 'SEQUENCE OPTIONS' CACHE VALUE INCORRECT AS NO CACHE IS DISPLAYED AS 0 AND CAUSES MSG 'VALUE OUT OF RANGE'
PK26697
29_Jun
2006
UK15892


AN ANALYZE FAILURE WITH RC 4038 (VALIDATE APPLICATION)
PK26688
29_Jun
2006
UK15892


PK22618 FOLLOW-UP (RELEASE 510 ONLY)
PK18479
16_Jun
2006
UK15509


DEDB UNLOAD (FUBCUR1) OF HPFP ABENDS WITH S0C4 WHEN UNLOADING DEDB DATABASES ENCRYPTED BY DENC. ENCCEXIT CAUSES THIS S0C4.
PK22618
8_Jun
2006
UK15253


VALIDATE WSL FAILS RC=08 WITH MESSAGE FUNCTION = ADB2WVL, LINE 241: SIGNAL ERROR WITH NO ADDITIONAL MESSAGES
PK23498
8_Jun
2006
UK15253


DIAGNOSTIC DATA BEING SEEN WHEN NOT REQUESTED DURING A MIG COMMAND PROCESSING.
PK19661
8_Jun
2006
UK15253


ADMIN TOOL HAS INCORRECT DISPLAY OF TRIGGERS WHEN QUALIFICATION IS USED
PK21737
26_May
2006
UK14860


DISPLAY PANEL ISPP178 PANEL 'ADB223' ERRORVARIABLE 'CREATOR' WH EN CREV AND LOOKUP ATTEMPTED.
PK19419
12_May
2006
UK14495


ISPF DIALOG ERROR FTINCL ADB2GEN FROM DDL LINE COMMAND AFTER ZPARM DISPLAY
PK16778
12_May
2006
UK14495


ADMIN TOOL UTIL LINE COMMAND U.KD CHECK DATA ENDS RC=00 EVEN IF THE UTILITY END RC=04
PK21151
12_Apr
2006
UK13524


WSL VALIDATE FAILS RC=08 WITH MESSAGE ERROR PROCESSING TABLE NAME IN A ALTER DROP FOREIGN KEY STATEMENT
PK10523
12_Apr
2006
UK13524


MESSAGE EXEC ADB2BSFT FAILED: > TOO MANY TABLES WITH RESTRICT ON DROP
PK18916
12_Apr
2006
UK13524


GOC SQLCODEN623 ON CREATE INDEX
PK20595
12_Apr
2006
UK13524


GOC IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED IN GOC2CMR / MODIFY_TOKENS
PK13158
31_Mar
2006
UK13165


MSGIEF240I IN CNVRT STEP - TOO MANY DD STATEMENTS
PK10350
30_Mar
2006
UK13139


UTILITY JOBS GENERATED ON A REMOTE DB2 USE LOCAL JOBCLASS INSTEAD OF JOBCLASS FOR REMOTE DB2 SUBSYSTEM
PK16396
30_Mar
2006
UK13139


ADMIN TOOL TEMPLATE NOT WORKING FOR UTILITY
PK20747
30_Mar
2006
UK13139


PK15445 VERSION IN RELEASE 510
PK22108
30_Mar
2006
UK13139


ADBMAIN PK20279 AND PK22091 R510 (RETRO-FIT)
PK18548
8_Mar
2006
UK12420


GOC CHECK DATA UTILITY FAILS RC=08 DSNU088I DSNUGTIS INVALID CHARACTER OPERAND AS QUOTES SURROUNDING OBJECT NAME
PK10444
8_Mar
2006
UK12420


SQLCODE104 ON DDL OF VIEW THAT CONTAINS LONG STATEMENT THAT WRAPS INTO MULTIPLE LINES
PK18472
20_Feb
2006
UK11949


ADMIN TOOL GEN LINE COMMAND FOR STORED PROCEDURE DOES NOT SHOW THE GRANTS ON THE PROCEDURE WHEN REQUESTED
PK15285
19_Feb
2006
UK11949


ADMIN TOOL ALTER COLUMN DELETE OF A CONSTRAINT COLUMN RESULT IN A SQL ERROR
PK18466
19_Feb
2006
UK11949


ABEND0C4 IN ADB27AC DURING ALC DROP / CREATE OF INDEX
PK08544
11_Feb
2006
UK11949


ADMIN TOOL MIGRATE DOES NOT PERFORM CHECK UTILITY FUNCTION FOR IMPLICITLY CREATED TABLESPACES
PK12678
2_Feb
2006
UK11418


A REQUIREMENT TO HAVE MIG SUPPORT USER TEMPLATES FOR WORK DATASETS FOR CHECK UTILITY
PK15818
2_Feb
2006
UK11418


ADMIN TOOL DOES NOT PRESERVE LOWER CASE FOR DBRM VERSIONS
PK16225
2_Feb
2006
UK11418


OBJECT COMPARE VALIDATE OF WSL RESULTS IN IBM0421S ONCODE=520 SUBSCRIPTRANGE CONDITION ADB2WVL ENTRY POINT STATEMENT 1792
PK15583
2_Feb
2006
UK11418


UT/UTIL LINE COMMAND AND GENERATE WORK STATEMENT LIST YES RESULTS IN RC208 AND INVALID DATA SET NAME
PK10186
13_Jan
2006
UK10826


ADB2REE PERFORMANCE ISSUES (PHASE I, PARSER FIX)
PK13964
12_Jan
2006
UK10826


SQLCODE620 FROM PANEL ADB21SAR FORCING LOCKSIZE ON CREATE TABLESPACE IN TEMP DATABASE
PK14988
12_Jan
2006
UK10826


RUNSTATS UTILITY PANEL ADB2USRA GIVES ERROR MESSAGE FOR PARTITIONED TABLESPACE OPTION FORCEROLLUP YES
PK17004
6_Jan
2006
UK10601


ADD SUPPORT FOR ADVANCED ENCRYPTION STANDARD (AES) FOR 128-BIT KEYS. D/T2094
PK15678
27_Dec
2005
UK10430


DROP UC LINE COMMAND ON PANEL ADB21TN RESULTS IN RC=16 ZERRMSG ISPP178 FOR A TBDISPL FUNCTION
PK16037
27_Dec
2005
UK10430


MIG OF A PARTITIONED TS, WITH HPU USED AS THE UNLOAD TASK, GENERATES UNLOAD OF ENTIRE TS FOR EACH PARTITION.
PK07974
27_Dec
2005
UK10430


MIGRATE BUILDS INVALID LOAD CARD. MISSING QUOTES ON TABLE NAME
PK15051
27_Dec
2005
UK10430


U.R OR UTL/UTIL COMMAND AND RUNSTATS WITH COLGROUP MISSING RNPRIN01 DDNAME RESULTS IN DSNU047I DSNUSDRB MESSAGE RC=08
PK14195
15_Dec
2005
UK10135


SQLCODE802 FROM SM OPERATION FOR TABLE SPACE ESTIMATOR
PK07582
15_Dec
2005
UK10135


OBJECT COMPARE DOES NOT HONOR THE COMMA AS DECIMAL POINT
PK15027
12_Dec
2005
UK09984


UTIL RUNSTATS COLUMN SYNTAX INVALID RESULTS IN RC=08 AND MESSAGEDSNU088I DSNUGPRZ - INVALID CHARACTER OPERAND
PK05292
11_Dec
2005
UK09984


RESOURCE LIMIT, WHEN UPDATED VIA ADMIN PANEL ADB2Z2RU , RECEIVED" INVALID VALUE " BUT UPDATE WAS MADE REGARDLESS.
PK05496
11_Dec
2005
UK09984


MSGISPF105 USING MOVE LINE COMMAND WHEN TARGET STOGROUP CONTAINSMORE VOLUMES THAN SOURCE STOGROUP
PK09476
11_Dec
2005
UK09984


ADMIN TOOL UTILITY PANEL ABD2US IS GENERATING WORK STATEMENT ENTRIES WHEN WORK STATEMENT LIST OPTION IS SPECIFIED AS "NO"
PK13895
11_Dec
2005
UK09984


SQ ON DB2 V8 PACKAGE ABEND0C4 IN ADBUNI WHEN RUNNING FROM APF AUTHORIZED LOADLIB
PK16012
8_Dec
2005
UK09901

HIPER

DIAGNOSTIC DATA BEING SEEN WHEN NOT REQUESTED DURING A MIG COMMAND PROCESSING.
PK16052
8_Dec
2005
UK09921


A FOLLOW-UP APAR TO PK15062/PK12743
PK13749
24_Nov
2005
UK09420


MIG AT TABLE LEVEL FAILS IN UTILITY JOBS WITH MSGDSNU054I TABLESPACE NOT FOUND
PK06380
24_Nov
2005
UK09640


TWO PROBLEMS FROM ALC OF GENERATED ALWAYS COLUMN USING PANEL ADB26CTQ AND VALUES FOR PROMPT FIELD ' CACHE '
PK06949
24_Nov
2005
UK09422


PANEL ADB2ZZMN TRUNCATES TCP/IP KEEPALIVE OVERRIDE VALUE
PK09419
24_Nov
2005
UK09422


INCOMPLETE REVOKE IMPACT REPORT - PANEL ADB2RIP MISSING CASCADE REVOKE IMPACT INFORMATION
PK14397
24_Nov
2005
UK09422


WHEN MIGRATING A DATABASE AND AFTER ISSUING MIGRI COMMAND, PANEL ADB28S COULD DISPLAY DUPLICATE TABLESPACE ENTRY
PK13595
23_Nov
2005
UK09412


QA COMMAND IN PANEL ADB21 IGNORES FILTER
PK14204
23_Nov
2005
UK09412


SQLCODE636 FROM ALTER / VALUES ON MULTIPLE INDEX KEY VALUES IN ONE OPERATION
PK14745
23_Nov
2005
UK09420


A TABLE LEVEL MIGRATE OF A MULTITABLE TABLESPACE USING HPU UNLOAD METHOD RESULTS IN ?INZU107E
PK14840
23_Nov
2005
UK09640


ALC COMMAND FAILS ADB21SAC: INVALID ACTION=FIRST WHEN REL USED TO CHANGE INDEX LIMIT KEY
PK15062
23_Nov
2005
UK09412


VARIOUS SPACE ALLOCATION RELATED B37 PROBLEMS
PK12041
23_Nov
2005
UK09420


MSGISPT034 OR MSGISRZ002 SYNTAX CONDITION RAISED IN ADB28M DURING MIG
PK12743
23_Nov
2005
UK09412

HIPER

IBM ADMIN TOOL - INTERNAL FIXES RELATED TO SPACE CALCULATION
PK09078
21_Nov
2005
UK09412


SQLCODE104 ( -104) FOR MQT MATERIALIZED QUERY TABLE - ALC GEN DDL - X'0D15' CR LF APPEARS IN DDL
PK12107
21_Nov
2005
UK09412


ADMIN TOOL PANEL ADB2ELIH DOES NOT PROPERLY FORMAT QUERY WHEN DB2 HAS DECIMAL EQUALS COMMA SPECIFIED
PK11421
6_Nov
2005
UK09037


ADMIN TOOL PANEL ADB2ZDL2 DOES NOT SHOW CURRENT ACTIVE DB2 LOCATIONS
PK10653
6_Nov
2005
UK09037


UPDATE LUMODES IN CDB RESULTS IN SQLCODE104
PK11121
6_Nov
2005
UK09037


IBM INTERNALLY FOUND PROBLEMS RELATED TO PANEL ADB27C
PK08589
4_Nov
2005
UK08741


COMPARE CONVERSION ERROR FOR NULL VALUE, WHEN CONVERTING FROM CHAR(10) WITH DEFAULT NULL TO DATE WITH DEFAULT NULL
PK09344
4_Nov
2005
UK08741


CONVERSION FROM DATE TO TIMESTAMP DATA TYPE CAN CAUSE LOAD ERRORS
PK13958
4_Nov
2005
UK08741

HIPER

ALC CONVERSION EXPANDING DECIMAL FIELD CAUSES DATA CORRUPTION IN SUBSEQUENT DECIMAL COLUMN(S)
PK11201
27_Oct
2005
UK09037


NEW CURRENT SQLID IS NOT SAVED ACROSS ADMIN SESSIONS
PK10611
10_Oct
2005
UK08048


ALC ON TABLE THAT CONTAINS A GENERATED ALWAYS COLUMN CAN RESULT IN MSGIEFC452I JOB NOT RUN - JCL ERROR
PK11060
10_Oct
2005
UK08048


PANEL ADB21TAB FAILS TO WARN USER IF CONFLICTING OPTIONS ARE CHOSEN FOR ALTER ADD COLUMN NOT NULL WITH NO DEFAULT
PK11185
30_Sep
2005
UK07725


ADMIN TOOL MIGRATE UNLOAD JOB RESULT IN ABEND B37 D37 E37 DUE TOINCORRECT SYSREC ALLOCATION
PK11189
30_Sep
2005
UK07725


ADMIN TOOL DASD SPACE CALCULATIONS USE INCORRECT BLOCKSIZE AND INCONSISTENT PARAMETERS
PK11699
28_Sep
2005
UK08048


THE TEMPLATES DEFINED BY USERS WERE NOT BEING USED IN UTILITY SKELETON ADB2USO.
PK04201
21_Sep
2005
UK07436


DATASET NAME FROM PUNCHDDN TEMPLATE IS IGNORED BY MIGRATE WHEN WSL IS NOT USED
PK05079
21_Sep
2005
UK07436


ADMIN TOOL MIGRATE FUNCTION FAILS ON TEMPLATE
PK07657
21_Sep
2005
UK07436


ADMIN TOOL DDL AND GEN LINE COMMAND DO NOT SHOW THE COLUMN DEFAULT VALUE
PK09071
21_Sep
2005
UK07436


MIS-LEADING ERROR MESSAGE: ERROR ACCESSING TABLE SYS1.SYSDUMMY1
PK10009
21_Sep
2005
UK07436


PANEL ADB2GEN DOES NOT GEN A GRANT ACCESS ON VIEW UNLESS THE CREATE VIEW OPTION IS SPECIFIED AS YES.
PK10085
21_Sep
2005
UK07436


ABENDU4038 LOOP DURING VALIDATE OF WSL FOR ALC INSERT COLUMN ON TABLE WITH RI CONSTRAINT
PK10601
21_Sep
2005
UK07436


A PROBLEM IN GEN - THE FUNCTION THAT WARNS OF TRIGGER DEPENDENCIES WHICH ARE NOT A PART OF THE GEN IS NOT WORKING.
PK11123
15_Sep
2005
UK07267


ABEND0C4 FROM ADB2PA WHEN AUTHORIZATION SWITCH ID IS USED
PK05106
15_Sep
2005
UK07267


ADMIN TOOL ALLOCATES PART LEVEL DATA SETS WHEN PARALLELISM NOT ACTIVE OR DISABLED AND USES WRONG SQLID IN A CREATE
PK06459
15_Sep
2005
UK07267


VARIOUS PROBLEMS HANDLING REBIND IN WSL ( WORK STATEMENT LIST ) IN ADMIN PANELS: ADB2W1 ADB2W1I
PK06633
15_Sep
2005
UK07267


ABEND0C4 ONCODE150 ADB27AC ROUTINE CH2VC USING ALC ALTER WHEN SPECIFYING AUTH SWITCH ID
PK07878
15_Sep
2005
UK07267


ABEND0C4 IN ADB27AC AT ENTRY POINT CONVERT_DDL
PK08844
15_Sep
2005
UK07267


VARIOUS INTERNALLY FOUND PROBLEMS IN R510
PK09239
15_Sep
2005
UK07267


UOPT OPTION
PK09301
15_Sep
2005
UK07267


ALC OPERATION REPORTING IN ADB27AC SUMMARY CAN HAVE MISSING, INCORRECT, OR POORLY FORMATTED INFORMATION
PK09425
15_Sep
2005
UK07267


ALC ADB27AC FAILED TO PRESERVE DESC INDEX ORDER. COMPLEX ALC CHANGED 4TH PK INDEX COLUMN FROM DESC TO ASC
PK09520
15_Sep
2005
UK07267


THE CORRESPONDING APAR OF PK07196 FOR R510/R710
PK10229
15_Sep
2005
UK07267


PARSER FIXES REQUIRED BY PK06633 AND PQ98842
PK10351
15_Sep
2005
UK07267


ONCODE310 ABEND0C8 RC8 IN ADB27AC DOING ALC THAT DELETES LAST COLUMN AND SWAPS TWO OTHER COLUMN POSITIONS
PK03614
29_Aug
2005
UK06726


ADMIN TOOL NOVALUE CONDITION RAISED IN ADB21KSQ DUE TO A NEGATIVE VALUE FOR A PACKAGE STATEMENT NUMBER
PK06348
29_Aug
2005
UK06726


ADMIN TOOL INCORRECTLY SPECIFIES A VIEW IS AN INVALID OBJECT TYPE FOR A DSNTIAUL U.U LINE COMMAND
PK08537
29_Aug
2005
UK06726


DB2 V8 NFM - SQ COMMAND FOR PACKAGES CAN RESULT IN ERROR SYNTAX ERROR 40 IN PANEL ADB21KSQ
PK09081
29_Aug
2005
UK06726


SQLCODE199 USING LAB ( LABEL ) LINE COMMAND ON AUX TABLE
PK03382
28_Aug
2005
UK06726


MIGRATE JOB FOR TARGET SYSTEM CONTAINS DUPLICATE CREATE DATABASE STATEMENT FOR NEW DATABASE CAUSING SQLCODE601
PK05278
28_Aug
2005
UK06726


REORG UTILITY CAN FAIL WITH MSGDSNU047I DUE TO MISSING SYSDISC DD OR TEMPLATE
PK05349
17_Aug
2005
UK06373


WHEN MIGRATING A DATABASE AND AFTER ISSUING MIGRI COMMAND, PANEL ADB28S COULD DISPLAY DUPLICATE TABLESPACE ENTRY
PK05985
17_Aug
2005
UK06373


ONLINE REORG WITH SHRLEVEL CHANGE ALLOWS IMPLICIT TABLESPACE WHICH IS NOT SEGMENTED TO BE CREATED FOR MAPPING TABLE
PK06000
17_Aug
2005
UK06373


TWO INTERNALLY FOUND PROBLEMS IN THE FOLLOWING AREAS: 1. COMMA AS DECIMAL 2. ALL PARTS AREA AND PROMPT IS ON
PK07389
17_Aug
2005
UK06373


ADMIN TOOL PANEL ADB21CDI DISTRIBUTION STATISTICS PANEL SHOWS INVALID DATE VALUES
PK08621
17_Aug
2005
UK06373


SQLCODE614 USING CC COPY CATALOG IN DB2 V8 CM
PK09289
17_Aug
2005
UK06373


AL COMMAND FOR ALL PARTS OF PARTITIONING INDEX EXECUTES IMMEDIATLY, SKIPPING PANEL ADB2PSTM WHEN PROMPT IS ON
PK05167
28_Jul
2005
UK05805


GEN FUNCTION BUILDS CREATE TABLESPACE STATEMENT WITHOUT PRIQTY CLAUSE
PK05978
28_Jul
2005
UK05805


ALTER INDEX PANEL ADB21XA WILL NOT DISPLAY SQTY VALUE LARGER THAN 131068 - IGNORING SECQTYI
PK07140
28_Jul
2005
UK05805


ADMIN TOOL CREATE INDEX SPACE (CREX) LINE COMMAND OPERATION NOT CONSISTENT WITH SIMILAR FUNCTIONS
PK08475
28_Jul
2005
UK05805


THE COUNTER PART OF GOC310 PK07297
PK06149
27_Jul
2005
UK05805


PANEL ADB2USU TO GENERATE AN UNLOAD JOB ALLOWS ONLY A THREE DIGIT SCCSID TO BE ENTERED
PK08209
27_Jul
2005
UK05805


EXPL CONTROL BLOCK FOUND TO CONTAIN DSN FOR EXPLSSNM
PK05480
14_Jul
2005
UK05387


MIGRATE MASK FAILS TO PROPERLY CHANGE STOGROUP NAME
PK06085
14_Jul
2005
UK05387


MSGDSNU047I A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=SYSREC RC8 - FROM LOAD STEP OF MIGRATE WSL
PK07219
14_Jul
2005
UK05401


SQLCODE104 ON SMART ALTER ALC APPENDING COLUMN WITH USER DEFINED DEFAULT
PK08214
14_Jul
2005
UK05401


SQLCODE104 MAY OCCUR IN CREATE TABLE PANEL (ADB26CT).
PK08288
14_Jul
2005
UK05388


LINKEDIT ASSIST OF ADB2UOPT AND ADBDICT (FOR GOC310 PK05668 AND PK08206)
PK06452
30_Jun
2005
UK05387


MIGRATE CONVERT FAILS WITH CC1000 IN ADB28MC
PK03065
28_Jun
2005
UK04935


ADMIN TOOL PANEL ADB2M1S DOES NOT MAINTAIN POSITION AFTER THE RETURN FROM AN ALTER COMMAND
PK06060
28_Jun
2005
UK04935


DATA IS DISPLAYED UNSORTED ON PANEL ADB2M1S EVEN THOUGH SORT CRITERIA HAD BEEN SAVED PREVIOUSLY
PK06081
28_Jun
2005
UK04935


REFRESH PRIMARY COMMAND ON PANEL ADB2M1S DOES NOT REFRESH THE DATA AND DISPLAYS UNEXPECTED RESULTS
PK04808
27_Jun
2005
UK04935


ADBTEP2 CAN TRUNCATE THE LAST BUFFER IN THE SYSPRINT STREAM.
PK05608
27_Jun
2005
UK04935


ADMIN TOOL ADBTEP2 DOES NOT RUN A SELECT WITH UR
PQ96584
24_Jun
2005
UK04866


PANEL ADB21SAJ RETURNS MSGISPF107 WHEN REMOVING A COLUMN FROM A CLUSTERING INDEX USING ALTER AND RDEF
PQ99870
24_Jun
2005
UK04866


ADMIN TOOL REORG INDEX UTILITY WITH TEMPLATE USAGE OPTION DOES NOT ALLOW THE USE OF WORKDDN
PK02011
24_Jun
2005
UK04866


ADMIN TOOL PANEL ADB21TAB HAS FIELDPROC ENTRY BUT THE ADB26CTU PANEL DOES NOT
PK02631
24_Jun
2005
UK04850


SMP/E MESSAGES GIM67301W OR GIM40501E RECEIVED DURING APPLY CHECK JOB INSTALLING PTF UQ95784
PK03467
24_Jun
2005
UK04850


ALC OPERATION THAT CAUSES DROP / CREATE SCENARIO CAN PRODUCE DIFFERENT DATASET NAMES FOR UNLOAD AND LOAD STEPS
PK04317
24_Jun
2005
UK04866


INVALID SYNTAX GENERATED FOR RUNSTATS, SORTDEVT IS NOT AN OPTIONFOR RUNSTATS, ERROR SEEN: MSGDSNU049I
PK04325
24_Jun
2005
UK04850


ADMIN TOOL GENERATES INCORRECT DDL FOR A FUNCTION
PK05294
24_Jun
2005
UK04850


INVALID VIEW SYNTAX FROM GEN AND MIG ON JOINED VIEWS WHEN RUNSQLID VALUE IS SPECIFIED
PK05506
24_Jun
2005
UK04850


ADMIN TOOL ALTER INDEX ALL PARTS WITH PROMPT ON USING OPTION 1A PERFORMS CHANGES BUT ALSO SCROLLS THROUGH INDIVIDUAL ALTERS
PK05572
24_Jun
2005
UK04850


ADMIN TOOL GEN AND DDL LINE COMMANDS DO NOT WORK FOR SQL STORED PROCEDURES
PK06201
24_Jun
2005
UK04850


ADMIN TOOL GETS SQLCODE -811 SQLCODE811 ON DDL COMMAND FOR FUNCTION WITH THE SAME NAME AS A STORED PROCEDURE
PK03859
20_Jun
2005
UK04850


PANEL ADB2ZZTR DISPLAY TRUNCATES VALUES FOR START SMF ACCOUNTING SMFACCT FROM DSNZPARM
PK04933
20_Jun
2005
UK04850


INVALID VALUE MESSAGE IN SOME ZPARM DISPLAY PANELS DUE TO A RESIDUAL VALUE PREVIOUSLY ENTERED IN A DIFFERENT PANEL
PK06234
19_Jun
2005
UK04850


AL LINE COMMAND ON AN INDEX MAY NOT WORK AFTER USING THE ALC FUNCTION
PK06554
19_Jun
2005
UK04850


DISPLAY OF TABLESPACE FROM PANEL ADB21TAS FAILS MSGDSNT302I - INVALID NAME -
PQ99931
25_May
2005
UK03839


ALC / REL OF TABLE WITH NO CHANGES, BUT CHANGES TO VIEW OR INDEXRESULTS IN DROP OF ORIGINAL TABLE
PK01244
25_May
2005
UK03839


ADMIN TOOL DDL COMMAND SHOWS WRONG SOURCE FOR AN ALTERED MATERIALIZED QUERY TABLE
PK02020
25_May
2005
UK03839


ADMIN TOOL ALC COMMAND GETS COND CODE 1012 ON THE RENAME OF A BASE TABLE FOR A MATERIALIZED QUERY TABLE
PK02262
25_May
2005
UK03839


ADMIN TOOL QUIESCE UTILITY IS MISSING THE TABLESPACESET OPTION
PK02982
25_May
2005
UK03839


ALC JOB RETURNS ONCODE350 OR ONCODE520 WHEN CHANGING TABLE OWNER OR TABLE NAME WHEN A SYNONYM EXISTS
PK02985
25_May
2005
UK03839


ADMIN TOOL PROMPT OFF OPTION DOES NOT WORK FOR SQLID COMMAND
PK04869
25_May
2005
UK03839


GEN OF AN OBJECT CONTAINING " GENERATED ALWAYS " CLAUSE MAY DROPTHE "GENERATED ALWAYS" CLAUSE .
PK05627
25_May
2005
UK03839


DB2 CATALOG SEARCH DISPLAYS " NO ROWS RETURNED " MESSAGE ON PANEL ADB21 WHEN CATALOG CONTAINS ROWS MATCHING CRITERIA
PK05636
25_May
2005
UK03839


MSGADB209 DURING CATALOG COPY OPERATION - RC42 IN ADB2CC EXEC
PK05911
25_May
2005
UK03839


"CREATE STMT EXECUTED" MESSAGE DOES NOT APPEAR AFTER CREATING AN INDEX
PK04889
25_May
2005
UK03837
UK03839


OBJECT COMPARE GOC2CMP IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PK04811
17_May
2005
UK03544


DB2 ADMIN TOOL FAILS U4038 / U4039 STORAGE FAILURES SEEN DURING GEN AND CLONE FUNCTION PROCESSING
PK00873
11_May
2005
UK03358


ADMIN TOOL ADB2GEN PANEL DOES NOT ALLOW THE USE OF A PDS AS AN OUTPUT FILE DATA SET NAME FOR A WORK STATEMENT LIST
PK03798
11_May
2005
UK03358


ADMIN TOOL WORK STATEMENT LIST CLONE PROCESS DOES NOT CHANGE THETSSGNAME OR ISSGNAME FROM THE MASK SPECIFICATION IN THE DDL
PK04941
11_May
2005
UK03358


SQLCODE206 USING OPTION IP FROM PANEL ADB2Z55 TO LIST IP NAMES
PK05212
11_May
2005
UK03358


PANEL ADB21SAR REQUIRES THAT CONTINUE BE ENTERED TWICE BEFORE THE DATA IS PROCESSED TO CREATE A TABLESPACE
PK04020
9_May
2005
UK03255


ALC FAILURE WHEN ADDING A COLUMN AT THE END OF THE TABLE ALONG WITH COMMENTS/LABELS DROPS THE COMMENTS/LABELS.
PK04800
5_May
2005
UK03358


ADMIN RECEIVES SQLCODE311 WHEN ATTEMPTING TO CLONE A WSL
PQ99873
27_Apr
2005
UK02900


ADMIN TOOL PANEL ADB2ZZPR DOES NOT ACCEPT NATIONAL CHARACTER $ AS THE FIRST CHARACTER IN A DB2 SYSTEM LEVEL AUTHID
PK02254
27_Apr
2005
UK02900


PANEL ADB2ZZMN DOES NOT SUPPORT NEW VALUES FOR ZPARM ACCUMUID UNDER DB2 V8
PK04729
27_Apr
2005
UK02542


A PQ97006 FOLLOW-UP
PK04175
21_Apr
2005
UK02646


GEN LINE COMMAND GENERATES INVALID TRIGGER SYNTAX.
PQ97006
18_Apr
2005
UK02542


FAILURE TO PRESERVE GENERATED ALWAYS CLAUSE BY ALC LINE COMMAND UNDER DB2 V8.
PK00608
18_Apr
2005
UK02542


ADMIN TOOL WORK STATEMENT LIST VALIDATE COMMAND USES WRONG SQLID
PK00865
18_Apr
2005
UK02542


ADMIN TOOL WORK STATEMENT LIST INTERPRET COMMAND GET IBM0534S ONCODE 8094 ABENDS00C4 OR CEE0813S ABENDU4038 IN ADB2WIN
PK01605
18_Apr
2005
UK02542


ALC JOB FAILS IN STEP CHDDL55 WITH JCL ERROR FOR SQLOUT - DATASET NOT FOUND
PK01926
18_Apr
2005
UK02542


ADMIN TOOL SKELETON LIBRARY CUSTOMIZATION IS INCOMPLETE AND INCONSISTENT
PQ99737
18_Apr
2005
UK02542


OBJECT COMPARE WORK STATEMENT LIST LOSES DDL COMMENT CHARACTERS AFTER EDIT
PK02251
12_Apr
2005
UK02542


ADMIN TOOL PANEL ADB21CUR UPDATE RUNSTATS RESULTS IN ERROR
PQ98156
30_Mar
2005
UK01934


MIGRATE JOB FOR TARGET SUBSYSTEM CONTAINS INCORRECT DB2 DATASET NAMES IN CHECK DATA STEP
PQ99408
30_Mar
2005
UK01934


MIGRATE RETURNS ABENDB37 FROM PANEL ADB28M WHEN BUILDING SECOND JOB TO RUN ON SOURCE SYSTEM
PK00224
24_Mar
2005
UK01812


SQLCODE206 EXITING FROM PANEL ADB21DS AFTER DS LINE COMMAND
PK01341
24_Mar
2005
UK01812


ADMIN TOOL WORK STATEMENT LIST INTERPRET COMMAND LABELS SET CURRENT PATH AS SET CURRENT SQLID
PK01931
24_Mar
2005
UK01812


ALTER INDEX FAILS WITH STATEMENT TOO LONG WHEN CHANGING SQTY ON PARTITIONED INDEX VIA PANEL ADB21XA
PK01798
22_Mar
2005
UK01713


SQLCODE804 FROM ALC COLUMN INSERT ON TABLE WITH BOTH COMMENT ON TABLE AND COMMENT ON COLUMNS - EXTRA SEMI-COLON IN CREAT61
STEP
PQ96473
15_Mar
2005
UK01509


SQLCODE104 EXECUTING LONG SQL STATEMENTS FROM FB DATASET
PQ99337
15_Mar
2005
UK01509


A VENDOR-CREATED LINE COMMAND OF "ED" WAS REJECTED WITH AN "INVALID LINE COMMAND" MESSAGE.
PK00073
15_Mar
2005
UK01509


ATTEMPTING TO DELETE TWO WSL'S AT THE SAME TIME MAY ENCOUNTER ISPF ERROR ISRZ002, FOLLOWED BY ISPT061, THEN TOOL FAILURE.
PK00266
15_Mar
2005
UK01509


ADMIN TOOL DOES NOT RETURN TO DB2 SELECTION SCREEN AFTER AN INVALID SUBSYSTEM WAS CHOSEN
PK00741
15_Mar
2005
UK01509


ADMIN TOOL JOBS CAN TIMEOUT ON CHECKPOINT RESTART TABLE
PK00882
15_Mar
2005
UK01509


FROM A DEPENDENT VIEW ON ANOTHER VIEW, ATTEMPTING TO DISPLAY PARENT, RECEIVING "NO ROWS RETURNED"
PQ99982
15_Mar
2005
UK01509


OBJECT COMPARE GETS VARIOUS PARSING ERRORS ON CATALOG INDEXES
PK01511
27_Feb
2005
UK00867


ADMIN TOOL ADB21TA ALTER TABLE PANEL SHOW THE TABLE CREATOR INSTEAD OF THE TABLE OWNERID
PK00486
24_Feb
2005
UK00867


ADMIN TOOL LISTDEF AND TEMPLATE USAGE GIVES UTILITY JCL ERROR
PK01106
24_Feb
2005
UK00867


INTERNAL (PAIRED WITH GOC310 PQ98370)
PQ95456
19_Feb
2005
UK00733


ADMIN TOOL PROMPT DSN ON/OFF COMMAND CAUSES LOCATION LOSS ON ADB21KR PANEL
PQ98735
19_Feb
2005
UK00733


SQLCODE206 FROM DS LINE COMMAND IN PANEL ADB21S UNDER DB2 R610
PK00889
19_Feb
2005
UK00733


ADMIN TOOL CREATE MATERIALIZED QUERY LINE COMMAND RESULTS IN ERROR
PQ99189
19_Feb
2005
UK00733


MSGISPT017 I/O ERROR ON GET - IN STEP T04GAPY IF DATASETS IN ISPTLIB CONCATENATION EXCEED BLKSIZE 7920
PQ97633
10_Feb
2005
UK00442


MSGISRZ002 - SPECIFIED MEMBER 'ADBTEP2' NOT FOUND IN DATA SET(S)FROM FUNCTION ADB2U
PQ97642
10_Feb
2005
UK00442


COMMAND RT RECOVER TOCOPY OMITS DSN IN UTILITY CONTROL STATEMENTWHEN REVIEW/MODIFY OPTIONS IS SET TO NO IN PANEL ADB2US
PQ98144
10_Feb
2005
UK00442


ADMIN TOOL DROP IMPACT REPORT CAN GIVE INCONSISTENT RESULTS
PQ98542
10_Feb
2005
UK00442


ADMIN TOOL TABLESPACE REDEFINITION TO A PARTITIONED TABLESPACE CAN GIVE INCORRECT PARTITIONING INDEX
PQ98896
10_Feb
2005
UK00442


INCORRECT WARNING MESSAGES IN GEN OUTPUT WHEN GENERATING A MATERIALIZED QUERY TABLE
PQ99588
10_Feb
2005
UK00442


UPPER CASE UMLAUT DOES NOT DISPLAY IN PANEL ADB2BRIF
PK00129
10_Feb
2005
UK00442


COMMENTS EXTEND BEYOND COLUMN 72 WITHIN REXX EXEC ADB27A
PK00173
10_Feb
2005
UK00442


ADD SSID FOR TEP2(SKELETON ADB2PSQL)
PK00225
10_Feb
2005
UK00442


GEN PRODUCES INVALID DDL SYNTAX FOR INDEX OF PARTITIONED TABLESPACE WHEN DSNZPARM HAS DECIMAL IS COMMA
PK00297
10_Feb
2005
UK00442


ADMIN TOOL ALTER COLUMN PROCESSING IS MISSING A SEMICOLON ON A DB2 DDL LABEL STATEMENT
PK00392
10_Feb
2005
UK00442


VARIOUS -104 ERRORS IN CONVERTED DDL.
PQ98681
9_Feb
2005
UK00426


VARIOUS FIXES IN MIGRATE
PQ98716
9_Feb
2005
UK00426


DUPLICATE SYSRECXX DATASETS DURING MIG FROM PANEL ADB28T UNDER DB2 R610
PQ97074
31_Jan
2005
UK00142
UK00144


ADMIN ALTER COLUMN INVOLVING A TRIGGER GIVES ERROR UNRESOLVED SYMBOL
PQ98710
31_Jan
2005
UK00144


SQLCODE304 DURING MIG OF LARGE DATABASE
PQ98779
31_Jan
2005
UK00142
UK00144


ADB2GEN GETS USER ABEND CODE 4038 REASON CODE 00000001 ON VIEW IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
PQ99667
31_Jan
2005
UK00144


ADMIN TOOL SOME QUERIES WILL NOT WORK WITH COMMA IS DECIMAL
PQ99970
31_Jan
2005
UK00144


ADMIN FORMATTER FAILS TO SUPPORT QUALIFIED COLUMN NAMES IN THE SET CLAUSE OF THE UPDATE STATEMENT IN DB2 V8
PQ95962
31_Jan
2005
UK00142


IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED FROMCOMPILE UNIT ADB2FMT FROM ADB2GEN
PQ96651
30_Jan
2005
UK00144


DDL TO CREATE DB2 V810 PARTITIONING INDEX IS MISSING THE LIMIT KEY INFORMATION AND RETURNS SQLCODE660
PQ97975
30_Jan
2005
UK00144


ADMIN TOOL DROP IMPACT REPORT PROGRAM CAN GET AN INVALID PLAN NAME WHEN USING A PLAN SUFFIX
PQ98435
30_Jan
2005
UK00144


POOR PERFORMANCE OF GEN COMMAND WHEN PROCESSING LARGE AMOUNTS OF DDL WITHIN DB2 V8 COMPATIBILITY MODE ENVIRONMENT
PQ99342
30_Jan
2005
UK00144


ADMIN TOOL CATALOG COPY INITIAL ACCESS USES ORIGINAL DB2 CATALOGLEADING TO SQL ERRORS
PQ99988
30_Jan
2005
UK00144


INVALID JCL CREATED DURING ALC WHEN RESTORE OPTION IS CHOSEN
PQ98471
30_Jan
2005
UK00144


ALTER INDEX PANEL ADB21XA WILL NEITHER ACCEPT NOR DISPLAY SQTY VALUE LARGER THAN 6 DIGITS
PQ99085
12_Jan
2005
UQ96778

HIPER

DEC NF - REPACKAGING
PQ94314
27_Dec
2004
UK00064


FREEALL FAILS WHEN RUN IN BATCH WITH PROMPT ON FOR BIND, REBIND, FREE
PQ96972
27_Dec
2004
UK00062
UK00064


ADMIN TOOL GEN LINE COMMAND GIVES ERRONEOUS ERROR MESSAGES FOR A VIEW
PQ98829
27_Dec
2004
UK00064


DURING ALC LINE COMMAND WHEN INSERTING A COLUMN AND SWAP TWO OTHER COLUMNS AROUND COULD RESULT IN SQLCODE104
PQ97451
20_Dec
2004
UQ96308


ADMIN TOOL ALC ALTER COLUMN LINE COMMAND DOES NOT PRESERVE THE COLUMN FIELDPROC
PQ98239
20_Dec
2004
UQ96308


ALC FUNCTION TO ALTER TABLE COLUMNS DISPLAYS ONE COLUMN TWICE ON PANEL ADB27C
PQ98299
20_Dec
2004
UQ96308

HIPER

FIXING SPECIFIED INTERNALLY FOUND PROBLEMS FOLLOWED PQ96925
PQ96925
14_Dec
2004
UQ96053
PQ99085

DB2 ADMINISTRATION TOOL RELEASE 510 NEW FUNCTION APAR
PQ98218
14_Dec
2004
UQ96053
PQ99085

A FOLLOW-UP APAR TO THE NEW FUNCTION APAR PQ96925
PQ98111
8_Dec
2004
UQ95784


SHIP UNCHANGED MODULE ADB2REC TO PREVENT IEW2456E FROM HAPPENINGIN BACK LEVEL SMP/E ENVIRONMENT
PQ96383
3_Dec
2004
UQ95845


COUNTER PART OF PQ96382 (I.E. RETRO-FIT OF PQ93863)
PQ89000
2_Dec
2004
UQ95784


WORK STATEMENT LIST PICKED UP CHKPT RECORD THAT BELONGED TO ANOTHER WORK STATEMENT LIST
PQ93648
2_Dec
2004
UQ95784


IBM INTERNALLY FOUND PROBLEMS RELATED TO RI WHEN ADMIN IS RUNNING ON DB2 VERSION 8
PQ94474
2_Dec
2004
UQ95784


ADMIN TOOL STORED PROCEDURE ADB2RCP SHOULD CODE A "DUMMY" WLM ENVIRONMENT PARAMETER
PQ94677
2_Dec
2004
UQ95784


PANEL ADB25TE TRUNCATES DATA IN TEMPLATE TABLE COLUMN DSN TO 46 CHARACTERS
PQ94956
2_Dec
2004
UQ95784


ADMIN TOOL ADB2GEN USING ADB2RE STORED PROCEDURE AND DB2 COMMANDCENTER GETS S0C4 ONCODE 8094
PQ95759
2_Dec
2004
UQ95784


PRIMARY COMMANDS TA AND TV FOR PANEL ADB21 DO NOT WORK AS DESCRIBED IN HELP PANEL ADBH1
PQ95847
2_Dec
2004
UQ95784


IBM INTERNALLY FOUND PROBLEMS IN PANEL ADB2ZF AND ALC ALTER-RELATED DIALOG.
PQ96794
2_Dec
2004
UQ95784


ADMIN TOOL ALTER COLUMN RESULTS IN ADB21SAC MESSAGE AND LOOP IN TSO FROM PANEL ADB27A
PQ96692
2_Dec
2004
UQ95784


OBJECT COMPARE APPLY JOB GETS ADBC200E INTERNAL ERROR MAX PRIM KEY SEQ ^= #KEY COLS
PQ95045
9_Nov
2004
UQ94879


IBM INTERNALLY FOUND PROBLEMS: COMMA MISSING BETWEEN CONSTRAINT CLAUSES, AND ALTER GENERATED JOB FAILED WITH SQLCODE -204
PQ95552
9_Nov
2004
UQ94877
UQ94879


ADMIN TOOL GEN LINE COMMAND GETS U4038 IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED IN ADB2GEN
PQ92541
8_Nov
2004
UQ94488


ISPF ERROR IN PANEL GOCCI IF LINE COMMAND IS INCORRECTLY ENTERED
PQ93863
28_Oct
2004
UQ94488


COUNTER PART OF PQ93847 IN GEN OF ADMIN
PQ94340
28_Oct
2004
UQ94488


GEN LINE COMMAND EXPERIENCING PERFORMANCE DEGRADATIONS WHEN ATTEMPTING TO PROCESS A LARGE AMOUNT OF DDL.
PQ94400
28_Oct
2004
UQ94488


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


WHEN EXITING FROM FREEALL PROCESSING WITH ' PROMPT ON ', PANEL ADB2PSTM IS SEEN MULTIPLE TIMES REQUIRING ADDITIONAL PF3S
PQ95344
28_Oct
2004
UQ94488


GEN COMMAND CREATES INVALID LABEL ON SYNTAX FORTABLE.COLUMN LABELS
PQ94458
14_Oct
2004
UQ93991


ADMIN TOOL PANEL ADB21P REBINDALL COMMAND RESULT IN INVALID KEYWORD ERROR
PQ94467
14_Oct
2004
UQ93991


PANEL ADB21K IS NOT REFRESHED AFTER FREEALL IS EXECUTED
PQ93141
13_Oct
2004
UQ93991


PANEL ADB21DA DOES NOT PRE-POPULATE BUFFER POOL FIELD FROM PRIORPANEL, ADB21D , DURING ALTER DATABASE OPERATION
PQ94047
13_Oct
2004
UQ93991


MESSAGES RECEIVED WHEN REVOKE IMPACT REPORT IS REQUESTED WHILE CONNECTED TO REMOTE SYSTEM
PQ94679
13_Oct
2004
UQ93991


ADMIN TOOL PANEL ADB21TRE DOES NOT SHOW CORRECT RELATED CHILD TABLES
PQ94849
13_Oct
2004
UQ93991


ADMIN REBIND AND BIND PANEL ADB21PR AND ADB21PB DO NOT HAVE ? QUESTION MARK FOR MEMBER AND PKLIST
PQ95617
13_Oct
2004
UQ93991


ADBTEP2 TERMINATES AFTER WARNING ON CREATE TRIGGER
PQ94178
13_Oct
2004
UQ93989
UQ93991


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


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


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


DISPLAY OF INDEXSPACE FAILS FROM PANEL ADB21SAC
PQ95323
13_Oct
2004
UQ93991


LABEL ON STATEMENT NOT SUPPORTED BY COMPARE
PQ95275
12_Oct
2004
UQ93989


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

HIPER

IBM INTERNALLY FOUND PROBLEMS (A FOLLOW-UP TO PQ89787)
PQ94857
5_Oct
2004
UQ93656


ADMIN ADBBIND JOB SHOULD HAVE ENCODING(EBCDIC) CODED ON ALL PLANS AND PACKAGES
PQ95342
5_Oct
2004
UQ93656


ADBBIND COMMENT CHANGES
PQ94792
5_Oct
2004
UQ93656


A FOLLOW-UP TO PQ91227
PQ94224
28_Sep
2004
UQ93375


MOVE LINE COMMAND TO MOVE A TABLESPACE FROM USER / VCAT DEFINED TO STOGROUP DEFINED CAN FAIL
PQ92552
28_Sep
2004
UQ93375


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


ADMIN PANEL ADB2PSTM PANEL APPEARS WITH SET CURRENT SQLID WITH PROMPT ON AND RESET TO DEFAULT AT STARTUP NO ON ENTRY TO
ADMIN
PQ94067
28_Sep
2004
UQ93373
UQ93375


ADMIN DDL AND GEN LINE COMMAND FOR A STORED PROCEDURE DOES NOT PRESERVE THE JARSCHEMA OR JAR_ID CATALOG VALUES
PQ93858
22_Sep
2004
UQ93110


SQLCODE204 FROM PANEL ADB21Q WHEN GENERATING GRANT FOR SEQUENCE
PQ93615
17_Sep
2004
UQ93007


RECEIVING RC20 MSGADB209 MSGADB221S ATTEMPTING TO BUILD JOBS TO CREATE A DB2 CATALOG COPY
PQ93383
14_Sep
2004
UQ92873


MSGISPT034 IN ADB2U RC0 WHEN ATTEMPTING REORG FROM PERFORMANCE QUERY PANEL ADB237 - ISPF DIALOG ERROR
PQ93860
14_Sep
2004
UQ92876

HIPER

UPDATE ADBBIND MEMBER IN SADBSAMP LIBRARY
PQ92279
9_Sep
2004
UQ92710


RUNNING OBJECT COMPARE WSL RESULTS IN ONCODE150 MESSAGE STRINGSZE CONDITION FROM ADB27AC
PQ93617
9_Sep
2004
UQ92708
UQ92710


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


INVOKING SPACE ESTIMATOR FROM PANEL ADB21SA FAILS WITH PANEL ADB2MESG ERROR OR PANEL ADB2MEXG ERROR
PQ93703
9_Sep
2004
UQ92708
UQ92710


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


MISSING QUOTATION MARKS ON TIMESTAMP IN A MULTI-COLUMN INDEX
PQ91227
7_Sep
2004
UQ92710


PANEL ADB2ZZNM DOES NOT DISPLAY NEW DB2 V710 ZPARM UTLRSTRT
PQ91226
7_Sep
2004
UQ92710


ADMIN TOOL ALTER COLUMN ADD COMMENT NOT ADDED WHEN COLUMN ALSO ADDED TO A VIEW
PQ89787
26_Aug
2004
UQ92285


AGU NF
PQ91266
25_Aug
2004
UQ92285


LONG NAME SUPPORT IN HPU ENVIRONMENT
PQ90855
25_Aug
2004
UQ92232


MISSING COLUMN IN PRIMARY KEY AFTER ALTER
PQ91997
25_Aug
2004
UQ92226
UQ92228


ADMIN TOOL IMPROPERLY GENS IMPLICIT AUXILIARY TABLE FOR A LOB COLUMN
PQ90020
24_Aug
2004
UQ92151


CERTAIN VALID ACCOUNT NUMBERS CAUSE FAILURE IN TSO AND BATCH JOBS FOR ART
PQ89586
17_Aug
2004
UQ91885
UQ91887


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


A GROUP OF IBM INTERNALLY FOUND PROBLEMS IN GEN AREA. SEE ERROR DESCRIPTION SECTION FOR MORE INFORMATION.
PQ84624
16_Aug
2004
UQ91881
UQ91883


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
PQ91717
6_Aug
2004
UQ91887


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


CREATE TABLESPACE FAILS WITH SQLCODE -405 OR -104 WHEN LONG TOKEN VALUES SPANNING MULTIPLE LINES
PQ90154
5_Aug
2004
UQ91440


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


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


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


ADMIN TOOL PANEL ADB21SAR RESULTS IN SQLCODE -103
PQ91781
29_Jul
2004
UQ91438


PQ87492 RETROFIT IN ADB410
PQ91765
26_Jul
2004
UQ90866


AE PQ84689
PQ84689
21_Jul
2004
UQ90866


DB2 V8 SUPPORT AND IMS V9 RUN UNDER SUPPORT
PQ84113
21_Jul
2004
UQ90866


MISCELLANEOUS FIXES
PQ91724
21_Jul
2004
UQ90867

HIPER

GRANT ON PANEL ADB21K OR ADB21P ENCOUNTERS ISPF ERROR
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
PQ90213
9_Jul
2004
UQ90513

HIPER

AN I-TYPE APAR THAT FOLLOWS UP THE ROLLUP APAR
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
PQ89687
16_Jun
2004
UQ89661

HIPER

PQ89687 IS THE ROLLUP APAR FOR DB2 ADMIN TOOL RELEASE 510 (FMID H0IH510).
PQ88946
27_May
2004
UQ88993


PANEL ADB2SYS DEFAULT CURSOR POSITION ON COMMAND LINE
PQ84368
27_May
2004
UQ88993


ADMIN ADB2GEN GETS USER ABEND CODE 4038 REASON CODE 00000001 IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED
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
PQ83286
5_May
2004
UQ88110


INCORRECT DDL GENERATED FOR A TABLE WITH A SPECIAL CHARACTER IN THE CONSTRAINT WHICH WILL CAUSE MSGDSNT408I AND SQLCODE104
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
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
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
PQ84119
1_Apr
2004
UQ87223


PANEL ADB21XPH INDEX PART HISTORY INCORRECTLY SHOWS CARD VALUE FROM SYSINDEXPART WITH SYSINDEXPART_HIST CARDF VALUE
PQ85244
15_Mar
2004
UQ86163


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


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


PANEL ADB21OSR RETURNS ISPF DIALOG ERROR WHEN INVALID COMMAND IS ENTERED
PQ84131
15_Mar
2004
UQ86163


OBJECT COMPARE FAILS WHEN PARSING COLUMN WITH NAME OF PRIMARY
PQ81099
9_Mar
2004
UQ85999


ALLOW USE OF AOP AND VIC ON IMS NON FAST PATH ENVIRONMENT
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
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
PQ81746
18_Feb
2004
UQ85267


IBM INTERNALLY FOUND PROBLEMS - TRANSLATE FUNCTION WITH MORE THAN 126 PAIRS OF VALUES
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
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
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).
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
PQ80978
16_Dec
2003
UQ83228


PANEL ADB21SP DISPLAYS 32767 FOR SECONDARY SPACE ALLOCATION INSTEAD OF USING SECQTYI COLUMN FOR CORRECT VALUE
PQ80259
16_Dec
2003
UQ83228


INCORRECT JCL GETS GENERATED WHEN REORG IS CHOSEN, PANEL ADB233,ON THE PARTITIONED INDEXES WITH CLUSTERING
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 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
PQ77829
24_Nov
2003
UQ82498


DRMV50-006E 0008/00E60820 MSG ART CREATING VIC POINT
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
PQ76742
29_Oct
2003
UQ81617


DRMMAP - WITH IMS, DRMMAP DISPLAYS RECORDS OLDER THAN RDAYS
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
PQ76761
19_Aug
2003
UQ79515


MSGDFS163 ON /DIS PSB
PQ68274
19_Aug
2003
UQ79515


IMS V8 BASE COMPATIBILITY
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
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
PQ63592
11_Nov
2002
UQ71652


SPACE MANAGER SM GOES INTO LOOP WHEN DISPLAYING MULTI VOLUME TABLESPACE .
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.
PQ66360
15_Oct
2002
UQ69787


AE PQ65664 FIX COMPLETION
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.
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
PQ63651
13_Sep
2002
UQ69824


BUFFERPOOL FIELD IS TOO SHORT ON PANEL ADB2USOO TO ACCEPT BP16K1FOR ONLINE REORG UTILITY JOB.
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
PQ30352
30_Nov
2001
UQ60842


DVRA1207 INVALID, SEGMENT LENGTH OKAY
PQ28105
29_Jun
1999
UQ32045


WHEN EXTRACTING DATE/TIME DATA USING A-TYPE AND S-TYPE FIELDS DATES ARE ALWAYS CREATED WITH THE 4-DIGIT YEAR IN FORMAT
"19YY".
PQ28124
29_Jun
1999
UQ32046


COMMENCING IN THE YEAR 2000 A DEM SUBMITTED TO RUN IN CONTINUOUSRUN MODE WILL BEHAVE AS IF SUBMITTED IN TERMINATING RUN MODE.
PQ17806
29_Jan
1999
UQ26157


FIELDS ARE SHIFTED AFTER MSG DVRU1418
PQ23096
29_Jan
1999
UQ26158


ABEND S0C4 ON COMPRESSED DATASETS
PN80955
8_Oct
1997
UQ10186


WAIT, HANG OR VARIOUS OTHER SYMPTOMS WHEN INSTALLING DATAREFRESHER ON THE WORKSTATION WITH OS/2 WARP
PN82456
30_Jul
1997
UQ07890


RECEIVE ERROR MESSAGE DVRXE121 RUNNING SAP.
PQ02659
29_Jul
1997
UQ07818


AN ABEND0C4 IN MODULE DVRXSEOW AT OFFSET X'564' ON A LOAD INSTR.CAN OCCUR WHEN USING DATAREFRESHER REM TO EXTRACT DATA FROM
DB2.
PQ00403
11_Feb
1997
UQ01263


ABEND0C4. NO MODULE.
PN80339
29_Jan
1997
UQ00782


PERFORMANCE PROBLEMS DUE TO ENQUEUEING ON 'DDNAME FDTLIB' INSTEAD OF ENQUEUEING ON THE DATASET NAME OF THE FDTLIB
PN79684
5_Nov
1996
UN97488


ERROR MESSAGE DVRXE132 RECEIVED DURING SAP PROCESSING WITH COBOL REDEFINES.
PN83478
23_Sep
1996
UN95756


DATAREFRESHER DATE OUT OF SYNC IN LEAP YEAR
PN70684
28_Nov
1995
UN84768


JCL ERROR IN JOB SUBMITTED TO HOST "UNIT FIELD SPECIFIES INCORRECT DEVICE NAME". DVR9330A - HOST TIMEOUT ON PWS.
PN70506
26_Apr
1995
UN76071
UN76072


MIGRATION OF DXT OBJECTS FROM FDTLIB AND EXTLIB TO DATAREFRESHERDATABASE PRODUCES INCORRECT OUTPUT
PN68641
6_Mar
1995
UN74147


PUNCH EXTID PRODUCES INCORRECT OUTPUT WHEN THE WHERE CLAUSEOF THE EXTRACT REQUEST CONTAINS DBCS CHARACTERS

Top of page


DB2 SQL PA 310
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK78706
14_Apr
2009
UK45756


ISPF TERMINAL 3270KN KATAKANA ISRE741 IN ANLSORT
PK78164
18_Feb
2009
UK44154


ON A DBRM REMOTE BIND EEE IS NOT CONVERTING UNICODE TO EBCDIC
PK78149
18_Feb
2009
UK44154


INCOMPLETE REPORTS FROM ANLEEE
PK76258
8_Jan
2009
UK42990


ABEND0C9 IN CUNMCA2A X'2C0'.
PK66762
30_Sep
2008
UK40348


ANL3031E OVERFLOW CONDITION DETECTED DURING INTERNAL CALCULATIONS. CHECK STATISTICS, CORRECT, THEN RE-RUN PROGRAM.
PK56754
30_Jan
2008
UK33348


EEE538E EXPLAIN OF SUPPLIED SQL-STATEMENT FAILED, SQLCODE -104
PK58852
30_Jan
2008
UK33360


THE USER IS NOT BEING PROMPTED TO CANCEL THE QUERY WHEN ONE OF THE THRESHOLDS HAVE BEEN EXCEEDED.
PK53911
26_Nov
2007
UK31592


DELETE OPERATION DURING INSERT
PK51794
19_Oct
2007
UK30462


SQLCODE -418
PK50134
12_Sep
2007
UK29130


SQLPA DETAIL TRACE REPORT GIVES WRONG INDEX STATISTICS. STATS FOR ONE INDEX MAY BE REPORTED AS FOR ANOTHER INDEX.
PK51210
12_Sep
2007
UK29130


ANLEEE ( EASY EXPLAIN ) FEATURE OF SQLPA REPORTS SHOW DATA FROM INTEGER FIELDS OF CATALOG INFO. THIS APAR CHANGES TO FLOAT
FIELD
PK42853
7_Sep
2007
UK28990


DB2 V9 EXPLOITATION IN THE SQLPA INTERFACE TO THE DB2 OPTIMIZER.
PK48705
7_Sep
2007
UK28990


UK26088 IN ERROR, MISSING A PRE-REQ ON UK26718. 07/07/14 PTF PECHANGE
PK47423
29_Jun
2007
UK26718
PK48705

SQLPA ANLEEE EASY EXPLAIN FUNCTION REPORTS IGNORE MULTIROW MULTI ROW FETCH IN USER PROGRAMS CREATED UNDER DB2 V8.
PK45469
13_Jun
2007
UK26088


IN SQLPA PANEL ANLOPUT RECEIVE ERROR 9001 & "DS DOES NOT EXIST" INSTEAD OF GENERATING NEW REPORT DS AS ELSEWHERE IN PANELS.
PK43853
25_May
2007
UK25548


SQLCODE -104 SQLCODE104 ILLEGAL SYMBOL IN SQLPA WHEN KOREAN CCSID 933 IS IN USE.
PK42851
30_Apr
2007
UK24585


SQLPA ANLUSERN USERIDS CAN BE HUNG AFTER SESSIONS END.
PK40756
11_Apr
2007
UK23920


EEE REPORT LOOPING
PK37292
30_Mar
2007
UK23560


SQLPA DB2 V9 SUPPORT. CATALOG AND DOCUMENTATION CHANGES.
PK39592
6_Mar
2007
UK22739


SQLCODE -418 WHEN DETERMINING THE COST OF A DBRM
PK38017
16_Feb
2007
UK22292


PLAN_TABLE ALIAS OF TYPE='A' IS NOT BEING CREATED.
PK36927
12_Feb
2007
UK22071


PACKAGE NOT FOUND AFTER MIGRATING TO DB2 V8 NFM WHEN NOT0004 USING THE WILDCARD % SIGN. GETTING MESSAGE EEE374W.
PK34964
14_Dec
2006
UK20641


SQLPA PANEL DIALOG PROBLEMS WITH PF3 ACTING LIKE "ENTER" ON SOME PANELS.
PK32601
21_Nov
2006
UK19938


DB2 V9 TOLERATION APAR.
PK30961
8_Nov
2006
UK19527


SQLPA REPORTS SUCCESSFUL ATTEMPT TO CREATE A CLUSTERING INDEX, BUT DB2 REPORTS IT REALLY FAILED.
PK30156
3_Nov
2006
UK19393


USER COMPLETION CODE=4088 REASON CODE=000003EC USING EEE WITHIN SQLPA. SQLPA WILL DELIVER ITS OWN VERSION OF CEEUOPT.
PK32157
16_Oct
2006
UK18841


PERFORMANCE ENHANCEMENT WHEN A JOIN ON SYSIBM.SYSDUMMY1 IS NEEDED.
PK29956
8_Sep
2006
UK17855


DEVELOPMENT APAR TO PROVIDE A NEW MORE USER FRIENDLY FORMAT FOR THE OUTPUT OF THE COST REPORT. TO FULFILL MR111205611.
PK30301
8_Sep
2006
UK17856


WILDCARDS NOT WORKING.
PK28915
22_Aug
2006
UK17408


CREATE INDEX STATEMENT IS NOT POPULATING THE INDEX.
PK26399
21_Aug
2006
UK17367
PK30805

SEVERAL FIXES TO THE EEE COMPONENT OF SQLPA.
PK26397
4_Aug
2006
UK16941


SQLPA RECEIVE DB2 SQLCODE -204 42704 SQLSTATE WHEN USEPLAN IS SET.
PK21665
14_Jul
2006
UK16277


NO SAMPLE JCL ( JOB ) PROVIDED TO BIND PLAN(EEEPLIN). ( 29704 ).
PK23809
9_Jun
2006
UK15294


SQLPA GENERATES SQLCODE -204 204 ( 71114 )
PK24422
9_Jun
2006
UK15296

HIPER

RUNNING ANLPGME7 GETS IEW2646W 4B07 ESD RMODE(24) CONFLICTS WITH USER-SPECIFIED RMODE(ANY) FOR SECTION ANLBPAM.
PK21594
31_May
2006
UK15001


SQLPA R310 RECEIVE MSGANL1016E FATAL SQL ERROR ENCOUNTERED DURING ANL REGISTRY PROCESS W/ SQLCODE 12 IOS OPERATION 9.

Top of page