View previous topic :: View next topic
|
Author |
Message |
CICS fan
New User
Joined: 03 Apr 2008 Posts: 82 Location: United States
|
|
|
|
Hi,
Our latest task is something like this:
We need to analyse the system(on mainframe), which has 4 subsytems to see if customer number is stored anywhere or used from anywhere apart from a aparticular DB2 table.
We wanted to get the research results well documented and were wondering how a great document for this should look. This should be very detailed,readable and perfect for future use and/or updation etc.
Does anyone of you have a template of such document?It would be of great help.
CICS fan. |
|
Back to top |
|
|
genesis786
Active User
Joined: 28 Sep 2005 Posts: 210 Location: St Katherine's Dock London
|
|
|
|
we did something similar recently to analyse the impact of such resources running out.
1. break down sub systems into programs/tables/procedures etc.
2. tick against each of them where the client number is being used.
3. tick those areas which are of interest.
something like..
Code: |
Subsystem Entity Type Client Number Impact?
Present in Entity
Order Entry PGM1 DB2 Prgm Y High
Order Entry TBL1 table Y Low
.
.
|
i don't think anyone would be able to share actual templates due to company policies etc. but you can always try something creative in MS excel. |
|
Back to top |
|
|
mtaylor
Active User
Joined: 20 Feb 2009 Posts: 108 Location: Kansas City
|
|
|
|
So how do you collect the information? My thought would be to simply search for the text 'CUSTOMER-NUMBER'. Then go into each program and review how the value is being used (stored in another field, used in IF statements, etc...). Or search for the COPYBOOK containing the value, then search those entities for the text 'CUSTOMER-NUMBER'.
You may get a lot of 'false positives' though if CUSTOMER-NUMBER is also used as working storage value of some sort.
There are quiet a few commercial 'impact analysis tools' that will perform this type analysis for you. I wonder how they handle this type of situation? Does anyone have experience with any of them? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
You may get a lot of 'false positives' though if CUSTOMER-NUMBER is also used as working storage value of some sort. |
Additionally, you may miss many references because the exact name was not used (i.e. cnum, c-num, custno, customer-no, and on and on. . .). |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
What Dick mentions can be a real big problem if standards were not adhered to. |
|
Back to top |
|
|
CICS fan
New User
Joined: 03 Apr 2008 Posts: 82 Location: United States
|
|
|
|
Thank you all for your inputs. We finally settled on spreadsheet as genesis786 suggested. |
|
Back to top |
|
|
|