I tried loading one easytrieve program into RAA but the tools shows its language as UNKNOWN.
But I can see CA-Easytrieve in the assign language options.
So I was wondering if RAA can support Easytrieve programs? If yes, how can it help with those programs?
This topic has been locked.
5 replies Latest Post - 2012-05-09T16:01:04Z by jcdelmo
Pinned topic Does RAA support Easytrieve programs?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-09T16:01:04Z at 2012-05-09T16:01:04Z by jcdelmo
SystemAdmin 110000D4XK849 PostsACCEPTED ANSWER
Re: Does RAA support Easytrieve programs?2012-05-07T19:54:09Z in response to HarshixRAA does not support CA-Easytrieve, scanning is limited to language agnostic symbol collection if you opt for RAA to do that, just like any other file on Windows. RAA tries to classify files as CA-Easytrieve, based on very limited code examples from clients.
The symbols scanning gives you the unstructured data, that you can use in context of other, structured data RAA collects. See this demo on how you can find database table references in Java and DDL files, similar approach can be taken with Easytrieve:
Explore Java, COBOL, and DB2 assets using IBM Rational Asset Analyzer
Re: Does RAA support Easytrieve programs?2012-05-08T06:41:50Z in response to SystemAdminThank you for the information.
Please correct me if I am wrong. So RAA can give table name references in a file. But I have loaded all the EZT files into RAA and I still find 0 table references in the files. Is this because of the follwing reason?
We have 2 sites in RAA, A and B. Only Site A contains the Db2 system data but not Site B.
The EZT programs are loaded in Site B.
jcdelmo 0600012HN8339 PostsACCEPTED ANSWER
Re: Does RAA support Easytrieve programs?2012-05-08T15:21:08Z in response to HarshixSome background may help.
RAA has four classes of file scanners: containerScan, classificationScan, analysisScan and symbolScan.
The containerScan scans CONTAINERs (e.g., directory on workstation, PDS on z/OS) to get a list of FILEs in the container.
The classificationScan scans FILEs to determine languageCd, fileTypeCd and gather file-based meta-data.
The analysisScan scans groups of FILEs, based on languageCd and fileTypeCd to gather program/job/map meta-data.
The symbolScan, which is optional, scans files to gather SYMBOLs without regard to languageCd or fileTypeCd.
For EZT files, RAA does not ship an analysisScan scanner. However, a combination of the symbolScan on the EZT files and analysisScan on any files that do have DB2_TABLE references (or a DB2 catalog scan) allows RAA to related the symbols found in the EZT file(s) with the symbols that represent DB2_TABLE (and other asset names).
You should be able to see all the EZT symbols on the symbol summary page (if symbolScan was run) where any symbol matching a DB2 table name will show a link to that table name. The symbol summary page is across all assets and is not scoped by SITEs.
I have to assume the symbolScan check box on the inventory wizard was not checked when the EZT files were scanned, was it ?
Re: Does RAA support Easytrieve programs?2012-05-09T15:27:24Z in response to jcdelmoThank you for the information. That was very helpful.
Yes, the symbolScan check box was unchecked. I will correct it and update you.
Meanwhile, can you please explain how a DB2 system comes into RAA.
Is it to be manually loaded into RAA or RAA generates itself?
This is because, in our RAA, I see a Db2 system called WSAA in Site A but not in Site B though same components are loaded in both the Sites.
jcdelmo 0600012HN8339 PostsACCEPTED ANSWER
Re: Does RAA support Easytrieve programs?2012-05-09T16:01:04Z in response to HarshixThere are three ways db2Subsystem asset rows get entered in RAA:
1) When discovered by JCL scan, as in Batch TSO running a program under DB2
2) When a DB2 catalog scan is run
3) When SQL references are found in programs
In the last case, attempt is made to match the SQL reference to actual DB2 subsystem table, column and procs. However, if no DB2 cataglog scan has been run a placeholder DB2 subsystem (named *WSAA*) is added to the data base.
In RAA v126.96.36.199 (and all prior versions) there is one WSAA placeholder subsystem for all SITEs. The match for table, column and proc will all reference the placeholder rows. Any time a DB2 catalog scan is done, the placeholder subsystem rows are evaulated to see if they should be properly migrated to a real subsystem.
In the future, there are plans to have one placeholder subsystem for each SITE.