Author Topic: List of Performance Related Fixes plus a Brief Checklist, Upgrading CMOD on z  (Read 2356 times)

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
I was asked for a brief checklist for items in addition to the migration instructions, sharing it here:

  • If migrating to V8.5 or above for the first time, are you comfortable with the ARS_ORIGINAL_CODEPAGE setting you'll be using?
     
  • do you understand why you see this message ARS0220I Server code page is 1200 ?   Note that your ARS_ORIGINAL_CODEPAGE setting is probably not 1200.
     
  • are you using the new ARSSOCKD parms of "-S -I [instance] -v"?

    Reference:

    http://www.odusergroup.org/forums/index.php?topic=762.0

     
  • Is this CMOD instance on the same LPAR or on a different LPAR than your test system?  If on a different LPAR, ensure that your OMVS settings are the same or greater on the new LPAR.   (operator commands   D OMVS,L and D OMVS,O to check)
     
  • If not already in production, have all DB2 PTFs from the following web pages at least received into your DB2 SMP/E:

    http://www.odusergroup.org/forums/index.php?topic=1525.0

    http://www.odusergroup.org/forums/index.php?topic=1318.0
     
  • Have all CMOD PTFs received into your CMOD SMP/E.  Ensure you have received the CMOD PTF for APAR PI42688 which corrects an error in an error message
     
  • the most common error reported to Level 2 after an upgrade from V8.4.1 or before to V8.5 or above is the restriction that the OS/390 Indexer will now report when an index value is not found and no default value is specified.

    The error message you receive when encountering this will be, for example "8 fields submitted by the indexer, 12 expected"

Ed
« Last Edit: December 15, 2015, 08:16:51 AM by Ed_Arnold »
#zOS #ODF

geoffwilde

  • Administrator
  • Full Member
  • *****
  • Posts: 246
  • z/os erm icn webi
    • View Profile
Re: Brief Checklist, Upgrading CMOD on z
« Reply #1 on: June 19, 2015, 11:24:33 AM »
Thanks Ed!
President, OnDemand Users Group
Lead Technician for Content Manager OnDemand @
US Bank
#zSeries

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
Checklist of Performance Related Fixes
« Reply #2 on: July 29, 2015, 01:47:57 PM »
      • PI10044 contained two different improvements:                           
                                                                                 
        (a) better storage management.  no action required to exploit.           
                                                                                 
        (b) delays due to lock contention.  The following ACTION must be taken   
            to improve performance:                                             
                                                                                 
            If installing on CMOD 8.5, the SARSINST(ARSUSECX) must be           
            re-assembled and re-linked after the APPLY.).                       
         
      • PI15871 The ARSLOAD executable is larger than necessary.  This results   
        in increased CPU and EXCPs when ARSLOAD is fetched into memory.         
                                                                                 
        Action required:  None.  Just APPLY the PTF   
                                   
      • PI15930 High CPU ARSYSPIN and ARSLOAD is being fetched into storage     
        every time it was ATTACHed.                                             
                                                                                 
        Action required:  None.  Just APPLY the PTF 
                                   
      • PI22584 ODF performance improvement, reduce the number of program       
        fetches for cobol exits.                                                 
                                                                                 
        Action required:  None.  Just APPLY the PTF   
         
      • PI20473 which is a DB2 APAR whose symptoms have been unearthed by CMOD


      • (Added 11/2/2015) PI50742 390 INDEXER PERFORMANCE IMPROVEMENT.                                                 
                                                                                 
        Action required:  None.  Just APPLY the PTF
         
      • (Added 12/8/2015) 9.5.0.3 rollup PTF includes exploitation of hardware compression/decompression

        Action required:  None.  Just APPLY the PTF.  However, it does require a certain level of CPU.

        (Updated 2/25/2016)  9.5.0.4 changes the action required extensively.   You must read the following technote in order to implement h/w compression:

        http://www-01.ibm.com/support/docview.wss?uid=swg27046215
« Last Edit: February 25, 2016, 10:19:44 AM by Ed_Arnold »
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
Modifying a post doesn't bump this topic up on the age list.

So this is a bump as I feel it's worth raising the visibility of the List of Performance Related Fixes.

Ed
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
Bump for h/w compression update
« Reply #4 on: February 25, 2016, 10:20:54 AM »
Bump for the h/w compression update rolled out in 9.5.0.4.

Ed
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
One of the changes starting in CMOD V9.0.0 is that the ARSANN table now contains LOBs which can possibly waste a lot of space.           
                                                                           
For more consult the following...       

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/W7c1e3103820b_4d9e_add6_b5ade3280dcb/page/Inline+LOBs+%28Large+Objects%29                                     
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
Universal Table Spaces
« Reply #6 on: November 14, 2016, 12:50:26 PM »
If you haven't already, consider moving to Universal Table Spaces (UTS). See the DB2 Knowledge Center for more information.

http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/intro/src/tpc/db2z_universaltablespaces.html
 
The essential information from the Knowledge Center is:

You can alter existing table spaces to universal table spaces by using the ALTER TABLESPACE statement. If your database contains any simple table spaces, you should alter them to universal table spaces as soon as possible.

Related to this is a recommendation received:

IF you have a high number of applications per application group (we've seen this work particularly well when it's a few hundred)

AND IF you see a high number of DB2 getpages after moving to 9.5 or above

AND IF you see large increase in CPU consumption in the DB2 address space after moving to 9.5 or above

THEN moving the ARSAPP table to a Universal Table Space (UTS) and implementing inline LOBs is recommended.


http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/perf/src/tpc/db2z_improveperformanceoflobdata.html
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
z/OS Parms for DB2 Performance
« Reply #7 on: October 25, 2017, 10:34:11 AM »
At its heart, CMOD is a DB2 application.

There are two operating system parms that I'm aware of to benefit DB2.

I'm not going to go into detail on them as they're easily google-able.

1. USEZOSV1R9RULES(NO)

Set via your DIAGxx.

Can also be implemented dynamically with a SET DIAG=xx command.

To see if you have this enabled use the operator command D DIAG

Quote

D DIAG                       
IGV007I 12.36.01 DIAG DISPLAY
...     
VSM USEZOSV1R9RULES(NO)     
...

2. MEMDSENQMGMT:  ENABLE

Set via your ALLOCxx

Can also be implemented dynamically using SETALLOC SYSTEM,MEMDSENQMGMT=ENABLE

To see if you have it enabled use the operator command D ALLOC,OPTIONS

Quote

D ALLOC,OPTIONS                 
IEFA003I 13.19.40 ALLOC OPTIONS
SPACE           foo                   
UNIT            foo           
TIOT            foo           
SDSN_WAIT       foo       
VOLUME_ENQ      foo         
VOLUME_MNT      foo         
SPEC_WAIT       foo         
ALLC_OFFLN      foo         
CATLG_ERR       foo     
2DGT_EXPDT      foo         
VERIFY_VOL      foo         
SYSTEM          foo
                MEMDSENQMGMT:     ENABLE

Note:  if implementing dynamically I believe you need to bring up DB2 after the parms are set.

I have no benchmarks, sorry.

Ed

#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
Is your shop overriding the default LE values shipped with CMOD?
« Reply #8 on: December 05, 2017, 10:54:24 AM »
CMOD has its own defaults for LE storage settings such as HEAP and HEAPPOOLS.

If you feel you must override the default settings be sure to do the LE storage tuning exercise.

Note: the defaults are bigger in V10.1 than V9.5 which are bigger than the defaults in V8.4.1.

Use the LE option RPTOPTS(ON) to determine what your settings are and where they're set.  RPTOPTS(ON) costs nothing in performance, just writes the options in use to SYSOUT.

One way to specify RPTOPTS(ON):

Quote

//ARSSOC95 EXEC PGM=ARSSOCKD,REGION=0M,TIME=NOLIMIT,
//  PARM='RPTOPTS(ON)/-S -I ARCH950 -v'

Ed

#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
(Reference my previous post)

And just what are the LE settings set by the CMOD product?


Content Manager OnDemand for z/OS - Initial Recommended LE Settings

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


Note that bigger is usually better.  I would be concerned only if I had overridden the default LE values to less than their defaults, especially for HEAP.


There is no substitute for doing the LE tuning exercise.

Ed
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
What other performance enhancements should a shop be investigating?

1. For running in a SYSPLEX, the auto-tuning of the JES2 checkpoint first available in z/OS V2.2 is recommended:

https://www.ibm.com/support/knowledgecenter/SSLTBW_2.2.0/com.ibm.zos.v2r2.hasa300/has2v5_automatic_approach.htm


2. Ensure your COFVLFxx, at a minimum, has the following specified:

Quote

CLASS NAME(CSVLLA)        /* Class name for Library Lookaside @P2C*/
      EMAJ(LLA)           /* Major name for Library Lookaside @P2C*/
CLASS  NAME(IRRSMAP)      /* OpenMVS_RACF SMAP Table */               
       EMAJ(SMAP)         /* Major name = SMAP       */               
CLASS  NAME(IRRGMAP)      /* OpenMVS_RACF GMAP Table */               
       EMAJ(GMAP)         /* Major name = GMAP       */               
CLASS  NAME(IRRUMAP)      /* OpenMVS_RACF UMAP Table */               
       EMAJ(UMAP)         /* Major name = UMAP       */               
CLASS  NAME(IRRGTS)       /* RACF GTS Table          */               
       EMAJ(GTS)          /* Major name = GTS        */               
CLASS  NAME(IRRACEE)      /* RACF saved ACEEs        */               
       EMAJ(ACEE)         /* Major name = ACEE       */               

Ed
« Last Edit: June 01, 2018, 11:43:29 AM by Ed_Arnold »
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 785
    • View Profile
At z/OS V2.1 a new version or release was made for zFS V1.5 or V5 depending on who you're talking to.

I talked about this here:

www.odusergroup.org/forums/index.php?topic=1710

There's a great testimonial on the web here:

https://groups.google.com/forum/#!topic/bit.listserv.ibm-main/CLBgzhjJPQk

Ed
#zOS #ODF