ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to use IDB2 to identify application causing CONDBAT to hit in Production DB2s?

book

Article ID: 199722

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

CONDBAT hit on all 3 PROD DB2's as shown below. How to use IDB2 to identify application causing this. 

DSNA

 Friday 11TH SEP 2020 first time msg occurred after which issue seems to have build up

 17.18.26 STC86626  DSNL030I  @ DSNLILNR DDF PROCESSING FAILURE FOR  834   

   834               LUWID=GA03319F.FF22.000000000000                     

   834               REASON=00D31034                                       

   834               THREAD-INFO=*:*:*:*:*:*:*                                                           

Sunday 13TH SEP 2020 first time msg occurred after which issue seems to have build up

16.28.17 STC86626  DSNL030I  @ DSNLILNR DDF PROCESSING FAILURE FOR  128     

   128               LUWID=GA03319F.D2BF.000000000000                       

   128               REASON=00D31034                                        

   128               THREAD-INFO=*:*:*:*:*:*:*        

DSNE

 Friday 11TH SEP 2020 first time msg occurred after which issue seems to have build up

 17.34.26 STC86630  DSNL030I  # DSNLILNR DDF PROCESSING FAILURE FOR  501   

   501               LUWID=GA03319F.C5AB.000000000000                      

   501               REASON=00D31034                                      

   501               THREAD-INFO=*:*:*:*:*:*:*                            

Sunday 13TH SEP 2020 first time msg occurred after which issue seems to have build up                    

15.55.29 STC86630  DSNL030I  # DSNLILNR DDF PROCESSING FAILURE FOR  530                               

   530               LUWID=GA03319F.D101.000000000000                   

   530               REASON=00D31034                                    

   530               THREAD-INFO=*:*:*:*:*:*:*          

 DSNP

 Friday 11TH SEP 2020 first time msg occurred after which issue seems to have build up

 16.58.41 STC86634  DSNL030I  + DSNLILNR DDF PROCESSING FAILURE FOR  748   

   748               LUWID=GA03319F.FA0E.000000000000                     

   748               REASON=00D31034                                      

   748               THREAD-INFO=*:*:*:*:*:*:*                            

 Sunday 13TH SEP 2020 first time msg occurred after which issue seems to have build up

 17.09.27 STC86634  DSNL030I  + DSNLILNR DDF PROCESSING FAILURE FOR  554    

   554               LUWID=GA03319F.C7BC.000000000000                      

   554               REASON=00D31034                                       

   554               THREAD-INFO=*:*:*:*:*:*:*          

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

From sysview(IDB2) Main Menu select option:

1  System Statistics

From R/SYSSTATS      System Snapshot - 30 Seconds select  6 More

From R/MSYSTEMB      Additional Systems Statistics Displays
 select 11 Remote Locations(R/SYSRMOTE)