IN_DB_UTIL_CALLSTACK - Perceptive Content Database IN_DB_UTIL Package 5.0 for SQL Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

This table contains the session callstack for each of the supported identifiers (IN_DB_UTIL, SYNC, UPGRADE) and is maintained by the various procedures and functions of the IN_DB_UTIL framework. You should never need to manually update the records in this table.

The IN_DB_UTIL_SP_CREATE_CALLSTACK_TABLE procedure is used to create this table.

The following framework procedures can be used to interface with this table:

• IN_DB_UTIL_SP_CALLSTACK_PRINT
• IN_DB_UTIL_SP_CALLSTACK_EXTEND
• IN_DB_UTIL_SP_CALLSTACK_TRIM

This table contains the following structure:

CREATE TABLE IN_DB_UTIL_CALLSTACK 
(  
 IDENTIFIER SYSNAME   NOT NULL,  
 DEPTH      SMALLINT  NOT NULL,  
 CALLER     SYSNAME   NOT NULL,  
 SPID       SMALLINT  NOT NULL,  
 CONSTRAINT IN_DB_UTIL_CALLSTACK_
    CHECK_IDENTIFIER     CHECK (IDENTIFIER IN ('IN_DB_UTIL', 'SYNC', 'UPGRADE')),  
 CONSTRAINT IN_DB_UTIL_CALLSTACK_CHECK_DEPTH     
    CHECK (DEPTH >0),  
 CONSTRAINT IN_DB_UTIL_CALLSTACK_UNIQUE_CALLER     
   UNIQUE (IDENTIFIER, CALLER, SPID),  
 CONSTRAINT PK_IN_DB_UTIL_CALLSTACK     
   PRIMARY KEY (IDENTIFIER, DEPTH, SPID) 
);