Tablespaces for Content Manager OnDemand system tables
| Table | Tablespace | LOCKSIZE | BUFFERPOOL |
|---|---|---|---|
| ARSAG | ARSAGT | ROW | BP0 |
| ARSAG2FOL | ARSAG2FT | ANY | BP0 |
| ARSAGFLD | ARSAGFLT | ANY | BP0 |
| ARSAGFLDALIAS | ARSAGFAT | ANY | BP0 |
| ARSAGINDEX | ARSAGIDT | ANY | BP0 |
| ARSAGPERMS | ARSAGPET | ANY | BP32K |
| ARSANN | ARSANNT | ANY | BP32K |
| ARSAPP | ARSAPPT | ANY | BP32K |
| ARSAPPUSR | ARSAPPUT | ANY | BP32K |
| ARSCAB | ARSCABT | ANY | BP0 |
| ARSCAB2FOL | ARSCABFT | ANY | BP0 |
| ARSCABPERMS | ARSCABPT | ANY | BP0 |
| ARSCFSODWORK | ARSCFSWT | ANY | BP0 |
| ARSFOL | ARSFOLT | ANY | BP0 |
| ARSFOLFLD | ARSFOLFT | ANY | BP0 |
| ARSFOLFLDUSR | ARSFOLUT | ANY | BP0 |
| ARSFOLPERMS | ARSFOLPT | ANY | BP0 |
| ARSGROUP | ARSGROUT | ANY | BP0 |
| ARSHOLD | ARSHLDT | ANY | BP0 |
| ARSHOLDMAP | ARSHLDMT | ANY | BP0 |
| ARSHOLDPERMS | ARSHLDPT | ANY | BP0 |
| ARSHOLDWORK | ARSHLDWT | ANY | BP0 |
| ARSLOAD | ARSLOADT | ANY | BP0 |
| ARSNAMEQ | ARSNAMET | ANY | BP32K |
| ARSNODE | ARSNODET | ANY | BP0 |
| ARSPRT | ARSPRTT | ANY | BP0 |
| ARSPRTOPTS | ARSPRTOT | ANY | BP0 |
| ARSPRTUSR | ARSPRUST | ANY | BP0 |
| ARSRES | ARSREST | ANY | BP0 |
| ARSSEG | ARSSEGT | ROW | BP0 |
| ARSSET | ARSSETT | ANY | BP0 |
| ARSSYS | ARSSYST | ANY | BP32K |
| ARSUSER | ARSUSERT | ANY | BP0 |
| ARSUSRGRP | ARSUSRGT | ANY | BP0 |
| ARSUSRGRPID | ARSUSGIT | ANY | BP0 |
Note:
- LOCKSIZE ANY usually means PAGE, though Db2® reserves the right to change it to LOCKSIZE ROW in the future.
- All table spaces are defined as a segmented tablespace with SEGSIZE 64, with the exception of ARSSYS, which has a SEGSIZE of 8. ARSSYS only has a single row.
- ARSPRTOPTS is not used. It is assigned to a 4K buffer pool, with a minimum PRIQTY.