Tablespace qualifier in DB2 UDB On Linux/Unix/Windows

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sekhar.mekala@gmail.com
    #1

    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
    Tags: None
    • 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

                Previous template Next
                Working...