Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table G_LOG_ATTRS


This table stores attributes about the messages stored in the G_LOG_MESSAGES table.

Column List

Legend

Column Data Type P M F Description

ID

NUMERIC(16) X X The unique, autonumbered ID of this record. This is the primary key.

LRID

NUMERIC(16) X Same as G_LOG_MESSAGES.ID.

MESSAGE_ID

INTEGER X Same as G_LOG_MESSAGES.MESSAGE_ID.

ATTR_NAME

VARCHAR(255) X The name of the message attribute. For example, PartitionID or Record_Count for a corresponding G_LOG_MESSAGES record that indicates purging of a partition has begun (GSYS_PURGE_PARTITION purge started ...)

ATTR_VALUE

VARCHAR(255) The value of the message attribute. For example:


"20080930" for an ATTR_NAME of "PartitionID" and "2673" for an ATTR_NAME of "Record_Count"

   

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 31 October 2016, at 16:07.