Migrating to 8.5 or above? What's the DB2 SCCSID?

[Ed_Arnold]

This is in the CMOD 8.5 readme:

https://www-304.ibm.com/support/docview.wss?uid=swg27020591

------------------------------------------------------------------------
* New program ARSMIG85 for linefeed translation
When using OnDemand for z/OS V8.5.0 to access a pre-8.5 OnDemand
database and the ARS_ORIGINAL_CODEPAGE value matches the database
codepage (e.g. ARS_ORIGINAL_CODEPAGE matches the DB2 SCCSID), a new
program, ARSMIG85, must be run to translate EBCDIC newlines to EBCDIC |
linefeeds. |
If the ARS_ORIGINAL_CODEPAGE does not match the DB2 SCCSID, do not run |
the ARSMIG85 program.


How do you know what the DB2 SCCSID is?  You can ask your DBA, or you can run this:

 SELECT SBCS_CCSID, MIXED_CCSID, DBCS_CCSID
   FROM SYSIBM.SYSDATABASE                 
   WHERE NAME = 'ARS850DB'        <<<=====REPLACE WITH YOUR DATABASE NAME


When I ran this on my DB2 V9 system I received the following:

+--------------------------------------------------+
|   SBCS_CCSID   |  MIXED_CCSID   |   DBCS_CCSID   |
+--------------------------------------------------+
|             37 |              0 |              0 |
+--------------------------------------------------+

[ALF]

Hello all - new to CMOD install world and working on a 8.4.0.3 to 8.5 upgrade.
We cannot go to v9 because we are at z/OS 1.11 and will not be upgrading to 1.13 until later this year.
So to stay in support we are upgrading to 8.5 and will move to 9 at a later date.
We have completed the SMP portion and are now starting the "upgrade"
Just one verification for the arsmig85 program -

So my DB2 SCCSID is 037. When ARSSOCKD(8.4.0.3) starts - I get ARS0220I Server code page is 1047.

The code page and SCCSID do not match - so I do not run the ARSMIG85 program - is this correct?

ps - Great site with tons of info - super helpful!!!!!!

[Ed_Arnold]

They don't match so you're good to go.  

Ed

| Bad update...see further explanation below

[Ed_Arnold]

This is in the README:

Run arsdb -u without ARS_ORIGINAL_CODEPAGE in the ars.cfg for
information on the proper setting for ARS_ORIGINAL_CODEPAGE.
An example of running the arsdb -u command without ARS_ORIGINAL_CODEPAGE
in the ars.cfg is:
arsdb: Unable to initialize environment. The return code is -1 -
If this is a new instance, then define ARS_ORIGINAL_CODEPAGE=37 in
ars.cfg. Otherwise if this is an existing instance, then define
ARS_ORIGINAL_CODEPAGE=1047 in ars.cfg. Once set,
ARS_ORIGINAL_CODEPAGE must never change.





Sample JCL for running the arsdb -u command in batch:

//JOBLIB   DD DISP=SHR,DSN=DSN.DB2V810.SDSNEXIT           
//         DD DISP=SHR,DSN=DSN.DB2V810.SDSNLOAD           
//         DD DISP=SHR,DSN=DSN.DB2V810.SDSNLOD2           
//STEP3    EXEC PGM=BPXBATCH,REGION=0M                   
//*                                                       
//*                                                       
//SYSPRINT DD SYSOUT=*                                   
//DSNAOINI DD PATH='/usr/lpp/ars/V8R4M0/config/cli.ini'   
//SYSOUT   DD SYSOUT=*                                   
//STDERR   DD SYSOUT=*                                   
//STDOUT   DD SYSOUT=*                                   
//STDPARM DD *                                           
PGM /usr/lpp/ars/V8R5M0/bin/arsdb -u -I ARCHIVE           
//STDENV DD *                                             
_BPXK_JOBLOG=STDERR                                       
/*                                                       


I just ran it against my 8.4.0 system and this is what's in STDOUT:

********************************* TOP OF DATA ******************************************************************* TOP OF DATA **********************************
 arsdb: Unable to initialize environment. The return code is -1.  If this is a new (created in 8.5) instance, then define ARS_ORIGINAL_CODEPAGE=37 in ars.cfg. 
******************************** BOTTOM OF DATA **************************************************************** BOTTOM OF DATA ********************************





Again the doc says this:

... if this is an existing instance, then define
ARS_ORIGINAL_CODEPAGE=1047 in ars.cfg.

Because this already exists, then the setting will be 1047.

Ed

[Ed_Arnold]

...

When ARSSOCKD(8.4.0.3) starts - I get ARS0220I Server code page is 1047.

The code page and SCCSID do not match - so I do not run the ARSMIG85 program - is this correct?

...

ALF - really you should go by the arsdb -u -I xxxxx command in my previous post.  I steered you wrong.   

Though the chances of those matching is rare.

Ed

[Ed_Arnold]

FAQ:

So Ed, when I bring up ARSSOCKD, I always see the following:

ARS0220I Server code page is 1200

What does that have to do with ARS_ORIGINAL_CODEPAGE or this arsdb -u command that I'm running?


Answer:  Nothing.  Just to make things confusing we're really talking about two different codepage settings:

1. The server code page which is the source of the ARS0220I message above

and

2. The database code page which is what we're concerned about for the ARS_ORIGINAL_CODEPAGE setting.