HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Warning Messages (Cont.)
34404 MESSAGE No other session is waiting on this session.
(DBWARN 34404)
CAUSE The LOCK IMPEDE screen was being accessed when this
message was displayed. The session that is being
analyzed is not holding any lock that is causing
another session to wait.
ACTION No action is necessary. Check that you have
specified the correct session.
----------------------------------------------------------------------------
34405 MESSAGE XID changed while collecting data! (DBWARN
34405)
CAUSE The LOCK SESSION, LOCK IMPEDE, or LOCK TABSUMMARY
screen was being accessed when this message was
displayed. To minimize performance degradation of
the DBEnvironment, SQLMON itself never holds locks
or latches in the LOCK subsystem; it essentially
performs "dirty" reads to collect data. While data
was being collected, the transaction id of the
session being analyzed changed.
ACTION No action is necessary. When interpreting the
screen, keep in mind that the information displayed
may represent locks from two different
transactions.
----------------------------------------------------------------------------
34406 MESSAGE Lock information changed while collecting data!
(DBWARN 34406)
CAUSE The LOCK OBJECT screen was being accessed when this
message was displayed. To minimize performance
degradation of the DBEnvironment, SQLMON itself
never hold locks or latches in the LOCK subsystem;
it essentially performs "dirty" reads to collect
data. SQLMON has detected that an inconsistent
snapshot may have been taken.
ACTION Ignore the information displayed on the screen.
----------------------------------------------------------------------------
34500 MESSAGE SET DBENVIRONMENT command has not been issued
yet. (DBWARN 34500)
CAUSE You tried to access an SQLMON screen without naming
the database that you wish to examine.
ACTION Issue a SET DBENVIRONMENT command.
----------------------------------------------------------------------------
34505 MESSAGE DBEnvironment is not active (no other session in
progress). (DBWARN 34505)
CAUSE Except for your SQLMON session, the database is
idle.
ACTION You can only access screens in the STATIC
subsystem. All other screens display information
that is only available when the database is active.
----------------------------------------------------------------------------
34510 MESSAGE DBEnvironment is in the process of shutting down
(RC 215). (DBWARN 34510)
CAUSE The DBA has probably issued a STOP DBE command.
Once it has completed, the database will be idle.
ACTION No action is necessary. When the database becomes
idle, you will only be able to access screens in
the STATIC subsystem.
----------------------------------------------------------------------------
34511 MESSAGE DBEnvironment transaction limit has been reached.
(DBWARN 34511)
CAUSE A timeout occurred when SQLMON tried to begin a
transaction, probably because the configured limit
for the maximum number of active transactions has
been reached.
ACTION Access the OVERVIEW screen: the MAX XACT field
displays the transaction limit, and the ACTIVE XACT
field displays the current number of active
transactions. You may wish to use the SQLUtil
ALTDBE command to increase the transaction limit.
Also, use the SET command to check the current
value of the USERTIMEOUT variable, which specifies
the number of seconds that SQLMON will wait before
timing out. You may wish to use the SET
USERTIMEOUT command to increase the value, and then
issue your original command again.
----------------------------------------------------------------------------
34515 MESSAGE Could not obtain share lock on SUBSYSTEM CATALOG.
(DBWARN 34515)
CAUSE SQLMON could not read from an internal table.
ACTION Please contact your HP Service Representative or
Response Center.
----------------------------------------------------------------------------
34518 MESSAGE Not attempting to map information from
SYSTEM.TABLE. (DBWARN 34518)
CAUSE In shared memory, table ids are represented by
TIDs. During the SET DBENVIRONMENT command, SQLMON
normally reads from SYSTEM.TABLE to obtain
information that maps each TID to an OWNER.TABLE
name. Because of some error, SQLMON is not able to
read from SYSTEM.TABLE. Therefore, table names will
be displayed in TID format, instead of as
OWNER.TABLE strings.
ACTION Resolve the error, and try again. If necessary,
contact your HP Service Representative or Response
Center.
----------------------------------------------------------------------------
34519 MESSAGE Not attempting to map information from
SYSTEM.INDEX. (DBWARN 34519)
CAUSE In shared memory, B-tree index ids are represented
by TIDs. During the SET DBENVIRONMENT command,
SQLMON normally reads from SYSTEM.INDEX to
obtain information that maps each TID to an
OWNER.TABLE/INDEX name. Because of some error,
SQLMON is not able to read from SYSTEM.INDEX.
Therefore, index names will be displayed in TID
format, instead of as OWNER.TABLE/INDEX strings.
ACTION Resolve the error, and try again. If necessary,
contact your HP Service Representative or Response
Center.
----------------------------------------------------------------------------
34520 MESSAGE Not attempting to map information from
SYSTEM.DBEFILE. (DBWARN 34520)
CAUSE In shared memory, DBEFile ids are represented by
integers. During the SET DBENVIRONMENT command,
SQLMON normally reads from SYSTEM.DBEFILE to obtain
information that maps each integer to a DBEFile
name. Because of some error, SQLMON is not able to
read from SYSTEM.DBEFILE. Therefore, DBEFile names
will be displayed as integers, instead of strings.
ACTION Resolve the error, and try again. If necessary,
contact your HP Service Representative or Response
Center.
----------------------------------------------------------------------------
34521 MESSAGE Not attempting to map information from
SYSTEM.CONSTRAINT. (DBWARN 34521)
CAUSE In shared memory, referential constraint (PCR) ids
are represented by TIDs. During the SET
DBENVIRONMENT command, SQLMON normally reads from
SYSTEM.CONSTRAINT to obtain information that maps
each PCR TID to an OWNER.TABLE/CONSTRAINT name.
Because of some error, SQLMON is not able to read
from SYSTEM.CONSTRAINT. Therefore, PCR names will
be displayed in TID format, instead of as
OWNER.TABLE/CONSTRAINT strings.
ACTION Resolve the error, and try again. If necessary,
contact your HP Service Representative or Response
Center.
----------------------------------------------------------------------------
34580 MESSAGE USERTIMEOUT exceeded maximum, so it was reset to
! seconds. (DBWARN 34580)
CAUSE You probably tried to issue a SET USERTIMEOUT
command using a timeout value that was larger than
the maximum timeout value that has been configured
for the database. The USERTIMEOUT variable has
automatically been reset to the maximum timeout
value, which is displayed in the message.
ACTION No action is necessary.
----------------------------------------------------------------------------