Sun Identity Manager 8.1 Business Administrator's Guide

DB2 Database Type

Table B–2 lists the data schema values for the DB2 database type.

Table B–2 Data Schema Values for the DB2 Database Type


Database Column	Value
`id`	`VARCHAR(50) NOT NULL`
`name`	`VARCHAR(128) NOT NULL`
`repomod`	`TIMESTAMP`
`resourceName`	`VARCHAR(128)`
`accountName`	`VARCHAR(50)`
`objectType`	`CHAR(2)`
`objectName`	`VARCHAR(128)`
`action`	`CHAR(2)`
`actionDateTime`	`CHAR(21)`
`actionStatus`	`CHAR(1)`
`interface`	`VARCHAR(50)`
`server`	`VARCHAR(128)`
`subject`	`VARCHAR(128)`
`reason`	`CHAR(2)`
`message`	`VARCHAR(255)` or `CLOB` (See note¹ at end of table.)
`acctAttrChanges`	`CLOB(16M)`
`acctAttr01label`	`VARCHAR(50)`
`acctAttr01value`	`VARCHAR(128)`
`acctAttr02label`	`VARCHAR(50)`
`acctAttr02value`	`VARCHAR(128)`
`acctAttr03label`	`VARCHAR(50)`
`acctAttr03value`	`VARCHAR(128)`
`acctAttr04label`	`VARCHAR(50)`
`acctAttr04value`	`VARCHAR(128)`
`acctAttr05label`	`VARCHAR(50)`
`acctAttr05value`	`VARCHAR(128)`
`parm01label`	`VARCHAR(50)`
`parm01value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm02label`	`VARCHAR(50)`
`parm02value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm03label`	`VARCHAR(50)`
`parm03value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm04label`	`VARCHAR(50)`
`parm04value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm05label`	`VARCHAR(50)`
`parm05value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`sequence`	`CHAR(19)`
`xmlSize`	`DECIMAL(19,0)`
`xml`	`CLOB(16M)`

Note –

The column length limit for these columns is configurable. The default data type is VARCHAR and the default size limit is noted in parentheses. See Audit Log Configuration for information on how to adjust the size limit.