SQL statements of package not available in db2 catalog table -
i want check sql statements of db2 packages. there no statements available in db2 catalog tables.
i used query :
select stmt sysibm.syspackstmt name =<package-name>
but there no statements in stmt column
. can please suggest else can check sql statements of package?
fyi, using db2 z/os v10
. going migrate v11
before want make sure packages referincing sysstr system tablespace
modified part of pre-migration v11
.
thanks in advance.
maybe can there. on db2 z/os v10 , found table called
sysibm.syspackstmt
in table there column called stmt empty column called statement , contains sql statements. have table
select stmnt_id, statement sysibm.syspackstmt name = <package name>
edit: ok there no column statement in table syspackstmt: here columns table has on our z/os db2 v10. can't exclude table different doubt system table of db2
- location
- collid
- name
- contoken
- seqno
- stmtno
- sectno
- binderror
- ibmreqd
- version
- stmt
- isolation
- status
- accesspath
- stmtnoi
- sectnoi
- explainable
- queryno
- rowid
- stmt_id
- statement
- stmtblob
if syspackstmt table contains different columns afraid can't you. on companies db2 looks , statement column contains sqls. if different suggest talking db admins.
edit2: link official db2 documentation ibm. lists statement column wih description:
the complete text sql statement row represents.
Comments
Post a Comment