Skip to Content

Overview of customizable reports

You can customize the reports by changing the report layout, user-defined variables, Structured Query Language (SQL), and processing logic, or you can use the external functions provided to write your own report programs.

The DASD MANAGER PLUS report programs are written in REXX, a general-purpose, interpreted language that exists on all z/OS systems. Because REXX is an interpreted language, the development cycle for REXX programs is short. Specifically, you edit and run instead of edit, compile, link, bind, and run.

Related topics

Using

Customizable-report-programs-and-customization

DASD MANAGER PLUS provides the following features that are not available in REXX on z/OS:

  • Dynamic SQL
  • Report page layout
  • Real-time listing of volume space
  • Real-time access to the Integrated Catalog Facility (ICF) catalog

DASD MANAGER PLUS provides these features through the external functions listed in the following table:

External functions not available in REXX

External function

Description

ASURXSQL (REXX SQL)

ASURXSQL runs the following database attachment and SQL statements:

  • CONNECT
  • DISCONNECT
  • OPEN cursor
  • FETCH cursor
  • CLOSE cursor
  • SELECT
  • COMMIT
  • ROLLBACK

ASURXSQL functionality goes beyond reporting. Using ASURXSQL, you can run any SQL statement including the following statements:

  • CREATE
  • INSERT
  • UPDATE
  • DELETE
  • GRANT

The ability to modify the SQL or substitute new SQL gives the report programs their great flexibility.

ASURXRPT (REXX Report)

ASURXRPT handles a variety of reporting tasks, such as initializing the report, formatting and writing it, creating page breaks, and releasing resources at the end of processing.

ASURXLSP (REXX LSpace)

ASURXLSP reads the volume table of contents of direct access storage devices (DASD VTOCs) to collect real-time information about space on volumes.

ASURXSE (REXX Space Estimation)

ASURXSE returns the reorganized space for the specified partitioned table space, nonpartitioned table space, table or index.

ASURXLOC (REXX Locate)

ASURXLOC is a real-time data collector that accesses the ICF catalog to find the volumes where data sets are stored and the number of extents that the data sets are in.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

DASD MANAGER PLUS for DB2 13.1