Nastel AutoPilot for IBM DB2

Nastel AutoPilot for IBM DB2

Nastel AutoPilot's transaction monitoring capabilities on System z includes the following specifics for DB2:

  • Stitching MQ and/or CICS transactions to DB2 commands
  • Enables invoking of EXEC SQL commands
  • DB2 Plan Filtering

EXEC SQL Groups include:

  • OPEN
  • FETCH
  • CLOSE
  • PREPARE
  • EXECUTE
  • DESCRIBE
  • EXPLAIN
  • UPDATE
  • DELETE
  • TRUNCATE
  • SET
  • GRANT
  • REVOKE
  • ROLLBACK
  • LOCK
  • CREATE
  • COMMIT
  • INTOPEN
  • DROP
  • ALTER
  • COMMENT
  • CONNECT
  • LABEL
  • RELEASE
  • CALL
  • ALLOCATE
  • ASSOCIATE
  • SIGNAL
  • HOLD
  • FREE
  • DECLARE
  • SAVEPOINT
  • REFRESH
  • GET
  • MERGE
  • EXCHANGE
  • SELECT
  • INSERT
  • REMOTE
  • RENAME