構文
[code lang=text]
runstats on table [スキーマー名].[テーブル名] and index all;
[/code]
例1
[code lang=text]
runstats on table db2admin.USER_MTR and index all;
[/code]
例2
[code lang=text]
db2 select ‘runstats on table db2admin.’|| tabname || ‘ and index all;’
from syscat.tables
where tabschema = ‘DB2ADMIN’;
[/code]
コメントを残す