Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Posts
    2

    Unanswered: stmt_text is null

    Hi,

    i can get statement text from table function SNAP_GET_STMT , i am getting null value in stmt_text . Can any one clarify me why am always getting null value in stmt_text column.

    i am running this query in db2 v10

    select AGENT_ID,DB_NAME,STMT_USR_CPU_TIME_MS,STMT_SYS_CPU _TIME_MS,STMT_TEXT from TABLE(SNAP_GET_STMT('',-1))

    AGENT_ID DB_NAME STMT_SYS_CPU_TIME STMT_TEXT
    26776 SAMPLE 0 (null)
    26795 SAMPLE 0 (null)
    26775 SAMPLE 0 (null)


    thanks & regards
    selva

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Maybe DFT_MON_STMT is off?
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •