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