Ansicht
Dokumentation

BC505TS1 - Make a tablespace nearly full and guarantee a critical object in it

Description

Report BC505TS1 is used for training purposes. Table BC505TS is dropped if it exists and then recreated with new storage parameters in tablespace PSAPUSER1D. INIT is set to a very big value. The value is chosen according to freespace in PSAPUSER1D and varies between 8K and 100 MB. NEXT is set to 512K. Then the table is inserted until less than 5MB storage space are available in tablespace PSAPUSER1D. NEXT is then set to 5MB. Allocation of a next extent for BC505TS will fail.

Output

Runtimes will become very long if freespace is very large in PSAPUSER1D. The program will work for freespace as large as 290 MB. At least 32 K freespace must be available.

Output

No output.

Example

Execute report BC505TS1 as a preparation for reports BC505TS2 and BC505TS3.