SAKMAN UTILITIES                       printer friendly

Download and Set up Instructions

STEP 1

    1. On PC, unzip the file you have received.

 

STEP 2

    2. Upload (as BINARY) from PC the following datasets:
       2.1  SETCLDSyymmdd into YourPDS(SETCLDS) (about “YourPDS” please read the NOTE below)

       2.2  SETCLPAyymmdd into YourPDS(SETCLPA)
       2.3  SETDAyymmdd      into YourPDS(SETDA)

           

       NOTE: YourPDS is the name of any of your persistent PDSs, like your

                    CLISTs' PDS or JCLs' PDS, with a LRECL=80, into which some small

                    files will be loaded into during this SETUP PROCESS. YourPDS's dataset

                    Management and Storage Classes will be used as SAKMAN UTILITIES

                    datasets' MGMTCLAS and STORCLAS.    

.       

 

STEP 3

     3. On TSO Command Line, issue:

     TSO EX 'YourPDS(SETCLDS)' 'YourPDS'

  

STEP 4

At the "SETUP PANEL I" that shows up,

 

 

SAKMAN               SAKMAN UTILITIES SETUP PANEL I            2007/12/16 22:00

                                                                               

                                                                              

YYMMDD  : 071216  This field will be the suffix for SETUP datasets.                                                                                           

IF your Storage Management System periodically deletes datasets unless they are

allocated with a certain Management and Storage Class,                        

THEN enter the following two fields,                                           

ELSE clear them to spaces.                                                    

                                                                              

The suggested values are based on your MODEL PDS: SXSAKMA.PRIV.SOURCE         

                                                                              

MGMTCLAS: MCLIBS                                                              

STORCLAS: SCTEST                                                               

                                                                              

Press F5 to allocate 2 datasets for uploading the second group of PC files.   

         Then, proceed with the PC-to-Mainframe file transfer process.        

         At the completion of this upload,                                    

Press F6 to start SETUP Process, which takes about 5 minutes.                 

                                                                              

                                                                               

                                                                              

F1=HELP  F3=END  F5=CREATE UPLOAD DATASETS  F6=EXECUTE SETUP                  

  

 change the suggested data if you need, and hit PF5. This will create:
                         '&DSPREFIX..XMITDATA.Dyymmdd' AND
                         '&DSPREFIX..XMITLOAD.Dyymmdd'.

 

NOTE: &DSPREFIX is the &SYSUID unless there is a &SYSPREF defined for all TSO users, in which case &DSPREFIX is &SYSPREF..&SYSUID.

 

 

STEP 5

5. Upload (as BINARY) from PC the following datasets:           ,

       5.1 DATAyymmdd    into ''&DSPREFIX..XMITDATA.Dyymmdd'
       5.2 LOADyymmdd    into '&DSPREFIX..XMITLOAD.Dyymmdd'

 

STEP 6

 

6. If you exited the "SETUP PANEL I" invoked at step 3,
       issue again: TSO EX 'YourPDS(SETCLDS)' 'YourPDS', and hit F6.

 The SETUP process will commence, and it will invoke another  panel, "SETUP PANEL II", by which you will enter  other site-specific information.

 

RDBASE                SAKMAN UTILITIES SETUP PANEL II           12/16/07 22:33

PREFIX OTHER THAN USER ID: _________________________                          

JOBC01: //SXSAKMA1 JOB (X9999),'SAKMAN',CLASS=A,MSGCLASS=Y,NOTIFY=&SYSUID      

JOBC02: ______________________________________________________________________

JOBC03: ______________________________________________________________________

JOBC04: ______________________________________________________________________

JOBC05: ______________________________________________________________________

       If MQSeries Options are to be set up: TEST QMGR: abcd  SYS ID: e081     

SCSQLOAD: sabo.mqload                   SCSQAUTH: lena.mqauth                 

      The following are NOT required for non-DB2 SAKMAN UTILITIES:           

DB2S1: db2t LD1: SYS1.DSNLOAD                 LD2: SYS1.SCEERUN               

   DYN: DSNTEP3   DYNPL: DSNTEP71 DYNLIB: D800.DEVL.RUNLIB.LOAD               

DB2S2: ____ LD1: ____________________________ LD2: ___________________________

   DYN: ________  DYNPL: ________ DYNLIB: ____________________________________

DB2S3: ____ LD1: ____________________________ LD2: ___________________________

   DYN: ________  DYNPL: ________ DYNLIB: ____________________________________

                 DB2 SUBS  SYS ID       DB2 SUBS  SYS ID                      

                 db2t      ____         ____      ____                        

                 ____      ____         ____      ____                        

                 ____      ____         ____      ____                        

                 ____      ____         ____      ____                         

                                                                              

F1=HELP  F3=EXIT  F4=SAVE AS DEFAULT  F6=EXECUTE  F7=GET SYSID                

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This SETUP process will take about 5 minutes, and finish with  the SAKMAN UTILITIES MENU, at which you can start using the tools.

 

 

SAKMAN                    SAKMAN UTILITIES                      12/17/07 00:12

                                                                               

 OPTION    :  _____                                                             

       Please key in the number of your selection, and press ENTER.            

       Available options are in green. To download others: Sakman.com.         

                                                                                

 1. RDBA                                                                       

     DB2 OPTIONS                                                               

        BROWSE, EDIT, QUERY/DYNAMIC SQL MAINTENANCE AND EXECUTION, UTILITIES   

     VSAM, QSAM (FLAT FILE) OPTIONS                                            

        VSAM/QSAM BROWSE, VSAM EDIT, VSAM QUICK EDIT, UTILITIES                

 2. EXPRESS TOOLSET                                                             

     2.1 DB2/VSAM EXPORTER THRU SQL       2.5 VSAM EXPORTER THRU A DRIVER FILE 

     2.2 DB2 EXPORTER THRU A DRIVER FILE  2.6 VSAM MAINTAINER THRU A DRIVER FILE

     2.3 DB2 MIGRATOR (UNLOAD/QUICK LOAD) 2.7 MQ IMPORTER/EXPORTER             

     2.4 DB2 LOAD                                                              

 3. EXPRESS SORTWARE                                                           

     3.1 SORT/COPY        3.5 STATISTICS        3.9 DUPLICATE MANAGEMENT       

     3.2 SUMM. BY GROUPS  3.6 VERIFY            3.10 SET RETCODE ON REC CNT    

     3.3 SORT-MERGE       3.7 UNIQUE VALUES     3.11 REPORTER                  

     3.4 FILE MATCHING    3.8 SPLIT/MULTIPLY DS 3.12 SETUP                     

                                                                                

 F1=HELP  F3=EXIT  F4=SAVE AS DEFAULT  F5=REFRESH SYSPROC  

 

 

 

     For subsequent use of SAKMAN UTILITIES, either place the director
    CLIST of the tool, prefix.PADEST.CLIST(SAKMAN), into your common
    CLIST libraries, or simply issue TSO EX 'prefix.PADEST.CLIST(SAKMAN)'

 company         mainframe tools        clients        contact us       terms and conditions