Load HDBs

After defining an HDB you can collect (load) the historical data.

Select option 3 Load from the HDB menu to generate JCL to load data into your HDB. The list of defined HDBs is presented.
Figure 1. Load HDBs
  File  Options  Help                                                          
------------------------------------------------------------------------------ 
                                  Load HDBs                    Row 1 to 5 of 5 
Command ===> ________________________________________________ Scroll ===> CSR_ 
                                                                               
Select to load an HDB.                                                         
                                                                               
   Name     Type               Description                Changed        ID     
_  CICSDAY  LIST     Today's CICS Transactions        2004/12/11 00:00 CICSPA  
S  CICSWEEK SUMMARY  Weekly CICS Transactions         2004/12/11 00:00 CICSPA  
_  CPUTREND SUMMARY  Transaction CPU Usage Trend      2004/12/11 00:00 CICSPA  
_  PRODRESP SUMMARY  Production Transaction Response  2004/12/11 00:00 CICSPA  
_  FCHIST   SUMMARY  File Request History             2004/12/11 00:00 CICSPA  
********************************* End of list *********************************
                                                                               
 F1=Help    F3=Exit    F7=Backward    F8=Forward    F10=Actions    F12=Cancel  

Enter line action S to select an HDB for Load processing. You are prompted to specify run-time options, then CICS PA will build the JCL to load data into your HDB.

You can select multiple HDBs to load in succession.

SORT and LOCATE commands are available to help you work with the list of HDBs.

Load creates the JCL that builds the HDBs. The Load process is handled via normal CICS PA command input. This allows multiple reports, extracts and HDBs to be created via a single pass of the SMF data.

Select the required HDB from the list to display the Load panel which is the same for a Load or a Summary HDB.
Figure 2. Load Summary HDB
  File  Systems  Options  Help                                        
--------------------------------------------------------------------- 
                        Load SUMMARY HDB CICSWEEK                     
Command ===> ________________________________________________________ 
                                                                      
Specify HDB load options then press Enter to continue submit.         
                                                                      
System Selection:                       ––––– Report Interval –––––
 APPLID . . CICSPROD  +                      YYYY/MM/DD  HH:MM:SS.TH
 Image  . . ________  +                 From 0_________  09:00:00.00  
 Group  . . ________  +                 To   0_________  16:30:00.00  
                                                                    
DB2 Export Options:                     Table Load Options          
_  Load DB2 Table                       1  1. Resume   2. Replace   
                                                                    
Include Clock Field Components          Summary Options             
1  1. Time and Count                    _  Include Sums of Squares  
   2. Time only                                                     
   3. Count only                        Enter "/" to select option  
                                        /  Edit JCL before submit   

 F1=Help     F3=Exit     F4=Prompt   F6=Resize  F10=Actions F12=Cancel
Specify the run-time options:
System Selection
System Selection specifies the CICS® system(s) whose data is to be loaded into the HDB. It is initialized to the CICS system APPLID that you specified during HDB definition.

In the example above, CICS PA generates an APPLID(CICSPROD) operand in the command deck and includes DD statements for the SMF Files defined in System Definitions for CICSPROD.

Report Interval
Specify the time range of data to be included in the HDB. You can specify an explicit date, such as 2004-12-05, or a relative date to indicate today (0), yesterday (-1), two days ago (-2), and so on. In Figure 2 we have used a relative date of zero (0) to indicate that we are processing today's SMF data, from 9:00am to 4:30pm.

It is recommended that you specify relative dates if you want to use an automated job scheduler to run the load HDB JCL regularly. The JCL can be set up once and run daily without needing to change it.

Edit JCL before submit
Select with a / to edit the JCL before submit. CICS PA will generate the JCL and display it in an ISPF Edit session. You can review or modify the JCL using the usual ISPF Edit commands and actions, or you can use the CREATE command to save the JCL in an external data set.

Then to submit the job, enter SUBmit in the Edit command line.

If this option is not selected, the generated JCL is not displayed and the job is submitted immediately.

After you have specified your Load options, press Enter. You are prompted to Press ENTER to proceed with request. This provides a last opportunity to review and change your load request.


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//users-guide/hdbload.htm