Event logging is stored in a flat file, which by default is in dsmserv directory
(/usr/lpp/adsmserv/bin on AIX)

On Mon, 20 Sep 1999, Matthew Glanville wrote:

> 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
> 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
> 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
>