HP3000-L Archives

May 2005, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Sarbanes-Oxley and LOGLIST
From:
Mike Hornsby <[log in to unmask]>
Reply To:
Mike Hornsby <[log in to unmask]>
Date:
Tue, 3 May 2005 09:16:22 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (70 lines) 
>
>
>can catchlog report the *session id*?  we can easily see user.account
>but without the session id we don't have the granularity that we need.
>
>
Seems to be a bug with Image logging. The log record has a "USER
IDENTIFIER" field between
the user/group/account and the dbname/group/account fields. However the
"USER IDENTIFIER"
is blank in all of the cases I tested. If the logging portion of IMAGE
were open source we would
be glad to fix it directly. I'll look at this to see if a binary patch
can be developed.

If you aren't using Image logging then what is backing up you backup?

Cordially,
Mike Hornsby
Beechglen Development Inc.
Support for HP3000s since 1988
513-922-0509



fcopy from=slog;to=;char;subset="OP",21
HP31900A.05.04 FILE COPIER (C) HEWLETT-PACKARD CO. 1999


SLOG RECORD 2 (%2, #2)

00000: ....3.I......{...?.?OP..USER    ACCT    GRP             DB
GRP     AC
00044: CT    .@..LOGID   .z.*..QUERY   PUB     SYS     ............
00110: SAME: TO 000200-1


DBOPEN
HALFWORD(0-8) - MPE WRITELOG RECORD
HALFWORD(9) - TURBOIMAGE/XL LOG RECORD LENGTH
HALFWORD(10) - DBOPEN LOG RECORD CODE ("OP")
HALFWORD(11) - BASE LOGGING ID
BIT 0 TO 5 = USER DBOPEN COUNT
BIT 6 TO 15 = INDEX TO THE DBS FOR THE DBG
HALFWORD(12) - USER NAME
HALFWORD(16) - USER GROUP
HALFWORD(20) - USER ACCOUNT
HALFWORD(24) - USER IDENTIFIER
HALFWORD(28) - DATABASE NAME
HALFWORD(31) - DATABASE GROUP
HALFWORD(35) - DATABASE ACCOUNT
HALFWORD(39) - SECURITY CLASS
HALFWORD(40) - DBOPEN MODE PARAMETER
HALFWORD(41) - LOGGING IDENTIFIER
HALFWORD(45) - DBSTORE TIME STAMP (3 HALFWORDS)
HALFWORD(48) - USER PROGRAM NAME
HALFWORD(52) - USER PROGRAM GROUP
HALFWORD(56) - USER PROGRAM ACCOUNT
HALFWORD(60) - MODE FROM WHO INTRINSIC
HALFWORD(61) - CAPABILITY FROM WHO INTRINSIC
HALFWORD(63) - LOCAL ATTRIBUTE FROM WHO INTRINSIC
HALFWORD(65) - LOGICAL DEVICE OF JOB/SESSION INPUT
HALFWORD(66) - PREVIOUS ROLLBACK TIME STAMP (3 HALFWORDS)
HALFWORD(69) - CURRENT ROLLBACK TIME STAMP (3 HALFWORDS)
HALFWORD(72) - RESERVED FOR DBRECOV RUN TIME USE
HALFWORD(73) - RESERVED FOR DBRECOV RUN TIME USE

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2