Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    21

    Unanswered: Informix Command

    Hi,
    May I know how to determine which table and database bellong to which dbspace/dbslice?

    Regards,
    Informix User

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,


    -- Find the database to dbspace mapping

    database sysmaster;
    select sysdatabases.name, sysdatabases.owner, sysdbspaces.name
    from sysdbspaces,sysdatabases
    Where partdbsnum(sysdatabases.partnum) = sysdbspaces.dbsnum

    database sysmaster;
    select tabname, trunc(systabnames.partnum/1048576) dbspace,
    sysdbspaces.name
    from systabnames,sysdbspaces
    Where sysdbspaces.dbsnum = trunc(systabnames.partnum/1048576)
    and systabnames.owner="OWNER" -- owner of the database

    Regards,

    lloyd

Posting Permissions

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