Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: Temp tablespaec & Userexit

    hi

    1) Is there way to find a query using which temp tablespaces for its work in the database,

    2) USEREXIT is already set in the database, how to chk the path defined in it, list history archived log or any other way to find, coz /sqllib/adm has the binary for same.

    regds
    Paul

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Please supply you DB2 version and OS.

    1) Why do you care?
    2) Unless you have the source code for the USEREXIT, then it is unlikely you can determine from it where the logs are going. I assume this is some legacy system you inherited. You can search the disks for where they are going, but USEREXIT may not be just moving them to a different disk.

    Andy

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    1) User temp tbspace used by some query which results in file system full error,
    2) Yes ur correct its legacy system, actually was getting error in diag abt not able to archive log using USEREXIT. Do LIST HISTORY ARCHIVED LOG gives the correct info ??

    regds
    Paul

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Please post DB2 version and OS...

    Andy

  5. #5
    Join Date
    Oct 2007
    Posts
    246
    OS
    OSName: AIX
    Version: 6
    Release: 1

    Db2 : 9.1 fp 9

    regds
    paul

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the file system full errors are in diaglog and indicated also the container name for temp tablespace....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Mathew_paul View Post

    1) Is there way to find a query using which temp tablespaces for its work in the database
    http://www.dbforums.com/db2/1661299-...ablespace.html


    Quote Originally Posted by Mathew_paul View Post
    2) USEREXIT is already set in the database, how to chk the path defined in it, list history archived log or any other way to find, coz /sqllib/adm has the binary for same.
    You don't see this info in list history archive log output or db2diag.log?

    Why don't you switch to using logarchmeth1 instead of userexit.

Posting Permissions

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