zOs/SQL/VVLOCMAX
select 'ts ' || strip(s.dbName) || '.' || strip(s.name)
|| ' locksize=' || lockRule || ' lockMax=' || lockMax
|| ' tb=' || strip(t.creator) || '.' || t.name
from sysibm.sysTablespace s
left join sysibm.sysTables t
on s.dbName = t.dbName and s.name = t.tsName and t.type = 'T'
where s.dbName like 'VV%'
and (lockRule not in ('A', 'P')
or lockMax <> -1
)
order by s.dbName, s.name
;x;
select count(*), lockRule, lockMax
from sysibm.sysTablespace
where dbName like 'VV%'
group by lockRule, lockMax
;
select substr(strip(s.dbName) || '.' || strip(s.name), 1, 16)
, s.lockRule, s.lockMax
, strip(t.creator) || '.' || t.name
from sysibm.sysTablespace s
left join sysibm.sysTables t
on s.dbName = t.dbName and s.name = t.tsName and t.type = 'T'
where s.dbName like 'VV%'
and (lockRule not in ('A', 'P')
or lockMax <> -1
)
order by s.dbName, s.name
$#out 20150318 11:09:31
COL1
ts VV20A1P.A701A locksize=R lockMax=-1 tb=OA1P.TVV701A1
ts VV20A1P.A702A locksize=R lockMax=-1 tb=OA1P.TVV702A1
ts VV20A1P.A703A locksize=R lockMax=-1 tb=OA1P.TVV703A1
ts VV20A1P.A709A locksize=R lockMax=-1 tb=OA1P.TVV709A1
ts VV20A1P.A715A locksize=R lockMax=10000 tb=OA1P.TVV715A1
ts VV20A1P.A719A locksize=A lockMax=10000 tb=OA1P.TVV719A1
ts VV20A1P.A744A locksize=A lockMax=10000 tb=OA1P.TVV744A1
ts VV21A1P.VDPS004 locksize=R lockMax=10000 tb=VDPS2.VTINSTRFLATDATA
ts VV21A1P.VDPS025 locksize=R lockMax=-1 tb=VDPS2.VTMIFIDCATEGORY
ts VV21A1P.VDPS026 locksize=R lockMax=10000 tb=VDPS2.VTINSTRFLATSYMBOLS
ts VV21A1P.VDPS035 locksize=R lockMax=-1 tb=VDPS2.VTCFPLAN
ts VV21A1P.VDPS043 locksize=R lockMax=99999 tb=OA1P.TVV_VTSTRIKEBARRIERDEFINITIO
ts VV21A1P.VDPS045 locksize=R lockMax=-1 tb=OA1P.TVV_CTMANDATORINSTITUTIONFLAG
ts VV21A1P.VDPS047 locksize=R lockMax=99999 tb=OA1P.TVV_VTSTRIKEBARRIERDETAIL
ts VV22A1P.VDPS054 locksize=R lockMax=-1 tb=OA1P.TVV_VTAFFECTEDSTRIKEPROPS
ts VV22A1P.VDPS068 locksize=R lockMax=-1 tb=VDPS2.VTDENOMINATION
ts VV22A1P.VDPS070 locksize=R lockMax=-1 tb=OA1P.TVV_VTINSTITUTIONFLAG
ts VV22A1P.VDPS078 locksize=R lockMax=-1 tb=VDPS2.VTEQUITY
ts VV22A1P.VDPS079 locksize=R lockMax=-1 tb=VDPS2.VTP42TOFFLISTING
ts VV22A1P.VDPS081 locksize=R lockMax=-1 tb=VDPS2.VTCLEARINGCUSTODY
ts VV22A1P.VDPS084 locksize=R lockMax=-1 tb=VDPS2.VTGUARANTY
ts VV22A1P.VDPS093 locksize=R lockMax=-1 tb=VDPS2.VTGENINFORMATION
ts VV22A1P.VDPS100 locksize=R lockMax=10000 tb=VDPS2.VTINDEXINSTR
ts VV23A1P.VDPS112 locksize=R lockMax=-1 tb=VDPS2.VTINSTIINSTIROLE
ts VV23A1P.VDPS117 locksize=R lockMax=10000 tb=VDPS2.VTINSTIROLE
ts VV23A1P.VDPS148 locksize=R lockMax=10000 tb=VDPS2.VTINSTRIDENT
ts VV24A1P.VDPS153 locksize=R lockMax=-1 tb=VDPS2.VTINSTRNAME
ts VV24A1P.VDPS157 locksize=R lockMax=-1 tb=VDPS2.VTINSTRRESTRICTION
ts VV24A1P.VDPS164 locksize=R lockMax=10000 tb=VDPS2.VTINSTRSTRUCT
ts VV24A1P.VDPS168 locksize=R lockMax=10000 tb=VDPS2.VTINSTRUMENT
ts VV24A1P.VDPS174 locksize=R lockMax=-1 tb=VDPS2.VTISSUECONDITION
ts VV24A1P.VDPS181 locksize=R lockMax=-1 tb=OA1P.TVV_VTPROVATCASHFLOW
ts VV24A1P.VDPS183 locksize=R lockMax=-1 tb=OA1P.TVV_CTMANDATORINSTRUMENTFLAG
ts VV24A1P.VDPS185 locksize=R lockMax=10000 tb=VDPS2.VTLISTING
ts VV24A1P.VDPS188 locksize=R lockMax=-1 tb=VDPS2.VTLISTINGGRPKEY
ts VV24A1P.VDPS190 locksize=R lockMax=10000 tb=VDPS2.VTLISTINGIDENT
ts VV25A1P.VDPS220 locksize=R lockMax=-1 tb=VDPS2.VTPAYMENTPLAN
ts VV25A1P.VDPS227 locksize=R lockMax=-1 tb=OA1P.TVV_VTPORTFOLCRITSET
ts VV25A1P.VDPS230 locksize=R lockMax=10000 tb=OA1P.TVV_VTPORTFOLIOGROUP
ts VV25A1P.VDPS231 locksize=R lockMax=10000 tb=OA1P.TVV_VTPORTFOLCRITERIA
ts VV25A1P.VDPS241 locksize=R lockMax=-1 tb=VDPS2.VTREPAYMENTPLAN
ts VV25A1P.VDPS248 locksize=R lockMax=10000 tb=OA1P.TVV_VTWITHHOLDINGTAX
ts VV26A1P.VDPS255 locksize=R lockMax=-1 tb=VDPS2.VTSTOPPINGRANGE
ts VV26A1P.VDPS261 locksize=R lockMax=10000 tb=VDPS2.VTTAXRATEKEY
ts VV26A1P.VDPS294 locksize=R lockMax=10000 tb=VDPS2.VTTRUSTDETAIL
ts VV27A1P.VDPS302 locksize=R lockMax=-1 tb=VDPS2.VTRESTRICTIONSUSP
ts VV27A1P.VDPS305 locksize=R lockMax=-1 tb=OA1P.TVV_CTMANDATORINSTRUMENTGROUPKE
ts VV27A1P.VDPS312 locksize=R lockMax=-1 tb=OA1P.TVV_VTINSTRUMENTFLAG
ts VV27A1P.VDPS313 locksize=R lockMax=-1 tb=OA1P.TVV_CTMANDATORINSTITUTIONGROUPK
ts VV27A1P.VDPS315 locksize=R lockMax=10000 tb=VDPS2.CTCODESET
ts VV27A1P.VDPS321 locksize=R lockMax=10000 tb=VDPS2.CTINSTRDETAILS
ts VV27A1P.VDPS322 locksize=R lockMax=10000 tb=VDPS2.CTINSTRMANDDET
ts VV27A1P.VDPS323 locksize=R lockMax=10000 tb=VDPS2.CTINSTRSP42DETAILS
ts VV27A1P.VDPS324 locksize=R lockMax=10000 tb=VDPS2.CTLISTING
ts VV27A1P.VDPS332 locksize=R lockMax=-1 tb=OA1P.TVV_VTPROVBBCURRENCY
ts VV27A1P.VDPS333 locksize=R lockMax=-1 tb=OA1P.TVV_VTPROVBBPREFERRED
ts VV27A1P.VDPS335 locksize=R lockMax=-1 tb=OA1P.TVV_VTPROVBBINDEX
ts VV27A1P.VDPS344 locksize=R lockMax=-1 tb=VDPS2.VTCFDETAIL
ts VV28A1P.VDPS351 locksize=R lockMax=-1 tb=VDPS2.VTCFREPAYMENT
ts VV28A1P.VDPS352 locksize=R lockMax=-1 tb=VDPS2.VTCFCOMPONENTPROP
ts VV28A1P.VDPS353 locksize=R lockMax=10000 tb=VDPS2.VTCASHFLOWTAXAMT
ts VV28A1P.VDPS360 locksize=R lockMax=10000 tb=VDPS2.VTINSTRUMENTEVENT
ts VV28A1P.VDPS361 locksize=R lockMax=-1 tb=VDPS2.VTTAXRATETAXAMOUNT
ts VV28A1P.VDPS364 locksize=R lockMax=-1 tb=VDPS2.VTUNDERFXCOMPONENT
ts VV28A1P.VDPS370 locksize=R lockMax=-1 tb=VDPS2.VTCFEXERCISE
ts VV28A1P.VDPS371 locksize=R lockMax=-1 tb=VDPS2.VTCFEVENT
ts VV28A1P.VDPS374 locksize=R lockMax=10000 tb=OA1P.TVV_VTPROVBBBOND
ts VV28A1P.VDPS377 locksize=R lockMax=10000 tb=OA1P.TVV_VTPROVBBINSTRUMENT
ts VV28A1P.VDPS378 locksize=R lockMax=-1 tb=OA1P.TVV_VTPROVBBTOFF
ts VV28A1P.VDPS393 locksize=R lockMax=10000 tb=VDPS2.VTTRANSFORMEVENT
ts VV28A1P.VDPS398 locksize=R lockMax=-1 tb=VDPS2.DTEUTAXLOCSPEC
ts VV29A1P.VDPS436 locksize=R lockMax=-1 tb=VDPS2.XTACCTGINFOBATCH
ts VV29A1P.VDPS438 locksize=A lockMax=10000 tb=VDPS2.XTACCTGINFOCALLUP
ts VV29A1P.VDPS441 locksize=R lockMax=-1 tb=OA1P.TVV_XTACCTGINFOCALLUPSUM
ts VV29A1P.VDPS445 locksize=R lockMax=-1 tb=OA1P.TVV_XTORDER
75 rows fetched: select 'ts ' || strip(s.dbName) || '.' || strip(s.name) |...
SQLCODE = -104: ILLEGAL SYMBOL "X". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE
ASSOCIATE
src x
> <<<pos 1 of 1<<<
sql = x
sqlCode 0: rollback
$#out