Viewing database update activities

Sometimes you need to identify the update activity that has occurred against an IMS database.

For example, you might need to diagnose the cause of database lock situations or find the reason why an excessive amount of processing has been performed against the database. Log Analyzer can provide this information.

Example

The following example shows control statements for the collection of information about the activities that occurred for a transaction (HA90810) on January 30, 2007, from 8:10 to 8:15 in the morning:

ANALYZE
   SLDS=(BMC.TEST019.SLDS,R91)
   LRCPDS=RIHJER.LUI.CNTL
FILTER
   SEL = DEST =  HA90810
INTERVAL
   START=2007030/08100000
   STOP=2007030/08150100
REPORTS
   SUMM=ALL
   LSUMM=000001010
   LDET=0000003010
END

The following example shows a portion of an Analysis Summary report that was generated by the control statements from the previous example. The report shows that all of the activity against transaction HA90810 originated from the APPC/OTMA environment.

 2007-267                                         Log Analyzer for IMS V1.1.00
                                             Analysis Summary (SUMMARY)
LOG time span: FROM 2004-306 12:39:04.7 TO 2004-306 12:57:29.2

**********************
Record and LUOW Counts
**********************
Log records read   002000453    Passed to select process   001738375    Selected log records 000265110
LUOWs              000025151    Unresolved associations    000037660    Extract file count   000000000
IMSIDs encountered: BMC9


**********                                                                                       
LUOW Lists                                                                                       
**********                                                                                       
 Origin summary           Destination summary        Other LUOWs              User IDs           
********************     ********************       ********************     ********************
 Total number of          Total number of            Total number of          Total number of    
  Origins 0000001          Dests   0000001            Others  0000016          Users   0000084   
  LUOWs   0017628          LUOWs   0017628            LUOWs   0007523          LUOWs   0017628   

 -Origin- -LUOWs-         -Dest-   -LUOWs-           -Other-  -LUOWs-         -User-   -LUOWs-   
 appcotma 0017628         HA90810  0017628           COMMAND  0000001         A015242  0000001   
                                                     CONV0001 0000503         A023839  0000003   
                                                     DB EXTEN 0000006         A029168  0000006   
                                                     DB/PSB   0000002         A042635  0000001   
                                                     DBUPDATE 0000001         A045967  0000002   
                                                     DELTA    0000001         A054472  000000

 

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