This is in the CMOD 8.5 readme:
https://www-304.ibm.com/support/docview.wss?uid=swg27020591 (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 |
+--------------------------------------------------+
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!!!!!!
They don't match so you're good to go.
Ed
| Bad update...see further explanation below
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
Quote from: ALF on February 14, 2013, 02:24:11 PM
...
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
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.