User Profile

Collapse

Profile Sidebar

Collapse
kumarmdb2
kumarmdb2
Last Activity: Jan 22 '08, 03:11 PM
Joined: Dec 14 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kumarmdb2
    replied to DB2 Linux db connect issue
    in DB2
    What does the db2diag.log has to say? Can you post the corresponding error from db2diag.log

    Regards,
    Kumar...
    See more | Go to post

      Leave a comment:

    • kumarmdb2
      replied to What are the best options to Copy data from one database to a different database with
      in DB2
      You can look at db2move utility

      If only 1 or 2 table at a time you can in control center in wondows (Not sure about other platforms) you can also right click the table you want to copy and specify the new destination which can be on another database/server

      Regards,

      Kumar...
      See more | Go to post

        Leave a comment:

      • kumarmdb2
        replied to Out of private memory heap
        in DB2
        Hi Bernd,

        Thanks for reply. I tried that but it did not helped much (it just delayed the occurence of error) but I would like to thank you from bottom of my heart for helping.

        It is actually a DB2 bug which causes fragmentation of appl heap. As soon as we migrated to fix pack 4 the error stopped coming.


        Cheers!

        Kumar...
        See more | Go to post

          Leave a comment:

        • kumarmdb2
          started a topic How to track the execution of procedures in the database
          in DB2

          How to track the execution of procedures in the database

          Hi All,

          I wanted your advice on how to track the order & time execution of procedures for one particular user?
          I know that we can use event monitor on statements to get to know what all got executed but is there a way by which we can get the time of execution.
          I breezed through db2audit documentation & i think (Not sure) that we cannot audit the execution of SQL/Procedures for a particular user using db2audit....
          See more | Go to post
          • kumarmdb2
            replied to Out of private memory heap
            in DB2
            Thanks Kevin,

            I'll definately keep thin in mind for my future posts...

            Regards,

            Kumar...
            See more | Go to post

              Leave a comment:

            • kumarmdb2
              started a topic Out of private memory heap
              in DB2

              Out of private memory heap

              Hi guys,

              For last few days we are getting out of private memory error. We have a
              development environment. We tried to figure out the problem but we
              believe that it might be related to the OS (I am new to Windows so not
              sure). We are currently bouncing the instance to overcome this error. This
              generally happen at the end of business day only (So maybe memory
              might be getting used up?). We have...
              See more | Go to post
              Last edited by eWish; Dec 29 '07, 03:02 AM. Reason: Added Code Tags
              • kumarmdb2
                started a topic Error in db2diag
                in DB2

                Error in db2diag

                Hi everyone,

                I was going through my db2diag & I am getting this error:

                2007-12-20-11.57.13.869000-360 I4720897H465 LEVEL: Error
                PID : 5096 TID : 4532 PROC : db2syscs.exe
                INSTANCE: DB2 NODE : 000 DB : FACTSCN4
                APPHDL : 0-1091
                AUTHID : FACTSDB
                FUNCTION: DB2 UDB, database monitor, sqlmon_conn::cl eanup_sqlmon_co nn, probe:10...
                See more | Go to post
                • kumarmdb2
                  started a topic A security issue
                  in DB2

                  A security issue

                  Hi... We are trying to find a way by which we can capture the OS id of the user performing the updates on the. Can it be done through the database?

                  We had an issue that someone deleted one of the important data in our environment (Window 2003 server & DB2 V9 fix pak 3) but our logs only showed the id by which the DB was logged into by (We have given same id to every one as it is a development environment) and otherwise also all...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...