Difference between revisions of "Running HPUX Jobs Manually"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Created page with "==Summary== The following information is a detailed overview of each of the Vital Signs Jobs and their supported parameters. ==JVSLOAD_MBRSHLN== This job extracts informatio...")
 
>Johno
(JVSRELOAD)
 
(10 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
This job extracts information from member-file, share-file, loan-file and loanapp.
 
This job extracts information from member-file, share-file, loan-file and loanapp.
  
 +
<pre>
 +
  Syntax:
 +
  /VSJOBS/JVSLOAD_MBRSHLN [eom | restore] [YYYYMMDD]"
 +
 +
  - eom        Process eom, use the report database."
 +
              o uses the vsdata_eom profile in vsrvtcp.ini
 +
 
 +
  - restore    Restoring data from backup, use the specified date.
 +
              o uses the vsdata_restore profile in vsrvtcp.ini
 +
              o data is extracted and transfered to Vital Signs,
 +
                however, no documents are refreshed.
 +
 +
  - YYYYMMDD  The as-of-date assigned to the extracted data.
 +
              o If not eom and extract is run before 6:00 am,
 +
                default is previous day.
 +
              o If not eom and extract is run after 6:00 am,
 +
                default is current day.
 +
              o If eom and today is last day of the month,
 +
                use current date.
 +
              o If eom and today is not the last day of the month,
 +
                use previous month-end.
 +
              o If restore, the date parm is required and should
 +
                be the effective date of the backup being restored.
 +
 +
This script must login as either 'botest', 'bolive' or 'bocu##' or 'boi###'.
 +
Based on LOGNAME, the extract will use the appropriate vital signs profile.
 +
</pre>
  
 
==JVSLOAD_HIST==
 
==JVSLOAD_HIST==
 
This job extract information from sh-history and ln-history.
 
This job extract information from sh-history and ln-history.
  
 +
<pre>
 +
  Syntax:
 +
  /VSJOBS/JVSLOAD_HIST [YYYYMMDD] [CMNDFILE=1] [TYPE={HIST|DC|ALL}]
 +
                [DAYS=num_days] [LOOP=num_loops]
 +
 +
  - CMNDFILE=1 Force download of the command file.
 +
 +
  - YYYYMMDD  Extracts HIST records starting with the specified date.
 +
 +
  - TYPE=HIST  Extracts history transactions (all types)
 +
        =DC    Extracts binary data change records only.
 +
        =ALL  Extracts history transactions and data change records.
 +
 +
  - DAYS=num  The number of days to extract in a single find.
 +
              Default is one day.
 +
 +
  -LOOPS=num  The number of loops to make in a single run of the job.
 +
              Default is 30 loops.
 +
              Total dates extracted is DAYS * LOOPS. The maximum date
 +
              is determined by the current CU Business (Open) date.
 +
 +
This script must login as either 'botest', 'bolive' or 'bocu##' or 'boi###'.
 +
Based on LOGNAME, the extract will use the appropriate vital signs profile.
 +
</pre>
  
 
==JVSRELOAD==
 
==JVSRELOAD==
 +
This job bypasses the HPUX extracts and reloads the data on the Windows host.
 +
 +
<pre>
 +
 +
Syntax:
 +
/VSJOBS/JVSRELOAD GROUPNAME [REQDATE] [LOAD=YES] [PRINT=FREQUENCY] [PATH=FOLDER]
 +
 +
PRINT FREQUENCIES : DAILY, WEEKLY, MONTHLY
 +
 +
Separate script for each Credit Union
 +
 +
This script must login as either 'bolive', 'botest' or 'bocu##'.
 +
Based on LOGNAME, the extract will use the appropriate profile.
 +
 +
PATH is only necessary if there are extract files on HPUX that need to be transferred to the Windows server for processing
 +
 +
Examples
 +
# Run the Daily Reports for the Membership_Analysis_by_ACCOUNT for 20121131
 +
/VSJOBS/JVSRELOAD Membership_Analysis_by_ACCOUNT 20121131 LOAD=NO PRINT=DAILY
 +
 +
# Run the Daily Reload for 20121131 and FTP files found in mbrshln
 +
/VSJOBS/JVSRELOAD MBRSHLN_Daily 20121131 PATH=mbrshln
 +
 +
</pre>

Latest revision as of 15:51, 20 March 2014

Summary

The following information is a detailed overview of each of the Vital Signs Jobs and their supported parameters.


JVSLOAD_MBRSHLN

This job extracts information from member-file, share-file, loan-file and loanapp.

  Syntax:
  /VSJOBS/JVSLOAD_MBRSHLN [eom | restore] [YYYYMMDD]"

  - eom        Process eom, use the report database."
               o uses the vsdata_eom profile in vsrvtcp.ini
			   
  - restore    Restoring data from backup, use the specified date.
               o uses the vsdata_restore profile in vsrvtcp.ini
               o data is extracted and transfered to Vital Signs,
                 however, no documents are refreshed.
				 
  - YYYYMMDD   The as-of-date assigned to the extracted data.
               o If not eom and extract is run before 6:00 am,
                 default is previous day.
               o If not eom and extract is run after 6:00 am,
                 default is current day.
               o If eom and today is last day of the month,
                 use current date.
               o If eom and today is not the last day of the month,
                 use previous month-end.
               o If restore, the date parm is required and should
                 be the effective date of the backup being restored.

 This script must login as either 'botest', 'bolive' or 'bocu##' or 'boi###'.
 Based on LOGNAME, the extract will use the appropriate vital signs profile.

JVSLOAD_HIST

This job extract information from sh-history and ln-history.

  Syntax:
  /VSJOBS/JVSLOAD_HIST [YYYYMMDD] [CMNDFILE=1] [TYPE={HIST|DC|ALL}]
                 [DAYS=num_days] [LOOP=num_loops]

  - CMNDFILE=1 Force download of the command file.

  - YYYYMMDD   Extracts HIST records starting with the specified date.

  - TYPE=HIST  Extracts history transactions (all types)
        =DC    Extracts binary data change records only.
        =ALL   Extracts history transactions and data change records.

  - DAYS=num   The number of days to extract in a single find.
               Default is one day.

  -LOOPS=num   The number of loops to make in a single run of the job.
               Default is 30 loops.
               Total dates extracted is DAYS * LOOPS. The maximum date
               is determined by the current CU Business (Open) date.

This script must login as either 'botest', 'bolive' or 'bocu##' or 'boi###'.
Based on LOGNAME, the extract will use the appropriate vital signs profile.

JVSRELOAD

This job bypasses the HPUX extracts and reloads the data on the Windows host.


 Syntax:
 /VSJOBS/JVSRELOAD GROUPNAME [REQDATE] [LOAD=YES] [PRINT=FREQUENCY] [PATH=FOLDER]

 PRINT FREQUENCIES : DAILY, WEEKLY, MONTHLY

 Separate script for each Credit Union

 This script must login as either 'bolive', 'botest' or 'bocu##'.
 Based on LOGNAME, the extract will use the appropriate profile.

 PATH is only necessary if there are extract files on HPUX that need to be transferred to the Windows server for processing

 Examples
 # Run the Daily Reports for the Membership_Analysis_by_ACCOUNT for 20121131
 /VSJOBS/JVSRELOAD Membership_Analysis_by_ACCOUNT 20121131 LOAD=NO PRINT=DAILY

 # Run the Daily Reload for 20121131 and FTP files found in mbrshln
 /VSJOBS/JVSRELOAD MBRSHLN_Daily 20121131 PATH=mbrshln