Create a Data Store

After you calculate the space requirements, you are ready to create the data store.
caddb2
After you calculate the space requirements, you are ready to create the data store. A data store is a collection of VSAM linear data sets with the following naming convention:
high-level.datastore_name.
DTR
nnnn.ssid
You specify the 
high-level
datastore_name
, and 
ssid
 values when you create the data store. DTR
nnnn
 identifies the data set. The 
nnnn
 is a 4-byte identifier:
  • 0001
    Indicates an activity collection data set. This data set is always created.
  • 0002
    Indicates an exception SQL collection data set. This data set also contains SQL error text and host variables. This data set is created only when you specify Exception SQL (Y) on the Create Datastore Display to collect exception SQL data.
  • W002
    Indicates a data store work file. This work file is a VSAM entry-sequenced data set (ESDS), and is created only when you specify Exception SQL (Y) on the Create Datastore Display.
  • 0003
    Indicates an SQL error collection data set. This data set is created only when you specify SQL Error (Y) on the Create Datastore Display to collect SQL error data.
After you create a data store, we recommend that you set up a schedule to unload the collection data to a separate file regularly. Unloading the data lets you archive it for later reference. Unloading the data also enables you to load it into DB2 tables and query it.
Follow these steps:
 
  1. Access the 
    Create Datastore Display
     panel by performing 
    one
     of the following actions:
    • Select option 
      7
       (
      Create/Initialize Datastore
      ) on the 
      CA Detector Main Menu
       and press Enter.
    • Type 
      Y
       in the 
      Create Datastore
       field on the 
      Start Collection Display
       and press Enter.
  2. Complete the following fields:
    • Datastore SSID
      Specifies the DB2 subsystem ID for which the data store is being created.
    • High Level
      Specifies the high-level qualifier for the data store.
    • Datastore name
      Specifies a data store name. The name must be unique for the DB2 subsystem ID. The name is used in the data set names that are created for the data store.
    • Max intervals
      Specifies the maximum number of collection intervals to retain in the data store.
    • Exception SQL
      Specifies whether to include exception SQL in the data store.
    • SQL Error
      Specifies whether to include SQL errors in the data store.
    • Batch JCL
      Specifies whether to run the JCL in batch.
    Press Enter.
    The 
    Create Data store Display/Standard Activity Collection Data Set
     panel appears.
  3. Complete the data set allocation criteria for standard collection activity and press Enter.
    • If you entered 
      N
       in the 
      Exception SQL
       and 
      SQL Error
       fields, a message indicates successful initialization of the data store. You are done.
    • If you entered 
      Y
       in the 
      Exception SQL
       or 
      SQL Error
       fields, a panel appears for each option. Go to Step 4.
  4. Complete the data set allocation criteria for the exception SQL collection and SQL error data sets and press Enter.
    A message indicates successful initialization of the data store.
Example: Data Store Creation
 
Create a data store with the following attributes:
  • The high-level qualifier is DSNM
    x
    .
  • The data store name is COLLD11A.
  • The subsystem is D11A.
Also specify that you want the data store to collect exception SQL and SQL error data.
When you create the data store, the following data sets are generated:
Data Set Name
 
Collection Type
 
DSNMx.COLLD11A.DTR0001.D11A
Activity
DSNMx.COLLD11A.DTR0002.D11A
Exception SQL
DSNMx.COLLD11A.DTRW002.D11A
Exception SQL (work file)
DSNMx.COLLD11A.DTR0003.D11A
SQL error