Hello All!
I was just wondering why I am not receiving any output? I am issuing the
following select statement and I get nothing in return, but as you can see
in the activity log there is info within it for those numbers. Any
suggestions would be appreciated. Thanks!
select date(date_time),time(date_time),nodename,sessid,session,process from
actlog where date_time=current_timestamp - 3 days and msgno=1064.988 order
by process
Date/Time Message
--------------------
----------------------------------------------------------
04/25/05 19:04:01 ANR0984I Process 1686 for BACKUP NAS (DIFFERENTIAL)
start
ed in the FOREGROUND at 19:04:01. (SESSION: 106935,
PROC
ESS: 1686)
04/25/05 19:04:01 ANR1064I Differential backup of NAS node
NAS_SERVER_4, fi
le system /.etc_common, started as process 1686 by
admin
istrator LIDZR8V. (SESSION: 106935, PROCESS: 1686)
04/25/05 19:04:01 ANR2753I (NAS_4-DIFFERENTIAL):ANR0984I Process 1686
for B
ACKUP NAS (SESSION: 106935)
04/25/05 19:04:01 ANR2753I (NAS_4-DIFFERENTIAL):ommon, started as
process 1
686 by adm (SESSION: 106935)
04/25/05 19:04:26 ANR0513I Process 1686 opened output volume N00021.
(SESSI
ON: 106935, PROCESS: 1686)
04/25/05 19:06:01 ANR1067I NAS Backup process 1686 completed. (SESSION:
106
935, PROCESS: 1686)
04/25/05 19:06:01 ANR2753I (NAS_4-DIFFERENTIAL):ANR1067I NAS Backup
process
1686 comp (SESSION: 106935)
04/25/05 19:06:01 ANR0988I Process 1686 for BACKUP NAS (DIFFERENTIAL)
runni
ng in the FOREGROUND processed 65,536 bytes with a
compl
etion state of SUCCESS at 19:06:01. (SESSION:
106935, PR
OCESS: 1686)
04/25/05 19:06:01 ANR2753I (NAS_4-DIFFERENTIAL):ANR0988I Process 1686
for B
ACKUP NAS (SESSION: 106935)
04/25/05 19:06:01 ANR0515I Process 1686 closed volume N00021. (SESSION:
106
935, PROCESS: 1686)
04/27/05 08:36:29 ANR2017I Administrator LIDZR8V issued command: QUERY
ACTL
OG begind=04/24/2005 begint=00:00 search="process
1686"
(SESSION: 127880)
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|