Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

[sekhar.mekala]

Hello,
I am a DB2 DBA on IBM Mainframe environment. I recently started
learning DB2 on Unix/Windows environment. Can any one answer the
following questions:

1. What is the qualifier that is used to identify tablespaces in DB2
UDB on Linux/Unix/Windows environmet? On z/OS, it is the database name
that qualifies the tablespace names.

2. Is the DPF (Database Partitioning Feature) is just a paper based
licence? I mean, can I start using DPF if I just have paper that
states that I can use DPF feature in DB2?

Thanks in advance!!

Best regards,
Sekhar

[Ian]

se***********@gmail.com wrote:

Hello,
I am a DB2 DBA on IBM Mainframe environment. I recently started
learning DB2 on Unix/Windows environment. Can any one answer the
following questions:

1. What is the qualifier that is used to identify tablespaces in DB2
UDB on Linux/Unix/Windows environmet? On z/OS, it is the database name
that qualifies the tablespace names.

There is no tablespace qualifier. You can only connect to one database
at a time, so there's no concept of three part names. (Though there
is an exception to this with nicknames).

2. Is the DPF (Database Partitioning Feature) is just a paper based
licence? I mean, can I start using DPF if I just have paper that
states that I can use DPF feature in DB2?

You need to install the DPF enablement license using the db2licm
utility.

[sekhar.mekala]

On Jul 9, 3:33*pm, Ian <[e-mail]:

[e-mail] wrote:

Hello,
I am a DB2 DBA on IBM Mainframe environment. I recently started
learning DB2 on Unix/Windows environment. Can any one answer the
following questions:

1. What is the qualifier that is used to identify tablespaces in DB2
UDB on Linux/Unix/Windows environmet? On z/OS, it is the database name
that qualifies the tablespace names.

There is no tablespace qualifier. *You can only connect to one database
at a time, so there's no concept of three part names. *(Though there
is an exception to this with nicknames).

2. Is the DPF (Database Partitioning Feature) is just a paper based
licence? I mean, can I start using DPF if I just have paper that
states that I can use DPF feature in DB2?

You need to install the DPF enablement license using the db2licm
utility.

Thanks for your reply.
I thought that table spaces can also be qualified by schema names in
open system environment.

One more question:
Can Indexes have a page size greater than 4KB in Linux/Unix/Windows
environment? Because in z/OS, Indexes cannot have a page size greater
than 4KB.

Regards,
Sekhar

[Serge Rielau]

se***********@gmail.com wrote:

One more question:
Can Indexes have a page size greater than 4KB in Linux/Unix/Windows
environment? Because in z/OS, Indexes cannot have a page size greater
than 4KB.

Yes they can. So you can get up to 32KB index pagesize which gives you a
maximum key size of 16KB (not that you want to do that....)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab