informix execute function admin用法总结

普通的dbspaces：
EXECUTE FUNCTION ADMIN ('create dbspace', 'testdbs', '/home/informix/chunks/testchk', '30M', '0K', '8K');

创建临时dbspaces：
EXECUTE FUNCTION ADMIN ('create tempdbspace', 'testdbs', '/home/informix/chunks/testchk', '30M', '0K', '8K');

创建blob spaces：
EXECUTE FUNCTION ADMIN ('create blobspace', 'testdbs', '/home/informix/chunks/testchk', '30M', '0K', '8K');

创建智能大对象：
EXECUTE FUNCTION ADMIN ('create sbspace', 'testdbs', '/home/informix/chunks/testchk', '30M', '0K');

删除表空间：
EXECUTE FUNCTION ADMIN ('drop sbspace', 'testdbs');

设置可扩展性：
EXECUTE FUNCTION ADMIN ('modify space sp_sizes', 'testdbs', '10', '1000');

设置空间扩展：
EXECUTE FUNCTION ADMIN ('modify space expand', 'datadbs1', '10000K');

扩展chunk:
EXECUTE FUNCTION ADMIN ('add chunk', 'datadbs1', '/home/informix/chunks/datachk1_2', '10M', '0M');

 

===========================================================

未完，待补充