InfoSphere Optim

 View Only
  • 1.  Extract/Insert Processing in Batch via PGM=FOPMAIN

    Posted Wed December 05, 2018 08:15 AM
    Edited by System Fri January 20, 2023 04:13 PM

    Hello.

    I've got a question about customization of Optim.

    Our Development uses Exctract/Insert processing in Batch to provide Test-Data in several Subsystem.

    Our Optim Customization uses Aliases to provide the correct Libraries.

    e.g.

    generated Job:

    //MDB2PROC    EXEC PGM=FOPMAIN,                           
    //            PARM='CON UTILITY DB2F FOP1130 SCHED SCHED '
    //STEPLIB     DD DSN=DBS1.OPT.T1.SFOPLLIB,     
    //            DISP=SHR                         
    //            DD DSN=DBS1.DB2.T1.RUNLIB.LOAD,  
    //            DISP=SHR                         
    //            DD DSN=DBS1.DB2.T1.SDSNEXIT,     
    //            DISP=SHR                         
    //            DD DSN=DBS1.DB2.T1.SDSNLOAD,     
    //            DISP=SHR                        

    but it had to look like:

    //MDB2PROC    EXEC PGM=FOPMAIN,                           
    //            PARM='CON UTILITY DB2F FOP1130 SCHED SCHED '
    //STEPLIB     DD DSN=DBS1.DB2F.SFOPLLIB,          
    //            DISP=SHR 
    //            DD DSN=DBS1.DB2F.RUNLIB.LOAD,       
    //            DISP=SHR  
    //            DD DSN=DBS1.DB2F.SDSNEXIT,          
    //            DISP=SHR  
    //            DD DSN=DBS1.DB2F.SDSNLOAD,          
    //            DISP=SHR 


    DBS1.OPT.T1.SFOPLLIB, SMPE-Target Lib
    DBS1.DB2F.SFOPLLIB,  ALIAS targeting to SMPE-Lib For every SubSys different

    In SFOCLST(FOPCUST ) I found only

    With this, plus some Binds we are able to change to implement changes very quick.

    Do anyone have an idea how we can customize the product to get what we want to?


    regards michael



    ------------------------------
    Michael Beermann
    DBA and SYSPROG
    ------------------------------
    #InfoSphereOptim
    #Optim


  • 2.  RE: Extract/Insert Processing in Batch via PGM=FOPMAIN

    Posted Thu December 06, 2018 04:08 AM
    Hi Michael,

    Did you try the customization as described here:
    https://www.ibm.com/support/knowledgecenter/SSC623_11.3.0/com.ibm.nex.optimz.customizing.doc/Chapter4/opzinstall-r-Customize_the_Batch_Environment.html

    Regards,
    Fritz

    ------------------------------
    FRIEDRICH PFNEISL
    Optim SME
    Austria
    ------------------------------



  • 3.  RE: Extract/Insert Processing in Batch via PGM=FOPMAIN

    Posted Mon December 10, 2018 10:16 AM

    Hi Friedrich.

    I give it a try, but STEPLIB still looks similar to before


    FOPIBP01 -- Supply Optim Batch Parameters ------------------------------------
    COMMAND ===>

    Product Skeleton Library ===> 'DBS1.DB2X.SFOPSENU'
    Product Load Library ===> 'DBS1.DB2X.SFOPLLIB'
    Enter Additional Batch STEPLIB Libraries ===> YES (Y-Yes, N-No)
    such as, non-LNKLST DB2 Libraries and/or Alternate Utility Libraries

    Batch Region Size ===> 0M (0-2047 megabytes; 0M requests Max Region Size)

    Permanent Dataset Defaults: Temporary Dataset Defaults: Tape Defaults:
    Unit Type ===> SYSDA Unit Type ===> SYSDA MaxUnit ===> 1
    Primary CYLS ===> 3 Primary CYLS ===> 3

    Utility Block Sizes: Load Input File ===> 0 Image Copy File ===> 0
    Use SMS for New Load and Image Files ===> Y (Y - Yes, N - No)
    Image Copy Dataset Name Suffixes: (1-4 characters)
    COPYDDN Backup ===> BKUP RECOVERYDDN ===> RECV RECOVERYDDN Backup ===> REBK

    ********************************** N O T E S **********************************
    * You must have authority to update the Skeleton Library *
    * to complete this function successfully. *
    *******************************************************************************

    Both DS marked as bold will be resetted to the values before:

    'DBS1.OPT.T2.SFOPSENU'
    'DBS1.OPT.T2.SFOPLLIB'

    On next Panel I changed the DB2-Libs. The  Values are persistent

    FOPIBP02 -- Supply Additional Batch STEPLIB Libraries ------------------------
    COMMAND ===>

    Product Load Library : DBS1.OPT.T2.SFOPLLIB
    Site Column Map Load ==>

    DB2 Libraries (required if not included in LNKLST):
    DB2 User Load Library ==> DBS1.DB2X.RUNLIB.LOAD
    DB2 Exit Load Library ==> DBS1.DB2X.SDSNEXIT
    DB2 Load Library ==> DBS1.DB2X.SDSNLOAD
    DB2 Template Library ==>

    Alternate Utility Libraries:
    Utility Load Library ==>
    If BMC Utilities:
    SMS Service Routine ==>

    ********************************** N O T E S **********************************
    * You must have authority to update the Skeleton Library *
    * to complete this function successfully. *
    *******************************************************************************

    Generated Job looks like before:

    //OPTIM#Q JOB ('52600,0000,0015',T),DASM,MSGLEVEL=(1,1),
    // MSGCLASS=X,CLASS=A,NOTIFY=&SYSUID
    //*
    //*
    //* )) JOB GENERATED BY :
    //* )) IBM'S INFOSPHERE OPTIM V11.3.0
    //*
    //* NAME: FOPDARCH
    //*
    //MDB2PROC EXEC PGM=FOPMAIN,
    //* LVM
    // PARM='CON UTILITY DB2X FOP1130 &SYSUID M526015 ',
    // REGION=0M
    //STEPLIB DD DSN=DBS1.OPT.T2.SFOPLLIB,
    // DISP=SHR OPTIM LOAD LIBRARY
    // DD DSN=DBS1.DB2.T3.RUNLIB.LOAD,
    // DISP=SHR DB2 USER LIBRARY
    // DD DSN=DBS1.DB2.T3.SDSNEXIT,
    // DISP=SHR DB2 EXIT LOAD LIBRARY
    // DD DSN=DBS1.DB2.T3.SDSNLOAD,
    // DISP=SHR DB2 LOAD LIBRARY


    Did I missed some activation of changes i did?.

    regards michael



    ------------------------------
    Michael Beermann
    ------------------------------



  • 4.  RE: Extract/Insert Processing in Batch via PGM=FOPMAIN

    Posted Tue December 11, 2018 02:30 AM
    Hi Michael,

    And you checked this requirement:
    ********************************** N O T E S **********************************
    * You must have authority to update the Skeleton Library *
    * to complete this function successfully. *
    *******************************************************************************

    Regards,
    Fritz

    ------------------------------
    FRIEDRICH PFNEISL
    Optim SME
    Austria
    ------------------------------



  • 5.  RE: Extract/Insert Processing in Batch via PGM=FOPMAIN

    Posted Tue January 08, 2019 07:44 AM

    Hello Friedrich.


    Sorry for the delay.

    I needed to swap to another SUBSYS what is not used by our Dev.

    My result after using what is described in:

    https://www.ibm.com/support/knowledgecenter/SSC623_11.3.0/com.ibm.nex.optimz.customizing.doc/Chapter4/opzinstall-r-Customize_the_Batch_Environment.html

    //MDB2EXTR EXEC PGM=FOPMAIN,
    //* LVM
    // PARM='CON UTILITY DB2X FOP1130 &SYSUID M526015 ',
    // REGION=0M
    //STEPLIB DD DSN=DBS1.OPT.T2.SFOPLLIB,
    // DISP=SHR OPTIM LOAD LIBRARY
    // DD DSN=DBS1.DB2X.SFOPLLIB,
    // DISP=SHR OPTIONAL COLUMN MAP LIBRARY
    // DD DSN=DBS1.DB2.T1.RUNLIB.LOAD,
    // DISP=SHR DB2 USER LIBRARY
    // DD DSN=DBS1.DB2.T1.SDSNEXIT,
    // DISP=SHR DB2 EXIT LOAD LIBRARY
    // DD DSN=DBS1.DB2.T1.SDSNLOAD,
    // DISP=SHR DB2 LOAD LIBRARY

    New STEPLIB is now allocated, but we do need to have the bold marked lib as first one, because that's the one we want to change.
    I found in SFOPSAMP(FOPCSSN) a description how to change the DB2-Libs dynamically.
    That is something I want to have for the SFOP-Libraries, too.

    https://www.ibm.com/support/knowledgecenter/SSC623_11.7.0/com.ibm.nex.optimz.customizing.doc/Chapter2/opzinstall-r-Set_Up_the_Optim_CLISTs.html

    For SFOPCUST there is only described how to set the Lib-Names once:

    Library NamesUpdate the QUAL1 and QUAL2 definitions to match the first two qualifiers of your Optim™ installation, if you did not use the default values. Note: The DSN prefix for your Optim installation must not exceed a length of 19 bytes.

    SET QUAL1 = high level DSN qualifier
    SET QUAL2 = middle level DSN qualifier   

    QUAL2 is the one we want to have unique for every Db2-Subsys.

    regards michael



    ------------------------------
    Michael Beermann
    ------------------------------