query TSMDB1.events_sql

winprod

ADSM.ORG Member
Joined
Sep 7, 2011
Messages
17
Reaction score
0
Points
0
PREDATAR Control23

When I run queries directly in DB2, TSMDB1.events_sql I always get 0 results

db2 connect to TSMDB1
db2 set schema TSMDB1
C:\Program Files\Tivoli\TSM\db2\BIN>db2 select * from TSMDB1.events

DATABASE_NAME TOT_FILE_SYSTEM_MB USED_DB_SPACE_MB FREE_SPACE_MB TOTAL_PAGES USABLE_PAGES USED_PAGES FREE
_PAGES BUFF_HIT_RATIO TOTAL_BUFF_REQ SORT_OVERFLOW PKG_HIT_RATIO LAST_REORG FULL_DEV_CLASS
NUM_BACKUP_INCR LAST_BACKUP_DATE PHYSICAL_VOLUMES NUM_BACKUP_STREAMS COMPRESS_DB_BACKUPS PROTECT_MAS
TER_KEY
------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ----
----------------- -------------- --------------------- --------------------- ------------- -------------------------- --------------------------------
--------------------------------- --------------------- -------------------------- ---------------- ------------------ ------------------- -----------
-------

0 record(s) selected.
 
PREDATAR Control23

What do you get when doing select * from events from dsmadmc?
 
PREDATAR Control23

Hi,

If memory servers me right, events is a table that is generated each time you query from it within dsmadmc.
 
PREDATAR Control23

What do you get when doing select * from events from dsmadmc?

DATABASE_NAME TOT_FILE_SYSTEM_MB USED_DB_SPACE_MB FREE_SPACE_MB TOTAL_PAGES USABLE_PAGES USED_PAGES FREE
_PAGES BUFF_HIT_RATIO TOTAL_BUFF_REQ SORT_OVERFLOW PKG_HIT_RATIO LAST_REORG FULL_DEV_CLASS
NUM_BACKUP_INCR LAST_BACKUP_DATE PHYSICAL_VOLUMES NUM_BACKUP_STREAMS COMPRESS_DB_BACKUPS PROTECT_MAS
TER_KEY
------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ----
----------------- -------------- --------------------- --------------------- ------------- -------------------------- --------------------------------
--------------------------------- --------------------- -------------------------- ---------------- ------------------ ------------------- -----------
-------

0 record(s) selected.
 
PREDATAR Control23

DATABASE_NAME TOT_FILE_SYSTEM_MB USED_DB_SPACE_MB FREE_SPACE_MB TOTAL_PAGES USABLE_PAGES USED_PAGES FREE
_PAGES BUFF_HIT_RATIO TOTAL_BUFF_REQ SORT_OVERFLOW PKG_HIT_RATIO LAST_REORG FULL_DEV_CLASS
NUM_BACKUP_INCR LAST_BACKUP_DATE PHYSICAL_VOLUMES NUM_BACKUP_STREAMS COMPRESS_DB_BACKUPS PROTECT_MAS
TER_KEY
------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ----
----------------- -------------- --------------------- --------------------- ------------- -------------------------- --------------------------------
--------------------------------- --------------------- -------------------------- ---------------- ------------------ ------------------- -----------
-------

0 record(s) selected.
That’s from DB2, dsmadmc doesn’t return column headers and would return “ANR2034E SELECT: No match found using this criteria.” If no rows are found. What does it return from dsmadmc?
 
PREDATAR Control23

What are we looking for? There is the "summary" table that can be used with "Activity"=
There are a series of activities one might want to view or look for...
What are we looking to do?
 
PREDATAR Control23

What are we looking for? There is the "summary" table that can be used with "Activity"=
There are a series of activities one might want to view or look for...
What are we looking to do?


This is the same query frome another server, this is the results im looking for
SCHEDULED_START ACTUAL_START DOMAIN_NAME SCHEDULE_NAME NODE_NAME STATUS RESULT REASON COMPLETED

-------------------------- -------------------------- ------------------------------ ------------------------------ ---------------------------------------------------------------- ------------------------- ----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------

2020-01-14-22.00.00.000000 2020-01-14-22.00.19.000000 GENERAL SQDWPV02 SQDWPV02 Completed 0 All operations completed successfully. 2020-01-14-22.00.24.000000

2020-01-14-22.00.00.000000 2020-01-14-22.00.13.000000 GENERAL SQDWTV04 SQDWTV04 Completed 0 All operations completed successfully. 2020-01-14-22.00.25.000000
 
PREDATAR Control23

That’s from DB2, dsmadmc doesn’t return column headers and would return “ANR2034E SELECT: No match found using this criteria.” If no rows are found. What does it return from dsmadmc?

from dsmadmc i do get my events im looking for
 
Top