Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Analysis for customer number on the entire system

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Thu Mar 19, 2009 4:35 pm    Post subject: Analysis for customer number on the entire system
Reply with quote

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
View user's profile Send private message

genesis786

Active User


Joined: 28 Sep 2005
Posts: 210
Location: St Katherine's Dock London

PostPosted: Thu Mar 19, 2009 6:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
mtaylor

Active User


Joined: 20 Feb 2009
Posts: 108
Location: Kansas City

PostPosted: Thu Mar 19, 2009 9:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 19, 2009 10:40 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Fri Mar 20, 2009 3:04 am    Post subject:
Reply with quote

What Dick mentions can be a real big problem if standards were not adhered to.
Back to top
View user's profile Send private message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Mon Mar 23, 2009 1:34 pm    Post subject:
Reply with quote

Thank you all for your inputs. We finally settled on spreadsheet as genesis786 suggested.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am
No new posts Dump analysis of an assembler module monica1 PL/I & Assembler 4 Tue May 09, 2017 10:05 am
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts how to mask the phone number kumarinfy DB2 4 Mon Apr 03, 2017 5:23 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us