3 DBA Administration Module

The DBA Administration module allows the DBA Administrator to monitor database information such as table locks, tablespace, indices, and errors.

The chapter describes how to display locks on tables, table information, tablespace information, rollback information, index information, sequence information, and the error log.

The following procedures are included in this section:

• Display Locks on Tables

• Display Table Information

• Display Rollback Information

• Display Index Information

• Display Sequences Information

• Display Error Log

• View Error Log Details

• Delete Error Log Records

• Manual Script Launch Editor

Display Locks on Tables

The user can use the Display Locks on Tables to display the status of the tables.

1. Select the DBA Administration menu.

2. Select the Display Locks on Tables option. The Display Locks on Tables is displayed.

   Figure 3-1 Display Locks on Tables Screen

   
   

3. Click the Exit button to close the window.

Display Table Information

The user can use the Display Table Information option to display specific table information.

Note: The user can monitor the number of extents to detect table growth. A large extent value indicates possible table fragmentation. If the number of extents approaches the maximum, the table should be rebuilt.

1. Select DBA Administration > Display Table Information.

2. In the Display Table Information window, click the Query button.

3. In the Find Table field, enter the name of the table, or click the LOV button and select the table.

4. Click the Search button. The details of the selected table appear.

   Figure 3-2 Display Table Information screen

   
   

   The fields on the Display Table Information screen are explained in the Table 3-1:

   Table 3-1 Fields on the Table Information Screen

   Field Name	Field Description
   Find Table	Table name for table to be queried.
   Table Name	Name of the database table.
   Tablespace Name	Tablespace name.
   Kbytes	Number of (K) bytes in the table.
   Blocks	Number of blocks the table is using.
   Extents Cur.	Current table extents.
   Extents Max	Maximum allowable table extents.

   
   
   
   

   Note: If the user wants to display information about a particular table, enter the specific table name at the Find Table field. The user can also enter a partial table name. For example, the user can enter APP to display all tables that begin with these letters.

   
   

5. Click the Exit button to close the Display Table Information screen.

Display Rollback Information

The user can use the Display Rollback Information option to display information about rollbacks. The user can also use this information to determine whether the rollback segments need to be enlarged for a specific installation.

1. Select the DBA Administration > Display Rollback Information. The Display Rollback Information screen is displayed, along with all rollback segments.

   Figure 3-3 Display Rollback Information Screen

   
   

   The fields on the Display Rollback Information screen are explained in the Table 3-2:

   Table 3-2 Fields on the Display Rollback Information Screen

   Field Name	Field Description
   Rollback Segment	Name of the rollback segment.
   Increase RB	Indicates when additional rollback segments need to be added. YES = rollback segments should be added. NO = rollback segments do not need to be added.
   KSize	Size of rollback segments in bytes.
   Extents	The number of times that the rollback segment had to acquire a new extent
   XACTS	Number of Active Transactions
   WAITS	The number of rollback segment header requests that resulted in waits
   GETS	The number of rollback segment header requests
   OPTSIZE	The value of the optimal parameter for the rollback segment
   STATUS	Status (Online/Offline)
   RRSIZE	Rollback Size

   
   

2. Click the Exit button to return to the Display Rollback Information screen.

Display Index Information

The user can use the Display Index Information option to display sizing information for the database indexes. The user can use this information to analyze the growth of the database indexes, which can indicate table growth.

1. Select DBA Administration > Display Index Information.

2. Click the Query button. In the Target Index query field, enter the name of the index or click the LOV button and select the index. Select the The Display Index Information screen is displayed.

3. Click the Search button. The details of the selected index appear.

   Figure 3-4 Display Index Information screen

   
   

   The fields on the Display Index Information screen are explained in the Table 3-3:

   Table 3-3 Fields on the Display Index Information Screen

   Field Name	Field Description
   Target Index	Index name user wishes to query.
   Segment Name	Name of index.
   Tablespace Name	Tablespace name where the index resides.
   Kbytes	Size of index in kilobytes.
   Blocks	Number of blocks the index is using (1 block = 4096 bytes).
   Extents	Current number of index extents.
   Bytes	Size of index in bytes.

   
   

Display Sequences Information

The user can use the Display Sequence Information option to display sizing information specific to the sequences used by the system. The user can use this information to determine whether a sequence is being called as many times as originally planned.

1. Select DBA Administration > Display Sequences Information. The Display Sequences Information screen is displayed, along with the sequence information already entered into the system.

   Figure 3-5 Display Sequences Information screen

   
   

   The fields on the Display Sequences Information screen are explained in the Table 3-4:

   Table 3-4 Fields on Display Sequences Information Screen

   Field Name	Field Description
   Sequence Name	Name of the database sequence.
   Min Value	Minimum value of the sequence.
   Max Value	Maximum value of the sequence.
   Increment By	Increment, amount the sequence increases after each use.
   Last Number	Last sequence value used. Some sequences cache the values in memory so this number does not increase until the cache is empty and a new group of numbers is cached into memory.
   Cycle Flag	Cycle, whether the sequence rolls back to minimum value when the maximum value is reached.

   
   

2. Click the Exit button to close the Display Sequences Information screen.

Display Error Log

Display Error Log option to display, view details, and delete logged errors. These are unanticipated errors or errors occurring in background processes. You can generate the Error Log report. The report provides the following information for each error: user ID, error time, code, source, location, and message.

1. Select DBA Administration > Display Error Log.

2. Click the Query button.

   The fields on the Display Error Log screen are explained in the Table 3-5:

   Table 3-5 Fields on the Display Error Log Screen

   Field Name	Field Description
   User, Code, Date	Enter any combination of user, error code, or error date to search for records.
   User	User identification.
   Error Time	The date and time the error was logged.
   Code	The error code.
   Error Source	Program where the error originated

   
   

3. Click the Search button to display a list of all existing errors. To display the errors for a particular user, enter the user name in the User field.

   Figure 3-6 Display Error Log Screen

   
   

4. To display a specific error for a particular user, enter the user name in the User field and the error code in the Code field.

5. To display a specific error for a specific user for a particular date, enter the user name in the User field, the error code in the Code field, and the date in the Date field.

   
   

   Note: RWMS accepts any combination of the above fields.

   
   

View Error Log Details

1. Select DBA Administration > Display Error Log.

2. Enter the user, error code, or date to view and click the Search button.

3. Select the record to view in more detail, using the keypad arrow keys to move up and down the list, and then click the Details button. The Error Log screen is displayed.

   Figure 3-7 Details screen

   
   

   The fields on the Details screen are explained in the Table 3-6:

   Table 3-6 Fields on the Error Log screen

   Field Name	Field Description
   User	Identification of the user who had the error.
   Time	Date and time the error was logged.
   Code	The error code.
   Source	The program in which the error originated.
   Location	The location within the source program where the error occurred.
   Message	Full text of the error message.

   
   

4. Click the Cancel button to close the Details screen.

Delete Error Log Records

You can use the batch purge_rwms_tables.sh to remove records from the ERROR_LOG table.

You can also use the batch purge_rwms_tables.sh on PURGE_TABLE_SETUP table to purge just the records you want to use one or multiple columns from the table.

You can also delete the error log records using the GUI. Use the following steps:

1. Select DBA Administration > Display Error Log.

2. Click the Query button or the LOV button to enter the options in the user, error code, or date to delete.

3. Click the Search button. A list of all errors are displayed.

4. Select the record to delete, using the keypad arrow keys to move up and down the list, and then click the Delete Record link. A message box asks to confirm the deletion. The message reads:

   Confirm Delete Operation (Yes/No)
   

5. Click Yes to delete the error log record.

Manual Script Launch Editor

The Manual Script Launch Editor allows the user to submit a real-time batch job with its required parameters within the RWMS application. The user can browse through the latest batch job run histories.

1. Select DBA Administration > Manual Script Launch Editor.

2. Click the Program Name drop down to select the appropriate batch job.

   The fields on the Program Details panel are explained in Table 3-7.

   Table 3-7 Fields on the Program Details Panel

   Field Name	Field Description
   Program Name	The name of the batch program that the user has privileges to execute.
   Description	The description of the batch program name.
   Number of Arguments	The number of input parameters required to execute the batch program.
   Program Created On	Date the batch program was made available for execution from this screen.

   
   

3. Based on the Program Name selected in the Program Details panel, the Program Parameters panel displays the required parameters for the batch program. Parameters such as Facility ID and User ID are defaulted.

4. Click the Run Now button in order to execute the batch program. The status of the execution of the batch program is displayed on the screen.

   Figure 3-8 Manual Script Launch Editor window

   
   

5. The Program Execution History section allows the user to browse through the latest batch executions for the selected batch program. The user can view the jobs sorted by job run dates, job run status, completion time and can drill into further details such as the actual parameters used in the run and log file details. The user can also search for all job requests submitted between a Start Date and End Date. The job status green denotes success and red denotes failure. The View Log hyper link displays logged messages from the actual job run.

6. The Program Execution Details section displays the input parameters for the job selected in the Program Execution History section.