Indexspace

Posted in 2010

Felix Schäfer — Mon, 26 Jul 2010 09:48:01 — source: IIUG Forums & Mailing Lists

Hello, Is there a way to define a default dbspace for indexes, akin to the DBSPACETEMP parameter? I scourged the docs but wasn't able to find anything. Thanks, Felix

↪ replying to Felix Schäfer

Keith Simmons — Mon, 26 Jul 2010 10:00:02 — source: IIUG Forums & Mailing Lists

On 26 July 2010 10:48, Felix Schäfer <schaefer@cypres-it.com> wrote: > Hello, > > Is there a way to define a default dbspace for indexes, akin to the > DBSPACETEMP parameter? I scourged the docs but wasn't able to find anything. > > Thanks, > > Felix > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Felix Not really, indexes are created in the same space as the associated table unless the 'IN' clause is specified, also tables are created in the smae space as the database unless the 'IN' clause is specified, so I suppose that is the default unless overridden at create time. Keith

Glossary

dbspace