The IN_DB_UTIL_SP_CALLSTACK_PRINT stored procedure is used to fetch and print the current call stack depth for the specified identifier(s).
The call stack details for each identifier are stored in the IN_DB_UTIL_CALLSTACK table.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the identifier for which to extend the call stack. | |
| Options |
IN_DB_UTIL SYNC UPGRADE ALL (SYNC and UPGRADE) |
|
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options | YES NO |
|
| V_RETURN_VAL | Type: | RETURN |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the procedure was successful or
not. 0 = SUCCESS 1 = ERROR |
|
Example
EXEC IN_CALLSTACK_PRINT @V_IDENTIFIER; EXEC IN_CALLSTACK_PRINT 'ALL'; EXEC IN_CALLSTACK_PRINT 'IN_DB_UTIL';
Example Output
Example output when executing the IN_DB_UTIL_SP_CLEANUP_AUDIT_DATA procedure.
***** Call Stack Start ***** Identifier Depth SPID Procedure ----------- ------ ------ ----------------------------------- IN_DB_UTIL 1 60 IN_DB_UTIL_SP_CLEANUP_AUDIT_DATA ***** Call Stack End *****
Example output at a specific point during the execution of the IN_DB_UPGRADE_SP_UPTIME_STEPS procedure.
Note: The IN_DB_UPGRADE_SP_UPTIME_STEPS procedure uses the ALL
identifier and uses both the SYNC and UPGRADE identifiers to prevent the execution of
any SYNC and UPGRADE operations from any another session.
***** Call Stack Start ***** Identifier Depth SPID Procedure ----------- ------ ------ ----------------------------------- SYNC 1 56 IN_DB_UPGRADE_SP_UPTIME_STEPS UPGRADE 1 56 IN_DB_UPGRADE_SP_UPTIME_STEPS UPGRADE 2 56 IN_DB_UPGRADE_SP_SCHEMA_UPGRADE_7403_7500 UPGRADE 3 56 IN_DB_UPGRADE_SP_CREATE_INDEXES_IN_DOC ***** Call Stack End *****