User Profile

Collapse

Profile Sidebar

Collapse
kazam
kazam
Last Activity: Nov 17 '08, 07:38 AM
Joined: May 6 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kazam
    replied to Problems with a simple Trigger :-(
    in DB2
    Can you paste the error message here. So that it would become easy to identify the problem
    See more | Go to post

      Leave a comment:

    • kazam
      replied to Database creation failing on AIX.
      in DB2
      First try to do
      1) killdbm
      2) create the database
      3) db2start

      If this doesn't work, then check if
      DB2COMM registry variable is set to tcpip
      if the port name is set in database manager configuration file

      If they are not set, them set them and do
      db2stop force
      db2start.

      Thanks,
      Madhavi
      See more | Go to post

        Leave a comment:

      • kazam
        replied to DB2 Bulk Load via Java/JDBC
        in DB2
        See if the sample code snippet for LOAD operation in sqllib/samples/java/jdbc/SetIntegrity.ja va helps.


        Thanks,
        Madhavi.
        See more | Go to post

          Leave a comment:

        • kazam
          replied to stored procedure to drop tables
          in DB2
          Can you give us error message details when you execute this procedure?
          See more | Go to post

            Leave a comment:

          • kazam
            replied to DB2 low CPU low IO (low insert,low update) why ?
            in DB2
            I/O overhead could be because of insufficient page cleaning.

            If DB2 agent needs to write a page and if there's no free page in the bufferpool, then the agent must first create a room in the bufferpool by writing a dirty page out of the pool. This will cause the application to stop processing transactions because DB2 agent has to get a free page first and then continue. Hence I/O bottleneck.

            CPU overheads could be...
            See more | Go to post

              Leave a comment:

            • kazam
              replied to please help
              in DB2
              The information about every database object is stored in system catalog tables. System catalog tables reside in SYSCATSPACE tablespace. whenever an object is referenced in queries or any other operation, DB2 checks for that object in system catalog tables first, if exists, it checks all other details like if permissions are there, etc and executes that operation/query.
              See more | Go to post

                Leave a comment:

              • kazam
                replied to Health Monitor - Manual Backup required...why?
                in DB2
                The explanation for ADM10502W is as follows. Try recommendations and descriptions as suggested in the commands below.

                (GET RECOMMENDATIONS FOR HEALTH INDICATOR Health-Indicator-Short-Name
                GET DESCRIPTION FOR HEALTH INDICATOR Health-Indicator-Short-Name
                )

                ADM10502WHealth indicator Health-Indicator-Short-Description (Health-Indicator-Short-Name) is in state Health-Indicator-Value on Monitored-Object-Type...
                See more | Go to post

                  Leave a comment:

                • kazam
                  replied to ADD tags to existing xml through java
                  in XML
                  check if this sample helps if you have DB2. This sample shows how to update the existing XML document.

                  $HOME/sqllib/samples/xml/java/jdbc/XsUpdate.java

                  Thanks,
                  Madhavi...
                  See more | Go to post

                    Leave a comment:

                  • kazam
                    replied to readonly tablespace
                    in DB2
                    Hi,

                    We cannot make tablespaces readonly in DB2

                    Thanks,
                    Madhavi...
                    See more | Go to post

                      Leave a comment:

                    No activity results to display
                    Show More
                    Working...