SAKMAN UTILITIES

                            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 2: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)'