Previous Topic Next topic Print topic


Submitting a JCL to Perform Sampling

Use the Work with Jobs tool in Data Builder to submit the JCL that performs the actual sampling.
  1. From Data Builder, in the List of Data Stores in the Work with Data Stores window, expand the DATA EXPRES Machine ID and select the DEMO company.
  2. Select a data store with the Machine ID DATA EXPRES and the company DEMO, right-click, and then click Data Store Properties.

    Note that the Classification number is 1. By default all data stores are assigned a Classification number of 1, which means that sampling is enabled. Classification numbers are used to restrict the data stores that get sampled and to and to provide further granularity in restricting which data stores get sampled as based on user-defined criteria. When sampling the data stores within your work environment, all enabled data stores with Classification number values of 1 will be sampled. To disable sampling, change the Classification number to 0 in the Properties – File window or right-click the row for the data store in the Work with Data Stores and click Disable Sampling.

    The data store remains enabled as long as the Classification number is not 0. However, just because sampling is enabled does not mean that the data store is a candidate for sampling as this is controlled by the Classification number specified in the Secondary Options for the job that submits the JCL. If the Classification number set for the data store is less than or equal to the Classification number specified in the Distributed Sampler, the data store will be sampled. Likewise, if the data store Classification number is greater than the Classification number in the Distributed Sampler, the data store will not be sampled.

    Tip: You can assign classification numbers to your data stores based on how often you want to sample data. For example, 1 could represent daily sampling, 2 could represent weekly sampling, and 3 could represent monthly sampling.
  3. Click OK.
  4. Open the Work with Jobs window (Environment > Work with Jobs) to schedule a new job.
  5. Click New.
  6. In the List of Jobs, select the job BURSAMR (Data Store Data Element Sampling).
  7. Select the DATAEXPRES Machine ID and the DEMO company name.
  8. Click Apply.
  9. Retain all default sampling values. For this exercise, all data stores should be sampling candidates and all sampling options should be utilized.

    The following list describes the sampling Options:

    Compressed sampling

    Produces the data element fingerprint. The fingerprint graphically shows the distribution of values within a given range for the sampled data element. The fingerprints for numeric and alphanumeric data elements differ in that the fingerprint for an alphanumeric data element shows the distribution of values based on the first character and provides additional information.

    Standard sampling

    Displays information for each data element value including the number of times each value occurred and the percentage that value represents in the total population.

    Min/Max calculation

    Displays the minimum and maximum values for the data element.

  10. Click Advanced.
  11. Retain all default values.
    Note: The Data Element Size of 0 (zero) means to include all sizes in the sampling results and does not actually reflect the value of 0 when Ignore Special Values Zero / Space is checked. Likewise, the default 0 values in Max. And Min. Recalculation Additional Options mean to consider all values to be in-range and does not reflect the value of 0.
  12. Click OK.
  13. In your TSO environment, submit the BURSAMR job by using the Submit Client Scheduled Job panel.
  14. In the Work with Jobs area, click Refresh to verify that the job completed successfully.
  15. Close the Work with Jobs window.
  16. In your mainframe environment, verify the sampling results.
  17. Continue to the next section.
Previous Topic Next topic Print topic