Extract DB2 Audit Content Command:
(Sample)
db2audit extract delasc to . from files ~/sqllib/security/auditdata/db2audit.instance.log.0.20130320085414
Wednesday, March 20, 2013
DB2 Memo
Structure low - > high
Physical Page * 4 ( or * 8) = Extent * 1
Multi Extent = Table * 1
!! 1 Extent only contain 1 Table data !!
normal table with Single dimensional Clustering only can be sort by 1 column. ( command: organie by (column1) )
Multidimensional Clustering Table can be sort by more thane 1 column. ( command: organie by (column1,column2,..,columnX) )
Multidimensional Clustering Index will automatic create when Table create.
Subscribe to:
Posts (Atom)