CODEWITHSUNDEEP
databaseinformix
Starc
Starc

Reputation: 117

How can I mark a chunk to extendable while adding a chunk to dbspace using onspaces command in Informix?

I would like to know if I can mark a chunk to extendable while adding a chunk to a dbspace using the onspaces command itself. There is a column called is_extendable in the syschunks table in the sysmaster database. How do you enable it while adding a chunk to a dbspace?

Upvotes: 1

Views: 278

Answers (1)

Ricardo Henriques
Ricardo Henriques

Reputation: 1086

Take a look at Automatic space management, it's only available since 11.70.

In particular, Marking a chunk as extendable or non-extendable indicates that you do not use onspaces but you use (for example) DB-Access to execute an administrative function:

To mark a chunk as extendable:

  • Run the admin() or task() function with the modify chunk extendable argument, as follows:

      EXECUTE FUNCTION task("modify chunk extendable", "chunk number");

To mark a chunk as not extendable:

  • Run the admin() or task() function with the modify chunk extendable off argument, as follows:

      EXECUTE FUNCTION task("modify chunk extendable off", "chunk number");

Upvotes: 4

Related Questions