OnDemand User Group

Support Forums => z/OS Server => Topic started by: billgiannelli on March 16, 2021, 04:55:56 AM

Title: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: billgiannelli on March 16, 2021, 04:55:56 AM

our ARSOCKD started task abends with a CC 06 after we upgraded to DB2 v12. We are at CMOD v9.5.
is there anything needed to update for DB2 v12?
thanks
Bill

Title: Re: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: Ed_Arnold on March 16, 2021, 09:30:00 AM

Hi Bill - unfortunately rc=6 is about as generic an error as you can get.

Just taking a swag - what are your OMVS settings?   (D OMVS,L or D OMVS,O)

Do you start ARSSOCKD with the -v (verbose) option?

Are your parms listed in sysout?  If so append them here.

You could also list your LE parms and post them here using this format for the EXEC statement:

//STARTARS EXEC PGM=ARSSOCKD,REGION=0M,TIME=NOLIMIT,MEMLIMIT=10000M,
//  PARM='RPTOPTS(ON)/-S -I ARCHIVE -v'

Ed

Title: Re: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: billgiannelli on March 16, 2021, 10:10:21 AM

now I see:
ARS0013E ARSSOCKD DB Error: Warning:  Unexpected sql_rc -- SQLSTATE=
Not Defined, SQLCODE=-805, File=arssys.c, Line=930                   

But how do i know what to bind?
thanks so much for your help!
Bill

Title: Re: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: billgiannelli on March 16, 2021, 01:00:55 PM

ARS0286I Messaging initialization complete                           
ARS0287I Library server starting                                     
ARS0291I Server instance: ARCHIVE                                     
ARS0295I -------- Start of server configuration information -------- 
Ý@SRV@_ARCHIVE¨                                                       
PROTOCOL=2                                                           
PORT=1445                                                             
SRVR_INSTANCE=ARSDBASE                                               
SRVR_INSTANCE_OWNER=DB2PADM                                           
SRVR_OD_CFG=/usr/lpp/ars/config/ars.cfg                               
SRVR_SM_CFG=/usr/lpp/ars/config/ars.cache                             
SRVR_FLAGS_SECURITY_EXIT=0                                           
HOST=prod1.example.com                                               
                                                                     
ÝCFG¨                                                                 
ARS_ORIGINAL_CODEPAGE=1047                                           
ARS_LANGUAGE=ENG                                                     
ARS_NUM_DBSRVR=5                                                     
ARS_TMP=/ars/tmp                                                     
ARS_PRINT_PATH=/ars/tmp                                               
DB_ENGINE=DB2                                                         
ARS_NUM_OAMSRVR=5                     
ARS_OAM_DB2SSID=DB2P                 
ARS_OAM_PLAN=CBRIDBS                 
ARSMVS_NOMAXROWS_PRIQTY=100000       
ARSMVS_NOMAXROWS_SECQTY=100000       
ARSMVS_NOMAXROWS_INDEX_PRIQTY=100000 
ARSMVS_NOMAXROWS_INDEX_SECQTY=50000   
TZ=EST5EDT                           
ARSSOCK_SNDBUF_SIZE=262144           
ARSSOCK_RCVBUF_SIZE=262144           
ARSSOCK_TCP_NODELAY=1                 
ARS_MIGRATE_ARSOD_OWNER=DB2PADM       
ARS_MIGRATE_SSID=DB2P                 
ARS_MIGRATE_PLAN=ARSZDOCG             
ARS_NUM_LICENSE=3361                 
                                     
ÝCACHE¨                               
SMFS1=/ars1                           
SMFS2=/ars3                           
SMFS_NUM=2                           

Title: Re: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: billgiannelli on March 16, 2021, 01:23:40 PM

where would I find my  omvs setting?
thanks
Bill

Title: Re: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: Ed_Arnold on March 17, 2021, 05:15:34 AM

Quote from: billgiannelli on March 16, 2021, 01:23:40 PM

where would I find my  omvs setting?
thanks
Bill

Don't worry about the OMVS settings now, I'd say that the -805 is the smoking gun.

First thing I'd do is run bind job SDSNSAMP(DSNTIJCL).

Ed

Title: Re: ARSOCKD gets CC 06 after DB2 v12 upgrade
Post by: bgiannelli on March 22, 2021, 04:53:56 AM

thank you so much!
That worked!
Bill