How to turn off auto storage allocation for a dbspace ?

Technote (FAQ)


Question

How to turn off auto storage allocation for a dbspace ?

Answer

You can prevent any individual dbspace from expanding by setting both "storage provisioning sizes" to 0 with the following SQL:
dbaccess sysadmin -<<END
execute function task("modify space sp_sizes","<dbspace name>", 0, 0);
END

Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

11.70, 12.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

Developer, Enterprise, Express, Growth, Hypervisor, Innovator, Ultimate, Workgroup

Reference #:

1677758

Modified date:

2014-06-29

Translate my page

Machine Translation

Content navigation