Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    3

    Unanswered: Equivalent system tables in db2

    Hai,

    What is the equivalent DB2 tables for the following oracle tables
    v$session
    v$parameter
    Sys.dba_segments

    Thanks,
    Priya

  2. #2
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41
    i am not familiar with this oracle tables... what data would these tables return?

    you can check the system tables of DB2 (the ones with the SYSIBM schema)

    or check the views

    There are 10 kinds of people,
    those who know binary and those who don't.

    http://www.linkedin.com/in/rtitong

  3. #3
    Join Date
    Apr 2002
    Posts
    3
    In oracle sys.dba_segments table has the following colunms


    OWNER VARCHAR2(30)
    SEGMENT_NAME VARCHAR2(81)
    PARTITION_NAME VARCHAR2(30)
    SEGMENT_TYPE VARCHAR2(18)
    TABLESPACE_NAME VARCHAR2(30)
    HEADER_FILE NUMBER
    HEADER_BLOCK NUMBER
    BYTES NUMBER
    BLOCKS NUMBER
    EXTENTS NUMBER
    INITIAL_EXTENT NUMBER
    NEXT_EXTENT NUMBER
    MIN_EXTENTS NUMBER
    MAX_EXTENTS NUMBER
    PCT_INCREASE NUMBER
    FREELISTS NUMBER
    FREELIST_GROUPS NUMBER
    RELATIVE_FNO NUMBER
    BUFFER_POOL VARCHAR2(7)

    What is the equivalent system table in db2

Posting Permissions

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