zOs/SQL/TT
SELECT *
FROM SYSIBM.SYSVIEWDEP
WHERE dName = 'VQZ040BIND'
;
select count(*), dbid, obid
from sysibm.sysTables
where type in ('T', 'M')
group by dbid,obid
order by 1 desc
fetch first 10 row only
with ur;;;
select * from gdb9998.twk401a;x;
lock table A540769.twk600a005 in exclusive mode;
select count(*) from
A540769.twk600a005
where part = 3
with ur
;;;
set current sqlid = 'S100447';
alter sequence A540769.SEQDNW5KHJU1PNK restart;
rollback;
alter tablespace DB2TS.QRMCZ01S secQty -1;
alter tablespace DSNADMDB.DSNADMTS secQty -1;
alter tablespace DSNATPDB.DSNATPTS secQty -1;
alter tablespace DSNHMDB.DSNHMTS secQty -1;
alter tablespace DSNRLST.DSNRLST0 secQty -1;
alter tablespace DSNXSR.SYSXSR secQty -1;