Results 1 to 14 of 14
  1. #1
    Join Date
    Jul 2003
    Posts
    25

    Unanswered: db2 add container..

    Hi i;m very new on DB2, there is things i still can't understand.

    if you add container to tablespace using number of pages, how we calculate the pages to add to have the same container size.
    eg.


    Tablespace ID = 20
    Name = PSAPPOOLI
    Type = Database managed space
    Contents = Any data
    State = 0x0000
    Detailed explanation:
    Normal
    Total pages = 1024000
    Useable pages = 1023984
    Used pages = 489272
    Free pages = 534712
    High water mark (pages) = 489272
    Page size (bytes) = 4096
    Extent size (pages) = 8
    Prefetch size (pages) = 8
    Number of containers = 2

    the size of the container is
    -rw------- 1 db2d01 dbd01adm 2097152000 Jul 17 10:01 PSAPPOOLI.container000

    is the numpber of pages only total pages / #containers ? or we have to llok on the page size too ?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you want to see how the existing containers are defined (especially the the number of pages), use the Control Center, or the db2look command. See the Command Reference manual for how to use db2look and how to get the DDL for tablespaces.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2003
    Posts
    25

    Wink

    Hi sorry, we are on AIX, and no COntrol Center installed, and we prefer to do it from CLI.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can use the Control Center on your windows client connecting into the AIX server.

    If you don't want to do that, the other part of my answer said to use db2look. RTFM.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jul 2003
    Posts
    25
    Hi . thanks for the answer my DB2 is
    DB21085I Instance "db2p01" uses "64" bits and DB2 code release "SQL08023" with
    level identifier "03040106".
    Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", and FixPak
    "10".
    Product is installed at "/usr/opt/db2_08_01".

    and i try to issue dblook command.. but i guess there is none in mya system

    i just want to know how i can define the pages number ..

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by mudai
    and i try to issue dblook command.. but i guess there is none in mya system
    Apparently not.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Jun 2006
    Posts
    471

    ts

    db2 list tablespace containers for 20
    or db2 list tablespaces show detail listed
    1024000 pages for this tablespace (see top) = total pages
    if just 1 container defined : container = 1024000 pages
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    "get snapshot for tablespaces on <your db alias>" will probably list all containers, with their respective sizes.

  9. #9
    Join Date
    Jul 2003
    Posts
    25

    Talking

    Quote Originally Posted by Marcus_A
    Apparently not.
    Yep.. manage to find it.. but iread in the IBM doc i ahve to execute it using jave, using java to execute is very troublesome.

    still prefer Command Lines, i move from Informix , so the java fancy things for me is very new. and i hate java

  10. #10
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by mudai
    Yep.. manage to find it.. but iread in the IBM doc i ahve to execute it using jave
    Here is what I think you should do. Send me you PayPal account information, and I will send you 50 cents (USD) so you can call your mother and tell her that you are not going to make it as a DBA.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  11. #11
    Join Date
    Mar 2003
    Posts
    343
    You would use total_pages in the first output that you posted with.

  12. #12
    Join Date
    Jul 2003
    Posts
    25
    yes.. thank you sir.. now i'm realizing it..

    Thank you very much all

  13. #13
    Join Date
    Jul 2003
    Posts
    25
    Quote Originally Posted by Marcus_A
    Here is what I think you should do. Send me you PayPal account information, and I will send you 50 cents (USD) so you can call your mother and tell her that you are not going to make it as a DBA.
    Hi sir.. thank you for your comment

  14. #14
    Join Date
    Apr 2009
    Location
    Usa
    Posts
    1

    Nice package of funny pics for you to see

    Want to share with you some of celebrity movies from my home site. Just look what Emma Watson do in time of crysis!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •