Hi.

I want to increase the SMS filesystems (two). Not having done this
before, I am not too sure about any possible consequences. From my
reading the planning guide, it seems I can simply add more space to the
filesystem (being system managed) as I would any other filesystem.

Is this correct?

Thanks for your help.

Kush

Kush wrote:

> Hi.
>
> I want to increase the SMS filesystems (two). Not having done this
> before, I am not too sure about any possible consequences. From my
> reading the planning guide, it seems I can simply add more space to the
> filesystem (being system managed) as I would any other filesystem.
>
> Is this correct?

Correct.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Thanks for the reply Knut.

Can you tell me how the SMS storage is treated? Is the whole storage,
container, treated like a file? What I mean is that I have two
filesystems right now and they both are 64gb in size. The AIX file size
limit is 64gb but the filesystem size limit is 1tb. Can I increase my
two SMS filesystems to more than 64gb or do I have to add another
"container" of 64gb size?

Thanks,

Kush

Knut Stolze wrote:
> Kush wrote:
>
> > Hi.
> >
> > I want to increase the SMS filesystems (two). Not having done this
> > before, I am not too sure about any possible consequences. From my
> > reading the planning guide, it seems I can simply add more space to the
> > filesystem (being system managed) as I would any other filesystem.
> >
> > Is this correct?
>
> Correct.
>
> --
> Knut Stolze
> DB2 Information Integration Development
> IBM Germany

Kush wrote:

> Can you tell me how the SMS storage is treated? Is the whole storage,
> container, treated like a file? What I mean is that I have two
> filesystems right now and they both are 64gb in size. The AIX file size
> limit is 64gb but the filesystem size limit is 1tb. Can I increase my
> two SMS filesystems to more than 64gb or do I have to add another
> "container" of 64gb size?

Have a look at one of these containers. You will find a regular file system
with a directory/files structure.

SMS containers are directories. Inside those directories, DB2 creates
separate files for table data and indexes (and whatever else is needed).
So the answer is that the 64GB limit will only be an issue if one of those
multiple files would reach the limit. (I don't know if DB2 would detect
such a situation and automatically create a 2nd file.)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany