By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,235 Members | 1,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,235 IT Pros & Developers. It's quick & easy.

Increasing SMS filesystem - AIX 5.3 running DB2 V8.1

P: n/a
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

Aug 16 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Aug 16 '06 #2

P: n/a
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
Aug 17 '06 #3

P: n/a
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
Aug 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.