APAR status
Closed as canceled.
Error description
THIS INFORMATION APAR WILL BE USED TO PROVIDE SEARCHABILITY IN THE PB LIBRARY FOR PROBLEMS WHICH APPEAR WITH SQL SYMPTOMS, BUT THE FIXES ARE IN THE DS LIBRARY. VM55345 - *BLOCKIO users. IUCV I/O satisfied by cache, but still waiting for interrupt. VM53086 - CP apar; SQL symptoms are: MSGARI0925E An error occurred during SQL/DS write I/O operation on DASD 203 DDNAME = DDSK2, return code = 4, rc4, rc04 MSGARI0040E SQL/DS System error occurred ARIYI07 05 VM36404 - VTAM APAR for 2 byte overlay of x'0104'. Any application using a VTAM connection getting incorrout should check for this overlay. Overlay occurs in the Mailbox when the user side receives the data, mailbox good when sent from DB. OVERLAID 0104 program over lay laid. VM44418 - CP rewrote the module that loads segments, especially the area that handles members of two spaces that have the same name. load segment space member BEW VM54071 - Protection exception at offset x'192' in ARIYI64 (92.112) on a MVPG instruction (x'B2540024' - Move Page). BEW VM47116 - MSDMSITP143T Protection exception and MSGARI0294A Archive file 181 write failed, reason=12 code=0. This occurs after the first tape for an archive fills. Although this is a CP apar, CMS **MUST** be rebuilt after applying the apar. (MSGDMSITP143T) VM51058 - MSGARI0294A ARCHIVE FILE 181 WRITE FAILED, REASON=12, RETCODE=0 ON SQL/DS ARCHIVE USING MULTIPLE VOLUME TAPE SUPPORT. VM42045 - USERS DOING DATALOAD AND/OR DATAUNLOAD JOBS GO INTO A WAIT AND NEVER FINISH. IF THE USER IS THE ONLY ONE ACCESSING THE DATABASE, THE COUNTER COMMAND OUTPUT NEVER CHANGES. THIS IS A PE OF VM38627 AND IS ON PUT 9101. OTHER USERS CAN STILL ACCESS AND USE THE DATABASE. VM39775 - SQLCODE -949 REASON CODE 01. MSGARI2903E ERROR LOADING RESOURCE MANAGER OR ADAPTER. CMSLEVEL 5.6 LOCATION X'E5D' = X'0A' SHOULD BE X'08'. CMS WORK UNIT ID, SQLDBMIG SQLDBINS. VM39164 - MSGARI7119E AND MSDMSABN148T ABEND005 WHEN V1SCRIO USED WITH THE DISPLAY COMMAND. CUST ENTERS ISQL WITH V1SCRIO PARM, RUNS QUERY THEN DOES #CP Q TIME AND RECEIVES ABEND. VM36285 - MSDMSSMN133S MSDMSABN148T A0A - SEE VM30786 ALSO VM30786 - MSDMSSMN133S MSDMSABN148T A0A - SEE VM36285 ALSO PROBLEM OCCURS WHEN RUNNING A DBSU JOB CONTAINING A SET LANGUAGE COMMAND. SET LANGUAGE COMMAND SHOULD NOT BE ISSUED FROM WITHIN AN APPLICATION PROGRAM. VM30786 FOR VM/SP - VM31379 FOR VM/XA - VM34987 NLS VM32085 - USER RECEIVES SQLCODE -933, SQLERRD1= 12, SQLERRD2= 113, WHENEVER THE USER MACHINE ATTEMPTS TO CONNECT TO THE DATABASE MACHINE. THIS OCCURS AFTER VM PUT 8902 OR VM32085 IS APPLIED. SEE VM32085 FOR SOLUTION. THE PROBLEM IS THE DEFAULT MAXCONN VALUE FOR THE USER MACHINE IS 0 INSTEAD OF 4 UNLESS AN EXPLICIT 'OPTION MAXCONN 4' IS IN USER'S DIRECTORY. ALSO THE USER MAY RECEIVE MSGARI439E MSGARI0439E SQLCODE -933. EXAMINATION OF THE SMALL DUMP THAT IS PRODUCED BY THIS FAILURE SHOWS SQLERRP = ARIRVRM SQLERRD1 = 12 SQLERRD2 = 11 SQLERRM = 002 VM31335 - SQL023E COPYFILE RC0 RUNNING 5688004 EXEC TO INSTALL VMP8803. MSDMSCPY901T. ADDITIONAL SYMPTOMS REPORTED FIXED BY THIS APAR INCLUDE MSDMSITP141T MSG0S03I AND OTHER UNPREDICTABLE RESULTS DUE TO CORRUPTION DURING THE COPY OF THE SQL/DS LOADLIB. ADDRESSING, OPERATION, PROTECTION EXCEPTION. ARIXRDS ARISQLDS ARISISBT ARIMFMT. VM30792 - PROBLEMS WITH ACCOUNTING INFORMATION WHERE THE VALUES ATTRIBUTED TO A USER ARE MORE THAN THEY SHOULD BE, ARE NEGATIVE (PL18838 IS NOT INSTALLED), OR ARE SLIGHTLY LESS THAN THEY SHOULD BE (PL18838 IS INSTALLED) REQUIRE THIS APAR FOR RESOLUTION. USER RECORD +64 PROCESSOR TIME USED VM28431 - 'SET BLIP ON' IS DEFAULT IF AUTOLOG IS USED. CHARACTERS X'3606' 3606 ARE MOVED INTO THE TIMCHAR FIELD OF THE EXTSECT. USER PROFILE EXEC SHOULD CONTAIN 'SET BLIP OFF' TO REMOVE THE DEFAULT AUTOLOG. VM26302 - MSDMSITP141T ADDRESSING EXCEPTION DMSSOP +X'196' ROUTINE SVC19. ARCHIVE LARCHIVE LOG TRACE TAPE FILEDEF LABELDEF MSDMSTLM428I MSDMSTVS269I VM26188 - MSDMSITS122S IN SVC19, SQL ABEND001 DURING ARCHIVE. WRONG TAPE UNIT REPLY FOR MSGARI299A, OR TAPE FILE PROTECTED. VM27974 - DUP VM24719, SQLEND RECEIVES MSDMSITP141T ADDRESSING EXCEPTION IN TRANSIENT AREA. AFTER FIRST ERROR, NEXT SQLEND CAUSES LOOP ISSUING MSDMSNXD616W. ACCOUNT=D IN SQL STARTUP PARAMETERS. SHUTDOWN VM28125 - MSDMSFRE161T INVALID DMSFRET CALL, ERROR NUMBER 5, RUNNING SQL UNDER ISPF AND QMF. THIS OCCURS WHILE LEAVING QMF, OR RETURNING AFTER A SESSION WAS STOPPED. MSDMSABN152T ABEND0F8 UFDBUSY=20. MSDMSITP141T OPERATION EXCEPTION X'1CD0D2' ARISISBT PROGRAM CHECK OCCURRED WHEN ISQL IS INVOKED FOLLOWING CSP, QMF, ISPF SESSION. VM28422 - HANG, WAIT FOR I/O OR IUCV WAIT PSW. SUSPEND VMPXINT VMRSTAT X'10' VM28944 - SQLCODE -933 PATH SEVERED BY TSAF MACHINE WHEN A LARGE AMOUNT OF DATA HAS BEEN SENT. MSGARI504I SQLERRD1 4 SQLERRD2 7. VM26724 - MSDMSITP143T PROTECTION EXCEPTION IN DMSFRE AT LABEL SFRT, WHILE RUNNING REXX EXEC WHICH INVOKES SQL VIA ANOTHER REXX EXEC. VM25933 - ABENDPRG005 DURING VMBACKUP OF SQL MINIDISKS. DUP OF APAR VM23799. VM25699 - MSDMSTVS273E LABELDEF VOLID (PERM NOT HONORED ACROSS JOB STEPS. FILEDEF LABELDEF ARIARCH ARILARC SCRATCH ARCHIVE OR LARCHIVE TWICE FURING AN SQL SESSION. MSDMSTVS269I. VM23985 - CMSBATCH TIMER RESET TO 7FFFF RUNNING SQL IN BATCH. CMSBATCH FAILS TO REACH SPECIFIED OR MAXIMUM TIME VALUE IF WAITECH TYPE OS ISSUED. DMSITE TIMER INTERRUPT. II01889 - SQLCODE -901 USING VM APL2 AND SQL. MSGARI503E. SEE II01891. VM22799 - ABENDPRG005 DMKIUL USING IUCV, AFTER ONE MACHINE SEVERS CONNECTION (IPL, LOGOFF). ABENDPRG006 IN DMKRGA OR DMKSTK. REG4 CCTBLOK TRQBLOK VMBLOK TRQBCRT REG1 REG2 NICBLOK VM24780 - SQL TERMINATES WITH MSGARI032I, MSGARI042I, MSGARI043I DURING ARCHIVE COMMAND PROCESSING, IF USER REPLIES "REJECT" TO MSDMSTLB446R BAD TAPE LABEL. MSDMSITS122S ERROR IN CALL SVC12, ERROR CODE 516. SVC19 DMSTLB RC32 DMSSOP SVC13 ABENDPRG001. VM21904 - SQLCODE -933 IUCV TARGET PATH SEVERED INTERRUPT ON UNKNOWN PATH. RC20 SEVER ACCEPT VM21469 - MSGARI7602D FOR COMMIT WORK COMMAND UNDER E/S**3 ES3. SH245059 GIVES INCORRECT COMMAND. VM20846 - SQL MACHINE COULD NOT COMPLETE BECAUSE DMKBIO SIZE TABLE MISALIGNED. VM20523 - ARCHIVE, LARCHIVE, EOV PROCESSING, DMSTLB DOES NOT FIND TAPE LABEL. EOT EOV1 STANDARD LABEL TAPE VM20384 - MSDMKDAU500I COMMAND REJECT, UNIT CHECK, ON A DEFINE EXTENT CCW. DMKBIO BUILDS WRONG EXTENT DATA FOR AN FBA DEVICE. D/T3370 D/T3330 D/T9375. VM20312 - DMSDID RC4 FOR DISKID, ALTHOUGH REG1 HAS ZERO IN HIGH ORDER BYTE. MSGARI040E ARIYI22 02. SQLSTART ARISDBMA. MSGARI927E BDISK RC4. VM20074 - MSDMSITP141T ADDRESSING EXCEPTION IN ARIYX25, CALLED FROM ARIYX21 (BOTH IN LOAD MOD ARISDBBT), OCCURS FOR A SELECT AFTER SQL RESTORE. TEOVEXIT STARTUP=R VM18964 - IPCS FORMAT COMMAND DOES NOT WORK FOR SQL DUMPS. PL22328 - MSGARI927E RC=12 ON SQLSTART. MDISK IS OVERLAPPED WITH ANOTHER MDISK OR TEMP SPACE. USED IPF FOR MDISK ALLOCATION AND DIRECTORY IS INCORRECT, ALLOWING THE MDISKS TO OVERLAP. II03350 - MSGARI135E MSGARI136E SQLSTART DBMODE L G N VM32525 - MSDMSITP141T FIXED POINT DIVIDE EXCEPTION IN ARISDBBT. THE FAILING MODULE IS ARICDSPC. ALL SQL USERS WITH ACCOUNTING ACTIVE SHOULD HAVE THIS APAR APPLIED. ABEND0C9 VM36220 - (8903 PUT) SET LANG AMENG (ADD ARI USER CAUSES MSDMSSTT062E, MSDMSSLG346E AND MSDMSSLG332E WHEN VM33407(8901 PUT) IS APPLIED TO USERS SYTEM. VM41272 - MSGARI442E MSGARI0442E A NON SQL/DS MESSAGE HAS BEEN RECEIVED. THE COMMUNICATION PATH HAS BEEN SEVERED BY THE RESOURCE MANAGER. VM39128 - MESSAGES ARI0136E AND ARI0042I RC=113(X'71'). WHEN CONNECTING TO A DATABASE ON A TSAF/VTAM COLLECTION. VM51181: VM/ESA 1.1.1 APAR. SQL/DS SYMPTOMS ARE INSUFFICIENT STORAGE MESSAGES, PARTICULARLY DURING STARTUP. FOR EXAMPLE: msDMSFR0159E AND msgARI0001E AND msgARI0039E DMSFR0159E INSUFFICIENT STORAGE AVAILABLE TO SATISFY FREE STORAGE REQUEST FROM 0056A064 ARI0001E AN ERROR OCCURRED WHILE ATTEMPTING TO OBTAIN STORAGE ARI0039E SQL/DS LIMIT ERROR OCCURRED - ARICIPB 01. OR ARI0039E SQL/DS LIMIT ERROR OCCURRED - ARICIP1 01. ADDITIONAL KEYWORDS: 5749DMS00 5749DMK00 RD73 RD74 RD75 R701 R702 RD96 RD97 RD98 5750ES101 RA00 5748SD1Y0 RA20 RA30 RA35 568800401 RB10 R210 R220 PRCS/00000933 PRCS/00000113 PRCS/00000012 VALU/C933 VALU/C113 VALU/C12 PCSS/CONNECT PCSS/MAXCONN PCSS/MAXCON ARIRVRMC RIDS/ARIRVRM RIDS/ARIRVRMC PRCS/00000011 PRCS/00000012 PCSS/002 MS/ARI439E MS/ARI0439E VALU/CARIRVRM VALU/CARIRVRMC VALU/C11 VALU/C12 MSGARI0136E MSGARI0042I RC = 113 X'71' 568810301 R310 SQLEND ARCHIVE
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
CLOSING TO AVOID RETAIN PURGE.
APAR Information
APAR number
II03101
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
001
Status
CLOSED CAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
1987-09-25
Closed date
1987-09-29
Last modified date
1993-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
13 December 2020