• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

query TSMDB1.events_sql

winprod

ADSM.ORG Member
Joined
Sep 7, 2011
Messages
17
Reaction score
0
Points
0
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.
 

Trident

TSM/Storge dude
ADSM.ORG Moderator
Joined
Apr 2, 2007
Messages
530
Reaction score
58
Points
0
Location
Oslo, Norway
Website
www.basefarm.no
Hi,

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

winprod

ADSM.ORG Member
Joined
Sep 7, 2011
Messages
17
Reaction score
0
Points
0
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.
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,615
Reaction score
578
Points
0
Location
Canada
Website
www-947.ibm.com
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?
 

AngeloDeAngelis

ADSM.ORG Member
Joined
May 3, 2019
Messages
13
Reaction score
1
Points
0
Location
USA
Website
www.ibm.com
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?
 

winprod

ADSM.ORG Member
Joined
Sep 7, 2011
Messages
17
Reaction score
0
Points
0
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
 

winprod

ADSM.ORG Member
Joined
Sep 7, 2011
Messages
17
Reaction score
0
Points
0
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
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 18 18.2%
  • Keep using TSM for Spectrum Protect.

    Votes: 61 61.6%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.1%
  • Other (please comement)

    Votes: 8 8.1%

Forum statistics

Threads
31,748
Messages
135,357
Members
21,744
Latest member
tsm
Top