informix表空间相关资料整理（国外英文资料）.doc

informix表空间相关资料整理（国外英文资料） The informix table space planning command is organized Initialize informix database: oninit - ivy At this point, the database is empty, nothing. We need to plan the database space, create the corresponding physical table Spaces, logical table Spaces, and temporary table Spaces. First, create the corresponding files under the DBS directory and grant permissions: Touch phydbs logdbs appdbs temp01 temp01 temp02 temp0temp04 Chmod 660 phydbs logdbs appdbs temp01 temp01 temp02 temp02 temp03 temp04 Execute the command to create a table space: Onspaces - c-d phydbs - p {informixdir} / DBS/phydbs - o 0-s 500000. Onspaces - c-d logdbs - p {informixdir} / DBS/logdbs - o 0-s 1000000 (10 logical files in general) Onspaces - c-d appdbs - p {informixdir} / DBS/appdbs - o 0-s 4000000 (the size of your own database depends on the actual situation) Onspaces temp01 - t - d - c - p {informixdir} / DBS/temp01 -o 0 -s 500000 [temporary table space, generally for four, size of 500 m, much more attention to create a temporary table space command -t 】 Onspaces - c-d temp02-t - p {informixdir} / DBS/temp02-o 0-s 500000 Onspaces - c-d temp03-t - p {informixdir} / DBS/temp03-o 0-s 500000 Onspaces - c-d temp04-t - p {informixdir} / DBS/temp04-o 0-s 500000 Switch physical logs: Onparams -p-s 480000 - d phydbs (note: the size is a little smaller than creating phydbs or the size is too large.) IBM Informix Dynamic Server must be in quiescent mode You can switch to static mode using onmode. You can also restart oninit - sy Switch logical logs: First, create the logical file: For (I = 0; I 10; I + +)) do onparams -a-d logdbs -s 100000 - I; The done. The last logical file creation will not be successful, as the previous physical log prompts will, to make the resize slightly smaller. Second: switch the logical log The onmode -l is executed several times until the logical log is switched to the newly created logical file. First: delete the original logical file Onparams - d-l