This page provides the detailed information on all the processes and steps that takes place after an analysis is launched. It will give details about the information that is written in the logs that are generated for Analysis.
For 8.0.x : CAST Management Studio - Help > Configuration > Preferences > CAST General
For official documentation 8.0.x : CMS - Run analysis only
In this page, the different logs lines corresponding to the Run SQL Analyzer - SQL PSM z/OS are listed with functional and technical explanation of the logs that it generates.
If you want to know more about Run Analyzer task related to other technologies, please:
CAST-MS.log
Section of CAST-MS Management Studio log file dealing with SQL PSM z/OS analyzer. Get the location at CAST Logs location.
This section provides the information about the type of analyzer being used based on the technology which is being analyzed in the application. It provides the details about the command line for running universal analyzer, connection profile and also provides the path of the Analysis Log for more details about the analysis of a single Analysis Unit.
INF: 2016-07-06 17:09:18: starting Task Run analysis for 'DB2 ZoS'
Specifying the option -RUN_AU ,the following command line launch analysis unit by retrieving the ID of the Analysis Unit inside the JobSettings.xml. "My Package_15871-20160706170917.castlog'" present the log file of the command line (see option -LOG), this command line can be run from CMD after delivering the application.
INF: 2016-07-06 17:09:18: starting Task Run DB2 Analyzer "My Package_15871"
INF: 2016-07-06 17:09:18: C:\Program Files\CAST\8.0/anarun.exe -CONNECT_PROFILE('SBOW10LAP:2280 on CastStorageService.cb802_sbo_local') -RUN_AU(161151,162064,'C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0\LISA\9b360919e7d447bd878c81a7a0c2630e\Scr16669\JobSettings.xml') -MANAGED(161151) -SESSION_ID(162064) -LOG('C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0\9b360919e7d447bd878c81a7a0c2630e\My Package_15871-20160706170917.castlog',TRUNCATE) -LARGESTORAGE('C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0','C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0','9b360919e7d447bd878c81a7a0c2630e/Scr16669') -LOGIN(,CASTCORP\SBO,) -APP(-NOGUI) -FINAL_UPDATE -NOPROGRESS -EXIT
INF: 2016-07-06 17:09:25: About to run JOB_DB2_ANALYZER job 'My Package_15871'.
INF: 2016-07-06 17:09:40: Execution date=2016/07/06 15:09
INF: 2016-07-06 17:09:40: Execution duration=0 days, 00 hours, 00 mins, 15 secs
INF: 2016-07-06 17:09:40: Execution result=success
INF: 2016-07-06 17:09:41: Loading ini file: C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0\AMRunResult162064.INI
INF: 2016-07-06 17:09:41: Loading ini file: C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0\AMRunResult162064.INI
INF: 2016-07-06 17:09:41: Task message: No Task message
INF: 2016-07-06 17:09:41: Log file: C:\Users\SBO\AppData\Local\Temp\CAST\CAST\8.0\9b360919e7d447bd878c81a7a0c2630e\My Package_15871-20160706170917.castlog
INF: 2016-07-06 17:09:41: ending Task Run DB2 Analyzer "My Package_15871"
My Package_EGL_[AUID]-[DateTime].castlog
This is the DB2 zOS analysis log file. The DB2 zOS is based on DB2 extracted files. Each file is following a standard formatted structure, each information in the file has a given column size. The DB2 Extractor key file is the .Manifest file.
The DB2 zOS discoverer will generate as much analysis units as there is schema to be analyzed.
The DB2 zOS analyzer is not an AMT analyzer, that means there is no AMT IN Table and no AMT saving step. The Saving is a cache saving.
This section provides information on the environment in which analysis is about to run,the location of LISA ,LTSA,LSA folder and the local/knowledge base being used for analysis.
2016-07-06 17:09:21.125 Information INTERNAL ; Body 64-bit environment
2016-07-06 17:09:21.125 Information INTERNAL ; Body LISA folder: %TEMP%\CAST\CAST\8.0
2016-07-06 17:09:21.125 Information INTERNAL ; Body LTSA folder: %TEMP%\CAST\CAST\8.0
2016-07-06 17:09:21.126 Information INTERNAL ; Body LSA relative folder: 9b360919e7d447bd878c81a7a0c2630e/Scr16669
2016-07-06 17:09:21.477 Information INTERNAL ; Body Using Knowledge Base on schema cb802_sbo_local.
This section provides information that environment information has taken into account,metamodel is loaded and analysis is about to start.
2016-07-06 17:09:22.179 Information MODULMSG ; Body Loading meta model from repository . . .
2016-07-06 17:09:25.681 Information MODULMSG ; Body Meta model loaded.
2016-07-06 17:09:25.681 Information INTERNAL ; Body RunAnalysis started
This section shows all the configuration messages. All the options configured in CAST- MS like the extensions included in analysis,column of indicator area,tabular length,any custom environment profiles ,source file path,include file path etc that are required to run a perfect analysis are shown in the log message during the beginning.
2016-07-06 17:09:25.681 Information INTERNAL ; Body Description :
2016-07-06 17:09:25.681 Information INTERNAL ; Body Name : My Package
This is the DB2 zOS extractor key file. It will inform the analyzer the name of each extractor file.
2016-07-06 17:09:25.681 Information INTERNAL ; Body Selection File : C:\SBO - CAST\CAST-MS\802\Deploy\DB2 ZoS\My Package\SUPPORT.DB2.MANIFEST
List of Analysis Unit - Schema: 1 analysis unit = 1 schema
2016-07-06 17:09:25.681 Information INTERNAL ; Body Selection AnalysisUnits
2016-07-06 17:09:25.681 Information INTERNAL ; Body Analysis Unit description :0
2016-07-06 17:09:25.681 Information INTERNAL ; Body Name : DBSN0000
2016-07-06 17:09:25.681 Information INTERNAL ; Body Analysis Unit description :0
2016-07-06 17:09:25.681 Information INTERNAL ; Body Name : [MY PACKAGE_15871]<SUB-SYSTEM>
2016-07-06 17:09:25.681 Information INTERNAL ; Body Analysis Unit description :0
2016-07-06 17:09:25.681 Information INTERNAL ; Body Name : DBFGW000
2016-07-06 17:09:25.681 Information INTERNAL ; Body Analysis Unit description :0
2016-07-06 17:09:25.681 Information INTERNAL ; Body Name : DBNC0000
2016-07-06 17:09:25.681 Information INTERNAL ; Body Analysis Unit description :0
2016-07-06 17:09:25.708 Information INTERNAL ; Body Analysis Unit description :0
2016-07-06 17:09:25.708 Information INTERNAL ; Body Name : DBPG0000
This information is in CAST MS - Production tab.
2016-07-06 17:09:25.708 Information INTERNAL ; Body Number of Instances : 200000
2016-07-06 17:09:25.708 Information INTERNAL ; Body Add system catalog to application : 1
2016-07-06 17:09:25.708 Information INTERNAL ; Body SESSION CONTEXT details:0
161151 ; 162064 = "DB2 ZoS"."My Package_15871"
2016-07-06 17:09:25.708 1 ; Job execution
This section shows that the analysis step has started.
2016-07-06 17:09:25.708 Information INTERNAL ; Job execution About to run JOB_DB2_ANALYZER job 'My Package_15871'.
2016-07-06 17:09:25.708 Information MODULMSG ; Job execution Total physical memory: 8080 MB.
External links processing, It gives information about the number of Client Server objects that would be involved in the analyzer in order to create external links.
2016-07-06 17:09:26.059 Information MODULMSG ; Job execution External link component has loaded 0 objects
2016-07-06 17:09:26.059 Information MODULMSG ; Job execution Loading meta model from local xml descriptors . . .
2016-07-06 17:09:36.218 Information MODULMSG ; Job execution Meta model loaded.
Parameters for saving job : Saving by cache, not AMT
2016-07-06 17:09:36.570 Information PARSING ; Job execution Loading default options for cache saving component
2016-07-06 17:09:36.920 Information INTERNAL ; Job execution The current job session has been assigned an internal "session id" to help identifying current job results
zOS Job SESSION ID = [D5CF2FF5]
2016-07-06 17:09:36.920 Information INTERNAL ; Job execution The filter file you supplied contains following database prefix: My Package_15871
This section shows the files that are being processed during the analysis.
2016-07-06 17:09:36.920 Information INTERNAL ; Job execution Prepare to process following file: 'C:\SBO - CAST\CAST-MS\802\Deploy\DB2 ZoS\My Package\CAST.DB2.TABROWS'
2016-07-06 17:09:36.920 Information INTERNAL ; Job execution <+> The file 'C:\SBO - CAST\CAST-MS\802\Deploy\DB2 ZoS\My Package\CAST.DB2.TABROWS' is missing or it is empty: XXL DIAGs will not operate on this job results.
2016-07-06 17:09:36.920 Information INTERNAL ; Job execution Prepare to process following file: 'C:\SBO - CAST\CAST-MS\802\Deploy\DB2 ZoS\My Package\SUPPORT.DB2.SYSDTYP'
...
2016-07-06 17:09:37.974 Information INTERNAL ; Job execution Prepare to process following file: 'C:\SBO - CAST\CAST-MS\802\Deploy\DB2 ZoS\My Package\SUPPORT.DB2.FUNSRC'
This is a summary of the number of objects analyzed.
2016-07-06 17:09:40.076 Information INTERNAL ; Job execution Count of objects sent to Knowledge Base saving layer:
3 Databases
5 Schemas
59 Tables
18 Views
2 Procedures
2 Functions
2 Triggers
0 Indexes
Execution summary
2016-07-06 17:09:40.427 Information INTERNAL ; Job execution New Job status
2016-07-06 17:09:40.427 Information INTERNAL ; Job execution Execution date=2016/07/06 15:09
2016-07-06 17:09:40.427 Information INTERNAL ; Job execution Execution duration=0 days, 00 hours, 00 mins, 15 secs
2016-07-06 17:09:40.427 Information INTERNAL ; Job execution Execution result=success
2016-07-06 17:09:40.427 MSGACCOUNT ; Summary 0 fatal error(s); 0 error(s); 0 fing(s); 45 information message(s).
2016-07-06 17:09:40.428 1048575 ; Job execution
2016-07-06 17:09:40.499 Information INTERNAL ; Body Analysis completed
CAST_MainTask_SummaryLog.txt
This is the CAST MS Log summary. It summarizes the results of the whole process executed.
Status: Execution succeeded
Start: Wed Jul 06 17:09:14 CEST 2016
OS Version: Windows 7 (version 6.1)
Machine name: SBOW10LAP
Software Version: CAST 8.0.2 ( Build 8653 )
Task: Take a snapshot of the application
Total duration: 2m33s
Nb of Computed Quality Rules: 44
-- Statistics for application DB2 ZoS --
Analysis duration: 1m14s
No of modules: 1
No of active analysis units: 4
No of inactive analysis units: 0
Total no of analysis units: 4
No of saved objects: 89
Summary is saved at %TEMP%\CAST\CAST\8.0\CAST_MainTask_SummaryLog_20160706-170914.txt