Creation of BCOR weekly & monthly batch program to generate input for On-line reporting system. Additionally provided database & programming support in the form of ADHOC queries/programs to extract & manage DB2 data as requested by Business clients from MAS MVS DB2 tables.
Current Week /
Last Week /
Bottom of Page
Week 1, 10/10 - 10/16.
Summary: Attend Tuesday weekly meeting, Review project requirements, getting up to speed with shop standards, verify required authority granted, administrative tasks i.e. ID's, badge, weekly status reports & time reporting. Assigned ID's & Passwords (Encryption Key, Logon ID & Password and VPN logon). Receive laptop. Prepare for next project; JCL, Table Relations, ID jobs associated with two batch story lines.
Tasks assigned: Batch project to be assigned next week.
Weekly Status: Accessed LAN ID, reviewed DB2 tables(4), created sample joins, created test Changeman package created, sample story lines reviewed, sharepoint directory reviewed. VPN certificate reissued, tested home login capability (VPN), review old batch storylines & existing programs.
Week 2, 10/17 - 10/23.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet.
Take steps required to tackle assigned project: Copy required JCL, Analyse Story line, transcribe job specs, create Changeman package.
Tasks assigned: BCOR Batch Coding Project.
Weekly Status: Attended project meeting, Monday & Wednesday. Work on assigned tasks design specs, desk check program design flow. Created test CM package pulled in base line source code and a new program. for new DB2 code need to add Bind CNTL statements(DB2 DBA).
Note JCL st control line enter pre xxxxxx* - to change the jobs to be viewed.
Problems: None.
Week 3, 10/24 - 10/30.
Summary: Attend BCOR meetings, Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. Start BCOR project, obtain program name, creation of bind cntl member verify project show stoppers. Modify CM Package CNTL package parameters, get questions answered, modify code create test JCL.
Weekly Status:Program renamed PIMP2043, compiled. Monday's meeting BCOR specs defined by DS, used Virt Batch program as a model, program cleanly compiled.
Tasks assigned: BCOR Project.
Problems: None.
Week 4, 10/31 - 11/06.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks, Rollup logic determine, need to rollup lower levels for BCOR. Creation of test data & run with same. Meeting with DS(Tuesday), given additional specs and misconceptions corrected. Batch meeting rescheduled next Monday.
Tasks assigned: BCOR Project.
Weekly Status: Batch program run in batch, no data, still missing test INPT, RPRT & CNTL table data. Prior to running test data, create RPRT table image copy.
Problems: Unable to step thru BCOR program, SOC4.
Week 5, 11/07 - 11/13.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. Attend BCOR/Batch meeting, verify following; RollUp summing, RYG/val 4 assignment and Typ Cd processing/val 3 assignment, get answers measure calculations. Create test SQL to obtain expected numbers from test data. Correct XPD problem, job works in TSO batch but bombs SOC1/4 when stepping thru in XPD.
Tasks assigned: BCOR Project.
Weekly Status:Primary cursors and additional SQL's reviewed. Meassure algorithms provided & coded in Meassure Rtn. SP questions answered. Hours entered for Caliper & FieldGlass Systems. New BOA tool FILD typed on the command, brings you into a DB2 table.
Problems: Unable to step thru BCOR program, SOC1.
Week 6, 11/14 - 11/20.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks.
Participate in Code walk thru Tuesday, rectify EXPEDITER problems. Review test data, run review SQL's. Load PM_PRCS_CNTL table with project data.
Tasks assigned: BCOR Project.
Weekly Status:Renamed program, conducted walk thru, load PRCS BCOR data from XCEL document. Added data to MSR_INPT_DATA table, completing special processing for meassure BCOR09.
Problems: Unable to step thru BCOR program, SOC1.
Problem loading ogr_msr_inpt table, load job abended.
Week 7, 11/21 - 11/27, Thanksgiving Week.
Summary: Short week Thanksgiving(32). Attend weekly meeting/submit hour glass time sheet. Work on assigned tasks. Load DB2 table with test data(batch COBOL Load). Complete project BCOR. Complete batch program.
Tasks assigned: BCOR Project.
Weekly Status:Resolved load problem load job ran after data manipulated. Table ogr_msr_inpt table, loaded. Run SQL against loaded table, export & save data as XCEL DSN. Loaded plan cntl records, debugging batch program. Resolved XPediter problem, entered data into problem table. Stepped through entire program, bugs resolved. Resolve grey areas. Reviewed program output & major program cursors all looked good.
Problems: Unable to step thru BCOR program, SOC1.
Required table empty, question do I need it?
Week 8, 11/28 - 12/04.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. Get questions answered, modify & test code. Finish program testing, begin user testing. Start work on next project, prepare attack plan.
Tasks assigned: BCOR Project.
Weekly Status:Question with rollups, system hosed DOW 11/28 - 1300 till 2000.
Problems: System 1300-1700/11/28.
Week 9, 12/05 - 12/11.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. Continue & finish BCOR testing, review output table entries i.e., BCOR09,ATMCAL & ATMCL2.
Tasks assigned: BCOR Project, new task (two weeks).
Weekly Status: Monthly testing near completion, initiating weekly job testing. PRCS table uunstable, somebody mucking it up, fix orphan problem monthly processing (zero org id). New specs for BCOR09 meassures. Review required algoReview required algorithms & processing for special measure processing (BCOR09 & ATMCL2). Given OK for OT.
Problems: None.
Week 10, 12/12 - 12/18.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. Meet with KV to review ATMCL2 processing.
Tasks assigned: BCOR Project, Developement Phase.
Weekly Status: ATMCL2 processing, problem resolved (no ATMCAL Roll up meassures generated). Need to review ATMCL2 process with KV. Installed company router. ATMCL2 meassure processing reviewed & corrected, Rollup for program reviewed & modified, converted from cursor retrieving all data to using processing data. Ran BCOR Batch Monthly & Weekly, reevaluated meassures BCO01 & BCOR31. Audit/Freeze package will let testers test. Last test with PMIP2043.
Problems: None.
Week 11, 12/19 - 12/25, Christmas Week.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. 12-19 company lunch 1200/12-19 1100 to 1200 team meeting. Clean up any & all program bugs discovered during testing. Add JCL & PROC to BCOR Package. Testing phase of BCOR project.
Tasks assigned: BCOR Project, Testing Phase.
Weekly Status:Reviewed/Corrected all batch incidents. Weekly BCOR update meetings scheduled. Clean up all testing Batch issues. Starting Weekly testing of BCOR Batch. Package reaudited & frozen. Thurseday reran BCOR Batch job, cleaned up ORG_RPT_Data table, deleting table records greater then 2011-03-01, ready for retesting. Modification to input specs, code in place. Reran BCOR Batch job for testing - BCOR09 Val5 error (corrected & reran job). AV completed testing 12/24 brougt up potencial problem with ATMCL2 Rollup processing.
Problems: Attempted to extract weekly data, questionable results - waiting for responce to last data extracted.
Week 12, 12/26 - 01/01, Week after Christmas.
Summary: Attend required meeting(s)/submit hour glass time sheet. Rerun BCOR Batch job with a process dates of 2011-04-01 through 2011-11-01. Extract weekly run data. Create JCL and PROC, move components into package. Resolve questions from last weeks data dump (weekly data extract).
Tasks assigned: BCOR Project, Testing Phase.
Weekly Status: Channel Level processing testing error for measure ATMCL2 corrected, waiting for testing verification. 12/28 rerun BCOR Batch Monthly for processing dates 01-01 thru 02-01 (both ran 103 miniutes). Ran batch job, processing dates 04-01 thru 08-01 Thursday. ran remaining process dates (08-01 thru 11-01) Friday also attended BCOR Batch meeting.
Problems: BCOR Batch job currently runs 130 Miniutes clock time, possibly run runstats on RPT table.
Week 13, 01/02 - 01/08.
Summary: Attend Tuesday weekly meeting/submit hour glass time sheet. Work on assigned tasks. Tuesday program review with KV. Implement solution Only delete YSUM records for valid ORG ID's at the time of the processing date, waiting for OK from DS.
Tasks assigned: BCOR Project, UAT Testing Phase.
Weekly Status: Restoring BCOR09 BC RPT meassures, modified program to insert measures. Made program mods to correct program flaw, table data corrected. Creating CM Package to move JCL, PARM and PROC for weekly/monthly jobs. Resolved BCOR09 issues, Ran code to execute BCOR09 special processing (processing date 2011-11-01.
Problems: Program flaw, deleting all BCOR09 meassures for all BC ORG ID's.
Week 14, 01/09 - 01/15.
Summary: Move BCOR Batch program & JCL into Production. Work on assigned tasks. Resolve ATMCAL processing question, val2 coming from ATMCAL INPT or BCOR08? Test remaining BCOR09 issues, Pass JCL to KV for review, Rerun job for all dates.
Tasks assigned: BCOR Project, Production Move Phase.
Weekly Status: Reviewed BCOR09 issues, corrected (not sure of roll up issue) EMail sent out. Ran adhoc SQL's to update RPT & INPT tables, Rerunnint Batch BCOR monthly job with PRCS_DT of November, ABENDED -803. Expanded delete to imnclude all ATMCL2 measures. ran weekly job, processing date 2011-1107. Added program moods to read weekly from Date card & use previous Mondays date, reran weekly job correcting weekly issues (BCWR02/09). Modified YSUM Delete SQL & Banking Center Primary Cursor.
Problems: Inpt Table -911 due to contention with load utility. Ran DB2 utility to reset table resources i.e.
Go to DB2I Option 7 -TERM UTILITY(*)
-TERM UTILITY (DB2)
The DB2® command TERM UTILITY terminates execution of a DB2 utility job step and releases all resources associated with the step. When executing, a utility does not terminate until it checks to see that the TERM UTILITY command was issued. Active utilities perform this check periodically. If the utility is stopped, all its resources are released by the TERM UTILITY command. An active utility can be terminated only from the DB2 on which it is running. A stopped utility can be terminated from any active member of the data sharing group.
Command to check Table status.
-DIS DB(PMI0201D) SPACE(PMI0201S) LIMIT(*) LOCKS CLAIMERS
Week 15, 01/16 - 01/22.
Summary: Continued testing of BCOR Batch program, running Monthly job, using processing date 2011-12-01. Schedule jobs via CA7. Correct any new log issues and resolve unresolved issues. Work on assigned tasks.
Tasks assigned: BCOR Project, UAT Server.
Weekly Status: Ran Monthly job, using processing date 2011-12-01. Created program copy (PMIP2043), modified roll up processing; multiple cursors with specific PRCS_Dt vice the entire year.Corrected issuue (BCOR08) ran BCOR Batch with processing date 2011-12-01, issue resolved. Continued testing, unresolved issues; Banking Centers that go dormant YSUM record generation and generation of measures controlled by CNTL table vice input data.
Problems: Computer acting up, rebooted problem resolved. Seperated BC YSUM processing to seperate routime, created test matrix & reran batch program with December's processing date. Ran job reviewed output, YSUM records generated for banking centers that as of the processing date are no longer valid. Added BCOR09 YSUM seperation of processing to program, tested via XPD.
Week 16, 01/23 - 01/29.
Summary: Issue one resolved, work on issue two (Default measure values). Move BCOR Batch program & JCL into Production. Resolve BCRW02 weekly issues. Complete BCOR Batch testing, Freeze both packages then move this or next week.
Tasks assigned: BCOR Project, UAT Testing.
Weekly Status: Notified new issues- Issues 51, 52 & 53 (preexisting), Red Alert Data. Worked on issues 51 & 52, resolved & tested (monthly/2011-12-01). Issue 53 could be eithera data issue or corrected by previous code mods. Reran weekly with following dates 10/10, 10/17, 10/24, 10/31, 11/07, 11/14 & 11/21. Modified program, BCOR08 YSUM measures, reran job (processing date November) to review issue 53, resolved. Code mods BCOR08 & ATMCAL YSUM processing, reran BCOR batch job PRCS_DT 2011-12-01. Rerun monthly job (modified to only run banking centers) January thru November. Run origional code with Decembers date. Project Went GREEN problem may put it back into the RED. Modified BC MSUM BCOR08 Val2 via ADHOC SQL. CA7 components added to ChangeMan package 3996.
Problems: BCRW02 weekly issues, user either accepts default input measure or implemt ent code mod. New issue with BCOR08 val-2 measures, not sure if its a data problem or code that was previously corrected.
Week 17, 01/30 - 02/05.
Summary: Attend daily BCOR status meeting. Confirm user modified BCOR02 story line, modify code. Run batch job with 2012-01-01 processing date. Move BCOR Batch program & JCL into Production. Work on assigned tasks. Update resume, gather references.
Tasks assigned: BCOR Project, Production Move Phase. No new project(s) put job search into overdrive.
Weekly Status: Confirmed BCOR02 story modifications, ran adhoc query updating BCOR02 val4 RPT table fields. Story mod; weekly Process Date, 2nd Monday vice 1st Monday. Coode modifications made & tested. Reran monthly processing dates January thru October, BC's only. Ran December full monty. Added FTP server Job, proc, parm & CA7 components to CM package. Scheduled trigger jobs via POD/CA7.
Problems: Last weeks problem resolved, modified Banking Center measures via ADHOC Queries. Table changes confirmed via testing team.
Week 18, 02/06 - 02/12.
Summary: Run BCOR Batch with 2012-01-01 processing date, move DB2 work tables from test to prod enviroment. Move BCOR Batch program & JCL into Production. Work on assigned tasks.
Tasks assigned: BCOR Project, Production Move Phase (2012-02-07).
Weekly Status: Reviewed program (delete logic and date assignment) and JCL package (Jobs/Procs/Parms/CA7 elements). Due to four day lead time requirement seperated CA7 components into own package, froze both packages. Change in storyline for measure BCRW06, code modified & weekly reruns. Reran monthly job with process date 2012-01-01, ran for 17 miniutes. Rerun monthly production job with 2011 Dec processing date. Updated production work tables. CM package Baselined, ran production job (modified date card 2011-12-01) OK completion. Addition to story line; BCOR02/BCRW02 Val3 > 100 change to 100. Successfully ran production job from over-ride library (2011-12-01). Weekly job run processsing date 1/30. Given DD Date, 2/24 - project complete. CM package 3972 BaseLined.
Problems: Weekly job GO or No GO?
Week 19, 02/13 - 02/19.
Summary: Run BCOR Weekly (batch date 1/30) from overide library. BCOR production run(processing date 2012-01-01), CA7 scheduling triggering tested. Work on assigned tasks.
Tasks assigned: BCOR Project, update/cleanup. Adding program mods to PMIP2044, CM package 4021. Review asociate tables & program designs.
Weekly Status: Ran BCOR batch weekly (Process Date 2012-01-30) job from overide PDS. Updated program PMIP2044, modified BCOR02/BCRW02 MSR algorithems. Tested Weekly & Monthly mods using 2012-01-30/2012-01-01 dates. Package 4021 base line date 02/22. Add CA7 components for PMIBCOMS/WS Review POD online tool(CA7 tool). Weekly job ran from production, processing date 02/06/2012.
Problems: Corrected CA7 error, BCOR project completed & moved into production (Program/JCL/Triggers).
Week 20, 02/20 - 02/26.
Summary: Project Successfully completed, return assigned gear (router & laptop). Work on assigned tasks.
Tasks assigned: None.
Weekly Status: Bind problem program/package PMIP2044/4021 -908, created new package 4028. Package successfully baselined 2/22.
Problems: None.
Entries in BLACK History
/
Entry in Navy Current week
/
Entries in Red Projected weeks
/
Entry in Purple Last week
Procedures:
How to export QMF data to a XCEL document.
1. Run query.
2. Export data using following line command:
export data to "Middle DSN Prefix" (c=y d=i o=c)
3. DSN Name jjust designate middle qualifier system will rest i.e., give test & system will generate USERID.TEST.DATA
4. Download DSN to PC text file,
Tools tab download option, brings up text import wizard
5. Open XCEL Document, as new.
6. Hit open button, choose text DSN file to open, hit delimiter button & spaces.
7. For additinional info see links below.
How to verify JCL in a CHANGEMAN Package.
1. Main Screen option 5.
2. AP desired package, ENTER
3. Batch job submitted, message displayed.
4. For additinional info see links below.
How to Schedule jobs for production runs.
1. POD Link.
2. Populate Name, LPAR & schedular fields then Hit "Add Job"
3. Populate from previous screen then Hit "Add Job to Scheduler"
4. Hit "Continue"
5. Populate Run Frequency =>Event Triggered/Predecessor=>Add triggered job name
6. For additinional info see links below.
Accessing production job output.
1. Logon to TSO Production T3S03.
2. SAR command Line - Brings up Job list screen.
3. Enter job name.
4. Select Sysout.
Updating Production Tables.
1. Send note to ARUN, with select & expected count
Acessing TSO PROD Table Data.
1. Logon to TSO Prod
2. Access table data via QMF/SPUFI PMI00.
Acessing production schedules via CA7
1. Logon via CA73SP.
2. Use specific userId/password(see document).
New Things Learned
1. POD tool.
2.
SDSF Help Hints
1. Changing job filtering, PRE i.e. PRE NBDK* will display Jobs beginning with NBDK
2. See Links below.
DB2 Table commands
Problems: Inpt Table -911 due to contention with load utility. Ran DB2 utility to reset table resources i.e.
Go to DB2I Option 7 -TERM UTILITY(*)
-TERM UTILITY (DB2)
The DB2® command TERM UTILITY terminates execution of a DB2 utility job step and releases all resources associated with the step. When executing, a utility does not terminate until it checks to see that the TERM UTILITY command was issued. Active utilities perform this check periodically. If the utility is stopped, all its resources are released by the TERM UTILITY command. An active utility can be terminated only from the DB2 on which it is running. A stopped utility can be terminated from any active member of the data sharing group.
Command to check Table status.
-DIS DB(PMI0201D) SPACE(PMI0201S) LIMIT(*) LOCKSCLAIMERS -
Active Assignments(10/11/11):
Assigned 10/17/2011: BCOR Batch Coding Project, currently missing TYP-CD procesing
2012 implementation.
Scheduled Completion Date: 02/10/2012
Developement Phase(10/11/11):
Testing Good data, empty input and duplicate ORG-ID/MSR-TYP-CD/PRCS-Dt (XPEDITER).
Phase One: Delete Org-ID metrix meassures for given processing date, create metrx meassures for same date.
Phase Two: Rollup & create Meassures for other levels.
Program run successfully with no data.
Rolling up non BC's children.
Attend BCOR/Batch meeting, verify following; RollUp summing, RYG/val4 assignment and Typ Cd processing/val 3 assignment.
Primary cursors reviewed, additional SQL's reviewed. Meassure algorithms provided & coded in Meassure Rtn. Currently using temporary program name, need to rename, enter speceal processing & create test table data (PRCS & INPT).
Rename batch program, add special processing to program. Review test data, run mock SQL's against test DB2 data.
Debugging progrm, table data missing.
Reviewed program output & major program cursors all looked good.
Review program output, cross check against Share Point documentation.
Reviewed Share Point specs, BCOR09 specs modified, recoded effected routines.
Package contains Program, no JCL. Package Audited & Frozen.
Testing Phase(12-16-11):
Reviewed/Corrected all batch incidents.
Corrected all testing batch issuues, to date.
Will resubmit BCOR Batch with 2011-03-01 processing date 12-28-2011.
After successful retesting run BCOR Batch with rest of year processing date.
Thurseday reran BCOR Batch job, cleaned up ORG_RPT_Data table, deleting table records greater then 2011-03-01.
12/23 reran job, testing continued. Testing completed potencial problem area rollup for ATMCL2 processing, only problem detected.
Channel Level processing testing error for measure ATMCL2 corrected, waiting for testing verification. 12/28 rerun BCOR Batch Monthly for processing dates 01-01 thru 02-01.
Ran BCOR Batch Processing Dates 04-01 thru 11-01
Question YSUM records deleted, which ORG_ID's will be used to generate YSUM records, if current month used what about ORG _ID's canceled? This senario is not to be found story line.
Solution: Only delete YSUM records for valid ORG ID's at the time of the processing date.
Resolved BCOR09 processing issues, Resolve ATMCAL processing question, val2 coming from ATMCAL INPT or BCOR08?
Need to add code to get weekly process date, previous Monday from given date.
Here's the code to implement the technique I mentioned earlier. To avoid text wrap-around I shortened data names, i.e. yr-date s/b your-date; daze s/b days-diff. Also, the DOW-TBL literal should begin in area B.
05 YR-DATE PIC 9(008) VALUE 20010104.
05 ANY-SUN PIC 9(008) VALUE 20001231.
05 DAZE PIC S9(008) COMP.
05 BIT-BUCKET PIC S9(008) COMP.
05 DOW-SS PIC S9(004) COMP.
05 DOW-TBL VALUE
'MONDAY TUESDAY WEDNESDAYTHURSDAY FRIDAY SATURDAY '.
10 DOW-ENTRY OCCURS 6 PIC X(009).
COMPUTE DAZE = FUNCTION INTEGER-OF-DATE(YR-DATE)
- FUNCTION INTEGER-OF-DATE(ANY-SUN)
DIVIDE DAZE BY 7 GIVING BIT-BUCKET REMAINDER DOW-SS
IF DOW-SS = ZERO
DISPLAY 'DAY OF WEEK FOR ' YR-DATE
' IS SUN'
ELSE
DISPLAY 'DAY OF WEEK FOR ' YR-DATE
' IS ' DOW-ENTRY(DOW-SS)(1:3)
END-IF
Currently roll up processing employs cursor with processing date covering jan to processing date, created test program that employs a cursor with predicate processing date = to specific date.
Unresolved issues; Banking Centers that go dormant YSUM record generation and generation of measures controlled by CNTL table vice input data.
UAT Testing Phase(01-02-11):
Seperated BC YSUM processing to seperate routime, created test matrix & reran batch program with December's processing date.
Issue with BCOR08 val-2 measures, not sure if its a data problem or code that was previously corrected, error similar to last BCOR01 issue, issue not IDed.
Code mods not made, BCOR08 Val-2 initialied to zero vice INPT table values, values updated via ADHOC query.
Story mod; weekly Process Date, 2nd Monday vice 1st Monday. Coode modifications made & tested.
Production Move: 2012-02-07
Run BCOR Batch with 2012-01-01 processing date, 2/07 move DB2 work tables from test to prod enviroment.
Ran production code from override library (2011-12-01).
CHANGEMAN Packages:
PMI0003996 JCL/PROCS/PARMS/CA7 Audited & Frozen - Reverted 2/06
2/06 - JCL/PROCS/PARMS/Source Audited & Frozen, sched for Base Lined 2/07
PMI0003972 Code(PMIP2044) removed 2/06.
Moved CA7 components due to four day lead time.
sched for completion 2/10. - Approved/Frozen
PMI0004021 Code(PMIP2044) retrieved from prod - story line mod/measures BCOR02/BCRW02
Added CA7 components to package - Production move 2/22
Bind error, -908 program PMIP2044, CA7 components sucessfully moved, created new package to move program - sucessfull.
Linkage Section:
TSO MISC
TSO Edit Profile
CA7 Commands/Additinal CA7 Commands
SDSF Commands/SDSF Print Comands
DB2 utility job step and releases all resources
DB2 Command
DB2 Commands IBM Page
ChangeMan Doc
ChangeMan Quick Training,
XPEDITER Quick Training/XPEDITER Additional Training
DB2, Metadata
Access
Fieldglass
Pandora Radio
QMF Commands/Additional QMF Commands
Top of Page
URL :boa1hist.html.html
Revised:10/10/2011
Layout, design & revisions David E. Huenger