---
title: "How to Check Trigger Details in SYSIBM Tables"
description: "When a trigger is created, DB2 creates a trigger package for the statements in the triggered action. The trigger package is recorded in SYSIBM.SYSPACKAGE and has the same name as the trigger. https://..."
url: https://srinimf.com/2014/12/17/cobol-db2-trigger-package/
date: 2014-12-17
modified: 2026-10-10
author: "Srini"
categories: ["DB2"]
tags: ["COBOL Tips and Tricks", "DB2 Triggers"]
type: post
lang: en
---

# How to Check Trigger Details in SYSIBM Tables

When a trigger is created, DB2 creates a trigger package for the statements in the triggered action. The trigger package is recorded in** SYSIBM.SYSPACKAGE** and has the same name as the trigger.

Related[Db2- SQL Error -805 Resolution](https://srinimf.com/2013/07/29/db2-sql-error-805-resolution/)

---

Before a trigger is created, it is good practice to ensure that there are no packages with the same name as the trigger being created.

[![Srinimf IT Jobs](https://i0.wp.com/srinimf.com/wp-content/uploads/2014/12/untitled1.png?resize=576%2C400&ssl=1)](http://srinimf.jobthread.com)*Srinimf IT Jobs*

**When the Trigger is Activated**

The trigger package is always accessible and can be executed only when a trigger is activated by a triggering operation.

“*By default, when a trigger is created, the trigger package is bound by DB2 with EXPLAIN set to NO.*“

Trigger packages are recorded in the SYIBM.SYSPACKDEP table with column DTYPE set to “T”.

When the trigger is first created, you will not have the access paths for the SQL statements in the trigger.

However, you can immediately rebind the trigger package specifying EXPLAIN YES to obtain access paths. To rebind the trigger package, issue the REBIND TRIGGER PACKAGE command.

To delete the trigger package, you must use the DROP TRIGGER statement.

Related Posts

- [How to create Triggers in SQL](https://srinimf.com/2011/01/02/db2-triggers/)DateJanuary 2, 2011
- [DB2 Schema creating process for a User](https://srinimf.com/2016/06/14/db2-schema-creating-process-for-a-user/)DateJune 14, 2016
- [More on SQL Triggers in DB2 Context](https://srinimf.com/2012/04/01/db2-triggers-part-2/)DateApril 1, 2012

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2014%2F12%2F17%2Fcobol-db2-trigger-package%2F&media=https%3A%2F%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2014%2F12%2Funtitled1.png&description=How%20to%20Check%20Trigger%20Details%20in%20SYSIBM%20Tables)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/12/17/cobol-db2-trigger-package/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/12/17/cobol-db2-trigger-package/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/12/17/cobol-db2-trigger-package/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/12/17/cobol-db2-trigger-package/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Check%20Trigger%20Details%20in%20SYSIBM%20Tables&body=https%3A%2F%2Fsrinimf.com%2F2014%2F12%2F17%2Fcobol-db2-trigger-package%2F&share=email)
-

### Like this:

Like Loading…