Create the Data Store

Describes how to create a data store.
caddb220
CA Detector® for DB2 for z/OS
 (CA Detector) collects SQL data during the specified time interval. When the time interval expires, the collected data is discarded and data collection for the next interval begins. If you want to review data from previous intervals, you must save the collected data to a data store before the next interval starts. A 
data store
 is a collection of data sets that retain historical data.
  • If you are using CA Detector for the first time, you can skip this section and proceed to Create the Collection Profile. However, if you skip this section, you cannot collect exception SQL data and you cannot perform the steps in View Exception SQL Collection Data.
  • For more information about data stores, including space requirements, see Create a Data Store for Collected Data.
Follow these steps:
 
  1. Type 
    7
     in the Option line on the CA Detector Main Menu and press Enter.
    The Create Datastore Display appears.
  2. Specify the following information to create the data store:
    • Enter a subsystem identifier in the Datastore SSID field. The data store will retain the data that is collected for this subsystem.
    • Enter a high-level qualifier for the data store in the High Level field.
    • Type 
      TUTORIAL
       in the Datastore Name field. This field provides a name for the data store.
    • Type 
      005
       in the Max intervals field to store five intervals in the data store. When a sixth interval completes, it erases the first interval. The sixth interval is stored in the space that the first interval had used.
    • Type 
      Y
       in the Exception SQL field to store data for exception SQL collection.
    • Type 
      Y
       in the SQL Error field to store data for SQL error collection.
    • Type 
      N
       in the Batch JCL field to create the data store online in this TSO session rather than in batch.
    Press Enter.
    The Standard Activity Collection Dataset display appears.
  3. Specify the following standard activity SQL collection data set information:
    • If your site does not use SMS, enter a volume name in the Volume field.
    • Type 
      CYLS
       in the Alloc unit field to allocate the primary and secondary space quantities in cylinders.
    • Type 
      0050
       in the Primary space field to allocate 50 cylinders of primary space.
    • Type 
      0025
       in the Secondary space field to allocate 25 cylinders of secondary space.
    • If your site uses SMS, enter class information in the SMS MGMT, SMS STORAGE, and SMS DATA fields. The class names are installation-specific. If necessary, see your database administrator for SMS information.
    Press Enter.
    The Exception SQL Collection Datasets display appears.
  4. Specify the following allocation criteria:
    For the data store data set:
    • If your site does not use SMS, enter a volume name in the Volume field.
    • Type 
      CYLS
       in the Alloc unit field to allocate the primary and secondary space quantities in cylinders.
    • Type 
      0050
       in the Primary space field to allocate 50 cylinders of primary space.
    • Type 
      0020
       in the Secondary space field to allocate 20 cylinders of secondary space.
    • If your site uses SMS, enter class information in the SMS MGMT, SMS STORAGE, and SMS DATA fields.
    For the data store work file data set:
    • If your site does not use SMS, enter a volume name in the Volume field.
    • Type 
      CYLS
       in the Alloc unit field to allocate the primary and secondary space quantities in cylinders.
    • Type 
      0040
       in the Primary space field to allocate 40 cylinders of primary space.
    • Type 
      0020
       in the Secondary space field to allocate 20 cylinders of secondary space.
    • If your site uses SMS, enter class information in the SMS MGMT, SMS STORAGE, and SMS DATA fields.
    Press Enter.
    The SQL Error Collection Dataset panel appears.
  5. Specify the following information for the data sets to hold SQL error collection:
    • If your site does not use SMS, enter a volume name in the Volume field.
    • Type 
      CYLS
       in the Alloc unit field to allocate the primary and secondary space quantities in cylinders.
    • Type 
      0050
       in the Primary space field to allocate 50 cylinders of primary space.
    • Type 
      0025
       in the Secondary space field to allocate 25 cylinders of secondary space.
    • If your site uses SMS, enter class information in the SMS MGMT, SMS STORAGE, and SMS DATA fields.
    Press Enter.
    The Create Datastore Display appears with a message indicating that the data store has been created.