Author Topic: Recommended DB2 on z/OS Service, V12  (Read 622 times)

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 833
    • View Profile
Recommended DB2 on z/OS Service, V12
« on: January 08, 2018, 02:42:53 PM »
ABEND04E RC00E70005 AT DSNXRRID M107 WHEN SORT PUTS RIDS IN WORKFILE AND RLF TIME LIMIT IS EXCEEDED   

http://www-01.ibm.com/support/docview.wss?uid=swg1PI82133 

APAR was exposed by CMOD. 

Ed             
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 833
    • View Profile
DB2 ABEND 00C90101
« Reply #1 on: March 23, 2018, 12:55:21 PM »
DB2 ABEND 00C90101

From DB2 Level 2 description:

Quote
This is a known problem to us.   It has to do with synchronization of a
shadow copy of a DBET (Database Exception Table - Internal to DB2 )     
entry with its master copy in the SCA.  There's small timing window   
where an object,  a NPI has grown a new piece,  but this info hasn't   
been sync'd with the member shadow copies.  This discrepancy causes the
sanity check to kick off which subsequently causes the abend.           
                                                                       
In this case it was for UNIQUE INDEX xxxxxxxxxxxxxx built on table     
yyyyyyyyyyyyyy which is in a PBG tablespace with MAXPARTS 1000.     
                                                                       
This abend is from PI58369 / UI44629 which is marked PE.   We recommend
that you remove this ptf to circumvent this abend.  If not,  you can   
apply the Fixing APAR PI87946 / UI51196.           

UI51194 for DB2 V12
#zOS #ODF

Nolan

  • Global Moderator
  • Full Member
  • *****
  • Posts: 126
    • View Profile
Re: Recommended DB2 on z/OS Service, V12
« Reply #2 on: May 16, 2018, 10:35:32 AM »
Thanks, any other requirements for DB2 V12 with V9.5 of CMOD?
J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 833
    • View Profile
Re: Recommended DB2 on z/OS Service, V12
« Reply #3 on: May 16, 2018, 01:27:23 PM »
Thanks, any other requirements for DB2 V12 with V9.5 of CMOD?

None that we've found.  CMOD itself doesn't exploit any new DB2 function. 

Ed
« Last Edit: May 16, 2018, 01:29:09 PM by Ed_Arnold »
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 833
    • View Profile
Re: Recommended DB2 on z/OS Service, V12
« Reply #4 on: August 08, 2018, 11:23:05 AM »
Symptom:

After rolling out service to Db2 products, ARSSOCKD starts, hangs, and abends S0C4.

The successful startup message...

   ARS0351I The ARSSOCKD instance ARCH1010 is ready

...is never produced.
___________________________________________________________

Looking at the dump:

PSW=47042001 80000000 00000000 11769074                           
    (Running in PRIMARY, key 0, AMODE 64, DAT ON, SUPERVISOR STATE)
    Enabled for PER I/O EXT MCH                                   
Unable to identify the area at ASID(X'00A3') address 11769074.     
  ASCB166 at F96400, JOB(ARSTECH1), for the home ASID             
  ASXB166 at 9FD000 and TCB166V at 9C62E8 for the home ASID       
  HOME ASID: 00A6 PRIMARY ASID: 00A3 SECONDARY ASID: 00A6         
                                                                   
  General purpose register values                                 
     0-1  00000000_18616C48  00000000_129FE000                     
     2-3  0000030E_00000000  00000000_12A1D000                     
     4-5  00000000_1245E380  00000000_129FE000                     
     6-7  00000000_11DF1CA0  0000030E_04AC1D08                     
     8-9  00000200_40500240  0000030E_04AC1D08                     
    10-11 00000000_00000008  0000030E_04AE5630                     
    12-13 00000000_1A0D7EE8  00000000_7E655800                     
    14-15 0000030E_04AC2488  00000000_11769FF4                     


LIST 11769074. ASID(X'00A3') POSITION(X'-04') LENGTH(X'08') INSTRUCTION 
11769070 | 50F0 A000      | ST      R15,X'0'(,R10)                       
11769074 | 5050 A004      | ST      R5,X'4'(,R10)                       


R10 is the base.   Looking back up we see (the psw is this 0x1074)

11768000   A7F40055   00000000   12A1D000   C3D8C3D4   | x4.......~}.CQCM |
11768010   C5E2C2F1   F1F1F040   4040F0F1   61F2F261   | ESB1110   01/22/ |
11768020   F1F8F1F5   4BF4F440   C8C3D8C3   F1F1F040   | 1815.44 HCQC110  |
11768030   D6E2A9F1   4BF94000   D7C9F9F0   F8F5F740   | OSz1.9 .PI90857  |
11768040   E2D440C3   D8C3F0F0   F4F65C40   F5F6F5F5   | SM CQC0046* 5655 |
11768050   60E5F4F2   40B440D9   D6C3D2C5   E340E2D6   | -V42 . ROCKET SO |
11768060   C6E3E6C1   D9C56B40   C9D5C34B   40F1F9F9   | FTWARE, INC. 199 |
11768070   F96B40F2   F0F1F840   C1939340   D9898788   | 9, 2018 All Righ |
11768080   A3A240D9   85A28599   A585844B   40000000   | ts Reserved. ... |
11768090   40404040   40404040   C0F403D1   0A8F0700   |         {4.J.... |


Likely candidates for this problem are PI97869 or maybe PI97867.

But it's not a CMOD problem - contact Db2 support.

Ed

#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 833
    • View Profile
Re: Recommended DB2 on z/OS Service, V12
« Reply #5 on: August 09, 2018, 09:20:19 AM »
Just FYI - here's the level of Db2 V12 we're currently running:

DSNG007I  -DSNC DB2 CATALOG LEVEL (V12R1M500 ) 
        CODE LEVEL (V12R1M502 )                       
        CURRENT FUNCTION LEVEL (V12R1M501 )           
        HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M501 )
DSNR002I  -DSNC RESTART COMPLETED
       

Ed             
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 833
    • View Profile
Re: Recommended DB2 on z/OS Service, V12
« Reply #6 on: January 10, 2019, 12:11:55 PM »
Just noting that there's nothing new under the sun, haven't exposed any Db2 defects lately.

Still at:

DSNG007I  -DSNC DB2 CATALOG LEVEL (V12R1M500 )   
        CODE LEVEL (V12R1M502 )                       
        CURRENT FUNCTION LEVEL (V12R1M501 )           
        HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M501 )
DSNR002I  -DSNC RESTART COMPLETED   


Ed                 
#zOS #ODF