User Profile

Collapse

Profile Sidebar

Collapse
deshaipet
deshaipet
Last Activity: Nov 9 '10, 08:22 PM
Joined: Feb 6 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • deshaipet
    started a topic How to call a db2 API?
    in DB2

    How to call a db2 API?

    Hi,

    Can someone help me how to call an API. For Example I would like to run
    db2CfgGet API to get the instance config params.

    Thanks in advance.

    Thanks,
    Panditt
    See more | Go to post
    • deshaipet
      started a topic How to update only first 1000 rows of a table
      in DB2

      How to update only first 1000 rows of a table

      Hi Folks,

      I would like to update only first 1000 rows of a table. Can anyone help me with the SQL ?

      Thanks,
      Panditt
      See more | Go to post
      • deshaipet
        replied to HADR monitoring with custom scripts
        in DB2
        Thanks a lot Vijay.

        Thanks,
        Panditt
        See more | Go to post

          Leave a comment:

        • deshaipet
          started a topic HADR monitoring with custom scripts
          in DB2

          HADR monitoring with custom scripts

          db2level = V97 FP 2.
          Oslevel = AIX 6.1 TL 03.
          TSAMP level = 3.1 FP 06

          Hi,

          In todays world we have TSAMP HADR monitoring scripts which monitoring scripts to monitor failures in HADR system. But we dont get email alerts when a failover occured or when a instance is down and some other cases.

          questions :

          What could be the best method to monitor these ?


          Thanks,...
          See more | Go to post
          • deshaipet
            started a topic Question with Automatic client reroute HADR
            in DB2

            Question with Automatic client reroute HADR

            Hi,

            We would like to use Automatic client reroute to route applications in
            case of primary failure in our HADR environment.

            We have both Java applications and Non-Java applications (Our ETL
            applications use IBM data server client to connect to the database).

            Questions:

            1) How can we configure ACR for Java and Non-Java applications?

            2) Should the application(Jav a...
            See more | Go to post
            • deshaipet
              replied to Server Crash - Application
              in DB2
              Thanks a lot Amar
              See more | Go to post

                Leave a comment:

              • deshaipet
                started a topic Server Crash - Application
                in DB2

                Server Crash - Application

                Hi,

                We had a situation recently. An application connected via DB2 data server client ( Application server) to the database hung for around 9 minutes and then timed out with SQL30081N. This situation occured when the database server crashed all of a sudden ( sort fo power off situation).


                Ques:

                1) Can some one explain why did the application did not get back a SQL return code immediately after the...
                See more | Go to post
                • deshaipet
                  started a topic HADR- NEtwork failure server reboot
                  in DB2

                  HADR- NEtwork failure server reboot

                  Hi,


                  I have a question with HADR Network failure.

                  Why does a server ( primary or standby) reboot when it is isolated from network ( single network between primary and standby ) ?

                  IBM doc says to avoid split brain . Can anyone explain it in more detail ?

                  Thanks
                  Panditt
                  See more | Go to post
                  • deshaipet
                    replied to Manual bufferpool flush
                    in DB2
                    Finally found the answer in one of the IBM forums.

                    Starting in v9.5 FP2, you can use this command to flush BPs:
                    db2pdcfg -db <dbname> -flushbp

                    Earlier versions, you need to deactivate and activate the database to flush BPs.

                    Regards,
                    Wiliam

                    Thanks
                    Panditt
                    See more | Go to post

                      Leave a comment:

                    • deshaipet
                      started a topic Manual bufferpool flush
                      in DB2

                      Manual bufferpool flush

                      Hi -

                      Is there any way that I can manually flush the bufferpools ?


                      Thanks in advance
                      Panditt
                      See more | Go to post
                      • deshaipet
                        started a topic Migrate DB2 database from Solaris to Red Hat Linux
                        in DB2

                        Migrate DB2 database from Solaris to Red Hat Linux

                        Hi Friends,

                        How can me migrate DB2 database from Solaris to Linux ? Please provide some detailed steps or links in this regard,

                        Thanks in advance
                        Panditt
                        See more | Go to post
                        • deshaipet
                          started a topic Questions with Archival logging for HADR Setup
                          in DB2

                          Questions with Archival logging for HADR Setup

                          As only primary database does archival logging -

                          1) How should I setup archival logging(LOGARCH METH1 and LOGARCHMETH2 for Primary and Standby databases in HADR setup ?

                          2) Should I only use one NFS mount(separate NFS mounts for LOGARCHAMETH1&2 ) for archival logging which is created on Primary database server and mounted onto standby database server ?

                          3) Please suggest me any other better options...
                          See more | Go to post
                          • deshaipet
                            started a topic Few Questions with HADR - 1
                            in DB2

                            Few Questions with HADR - 1

                            Hi -

                            We have primary and standby databases on different servers.

                            Here is my /etc/service entry for HADR pair :

                            On Primary :

                            "vi /etc/services

                            db2inst4c 3706/tcp # DB2 UDB INSTANCE
                            db2inst4h 51000/tcp # DB2 UDB HADR inst4"

                            On Standby :

                            "vi /etc/services

                            db2inst4c 3706/tcp #...
                            See more | Go to post
                            • deshaipet
                              started a topic DB2 V9.5 Tablespace -pages missing and Total pg's not equal to useable pg's
                              in DB2

                              DB2 V9.5 Tablespace -pages missing and Total pg's not equal to useable pg's

                              Hi friends -

                              I created a automatic storage tablespace with a pagesize of 16 K and initial size of 64 MB.

                              create large tablespace test_tbsp1 pagesize 16k managed by automatic storage autoresize yes initialsize 64 M increasesize 64 M maxsize 2 G no extent size 16 prefetchsize 16 bufferpool test_bp1 file system caching dropped table recovery on

                              so, the number of pages should be (initialsize/pagesize)= (64...
                              See more | Go to post
                              • deshaipet
                                replied to How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
                                in DB2
                                Thanks a lot Shashank

                                You answer is really helpful to me..



                                Thanks
                                Pandith
                                See more | Go to post

                                  Leave a comment:

                                • deshaipet
                                  started a topic How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
                                  in DB2

                                  How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)

                                  Hi Friends,

                                  Is it possible to convert SMS tablespace to a DMS tablespace with Automatic Storage ? Please, let me know the chances.

                                  Thanks
                                  Pandith
                                  See more | Go to post
                                  No activity results to display
                                  Show More
                                  Working...