Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • sekhar.mekala@gmail.com

    Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

    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

    #2
    Re: Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

    sekhar.mekala@g mail.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.





    Comment

    • sekhar.mekala@gmail.com

      #3
      Re: Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

      On Jul 9, 3:33 pm, Ian <ianb...@mobile audio.comwrote:
      sekhar.mek...@g mail.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.
      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

      Comment

      • Serge Rielau

        #4
        Re: Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

        sekhar.mekala@g mail.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

        Comment

        Working...