Difference between revisions of "Running HPUX Jobs Manually"
>Jeremyb (→JVSLOAD_HIST) |
>Johno (→JVSRELOAD) |
||
| (9 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== | ||
| Line 12: | Line 39: | ||
<pre> | <pre> | ||
Syntax: | Syntax: | ||
| − | + | /VSJOBS/JVSLOAD_HIST [YYYYMMDD] [CMNDFILE=1] [TYPE={HIST|DC|ALL}] | |
[DAYS=num_days] [LOOP=num_loops] | [DAYS=num_days] [LOOP=num_loops] | ||
| Line 36: | Line 63: | ||
==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
