Hidden SQL table for events logging?
1999-09-20 17:38:08
Subject: |
Hidden SQL table for events logging? |
From: |
Matthew Glanville <mwg AT KODAK DOT COM> |
Date: |
Mon, 20 Sep 1999 17:38:08 -0400 |
I was just brushing up on using the select command in ADSM, and i cannot
seem to find any table that
contains the recent events.
What table does the information when you issue the following command
come from?
adsm> q event * *
Scheduled Start Actual Start Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
---------
09/20/99 00:05:00 09/20/99 00:30:14 DAILY MYNODE
09/20/99 00:05:00 09/20/99 00:30:14 DAILY MYNODE
Completed
...
My guess is it may be from some sort of combination between the ACTLOG
and CLIENT_SCHEDULES and ASSOCIATIONS.
I thought I would ask here before I do any major searching on each table
for things.
Anyone have any ideas?
Matt Glanville
mwg AT kodak DOT com
(pick one)
adsm> select tabname from syscat.tables
TABNAME
------------------
ACTLOG
ACTLOG
ADMINS
ADMIN_SCHEDULES
ARCHIVES
AR_COPYGROUPS
ASSOCIATIONS
AUDITOCC
BACKUPS
BU_COPYGROUPS
CLIENTOPTS
CLIENT_SCHEDULES
CLOPTSETS
CONTENTS
DB
DBBACKUPTRIGGER
DBSPACETRIGGER
DBVOLUMES
DEVCLASSES
DOMAINS
DRIVES
DRMCSTGPOOLS
DRMEDIA
DRMMACHINE
DRMMACHINECHARS
DRMMACHINENODE
DRMMACHINERECINST
DRMMACHINERECMEDIA
DRMPSTGPOOLS
DRMRECOVERYMEDIA
DRMSRPF
DRMSTANZA
DRMSTATUS
DRMTRPF
FILESPACES
GROUP_MEMBER
LIBRARIES
LIBVOLUMES
LICENSES
LOG
LOGSPACETRIGGER
LOGVOLUMES
MEDIA
MGMTCLASSES
NODES
OCCUPANCY
OPTIONS
POLICYSETS
PROCESSES
PROFILES
PROF_ASSOCIATIONS
RECLAIM_ANALYSIS
RESTORES
SCRIPTS
SCRIPT_NAMES
SERVERS
SERVER_GROUP
SESSIONS
SPACEMGFILES
STATUS
STGPOOLS
SUBSCRIPTIONS
VOLHISTORY
VOLUMES
VOLUMEUSAGE
COLUMNS
ENUMTYPES
TABLES
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Hidden SQL table for events logging?,
Matthew Glanville <=
|
|
|