Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

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

int 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:00.