User Profile

Collapse

Profile Sidebar

Collapse
db2dbdba
db2dbdba
Last Activity: Jun 19 '16, 07:11 PM
Joined: Mar 18 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • db2dbdba
    started a topic Issue with STATUS_CHANGE_TIME in SYSIBMADM.APPLICATIONS
    in DB2

    Issue with STATUS_CHANGE_TIME in SYSIBMADM.APPLICATIONS

    Dear Team

    I was trying to find out the value of applications STATUS_CHANGE_T IME from SYSIBMADM.APPLI CATIONS.
    All my monitor switches were turned ON at session level using
    Code:
    db2 "update monitor switches using UOW ON"
    Though my switches are ON, I'm getting a NULL value against STATUS_CHANGE_T IME .

    The SQL I am trying to use is below.
    Code:
     db2 "select substr(A.AUTHID,1,10)
    ...
    See more | Go to post
    • db2dbdba
      replied to Help with using database partition expressions
      in DB2
      hi Forrest

      I'm looking for case where in i shall be able to use only [blank]$[number]N. This would be something like below $4N which means for a partition 5 it would be something like 0005 which is not working as specified in the link i mentioned at the beginning of my post.

      Thanks,
      See more | Go to post

        Leave a comment:

      • db2dbdba
        replied to Help with using database partition expressions
        in DB2
        Hi Forest

        I'm trying to create a tablespace in db2 database with dpf enabled.

        so my expectation is the as per the IBM link specified, it shall create the containers as per the partition numbers with a maximum of 4 digits ([blank]$[number]N)
        See more | Go to post

          Leave a comment:

        • db2dbdba
          replied to Help with using database partition expressions
          in DB2
          hi forrest

          Thank you for the reply.
          I've used the command with minor modification $N in place of $4N and it worked fine. I believe the command is right and I'm not sure of how to use the partition expression in my requirement and seeking the help here.
          See more | Go to post

            Leave a comment:

          • db2dbdba
            started a topic Help with using database partition expressions
            in DB2

            Help with using database partition expressions

            Dear DBAs

            I'm working on a DPF set up in DB2 LUW on AIX and trying to create a tablespace in 16 partition database (logical) using partition expression (http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic =%2Fcom.ibm.db2 .luw.admin.part ition.doc%2Fdoc %2Fc0059241.htm l).
            Verison is DB2 v9r7.


            Code:
            CREATE USER TEMPORARY TABLESPACE "TBSPNAME" IN DATABASE PARTITION GROUP PG1_ALL PAGESIZE 16384 MANAGED
            ...
            See more | Go to post
            • db2dbdba
              started a topic How can I find time/timestamp of instance creation on DB2 LUW?
              in DB2

              How can I find time/timestamp of instance creation on DB2 LUW?

              How can I find time/timestamp of instance creation on DB2 LUW?

              I thought I might find this info on dbm snapshot but no luck. it gives only the information on last start time of instance ?
              I looked at ~/sqllib directory's timestamp as well but afraid that the time might get modified if someone performed an db2iupdt instance update.

              Please help me with this

              Thanks in advance.

              ra
              See more | Go to post
              • db2dbdba
                started a topic db2 index reorg status monitoring
                in DB2

                db2 index reorg status monitoring

                Hi all,

                Can any one help me in understanding how to monitor the status of index REORG?

                All I know till now is do



                I don't know whether "snaptab_re org " will help me in knowing the status of index reorg.

                Regards,
                R...
                See more | Go to post
                • db2dbdba
                  started a topic DB2 Administration Server & DBA8001E & SQL22205C
                  in DB2

                  DB2 Administration Server & DBA8001E & SQL22205C

                  Hi All,

                  I am trying to connect to two different databases on different servers for Configure Automatic Maintenance through Control Center. But I am getting errors with these codes. DBA8001E & SQL22205C

                  I have tried dropping and recreating the DAS.
                  Stopped and restarted the DAS. But nothing worked out. and not able to open with Configure Automatic Maintenance Wizard.

                  for the error code DBA8001E...
                  See more | Go to post
                  • db2dbdba
                    replied to how to check for when a db2stop command is last issued
                    in DB2
                    Thanks so much for your help.
                    Unfortunately My bad luck. I am still in V8.2


                    R...
                    See more | Go to post

                      Leave a comment:

                    • db2dbdba
                      replied to Problem loading an Image
                      in PHP
                      Hi All,

                      Sorry for the delay.
                      Even I have no idea of what made it worked. I tried the suggestions with double quotes and it didn't work but when I used the single quotes, it is just working fine.

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

                        Leave a comment:

                      • db2dbdba
                        replied to EXPORT, Change the CLOB and then IMPORT
                        in DB2
                        Hi,

                        I have figured out the mistake in my process.
                        I didn't update the size of file in LLS and when I added content to the LOB.

                        But I am still wondering why I am getting this error when I change the LOB and import it.
                        Code:
                        SQL3040N  Unable to use the lobpath/lobfile parameters as specified. Reason
code: "6".
                        Please help me.

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

                          Leave a comment:

                        • db2dbdba
                          replied to Problem loading an Image
                          in PHP
                          Hi Ronald,

                          Thanks so much.
                          It worked now. I was using double quotes.

                          Thanks,...
                          See more | Go to post

                            Leave a comment:

                          • db2dbdba
                            replied to Problem loading an Image
                            in PHP
                            Hi there,

                            Thanks so much for the reply.
                            I did the same thing and then I posted it.
                            Image is not coming up but the link associated with it is working for me.
                            It is coming as if I am using an unsupported file.

                            Thanks for your time...
                            See more | Go to post

                              Leave a comment:

                            • db2dbdba
                              started a topic Problem loading an Image
                              in PHP

                              Problem loading an Image

                              Hello all,

                              I am newbie to PHP.
                              I am running PHP on Apache2 on Linux and I have some 6 pages for PHP.
                              All PHP pages are working fine in accessing DB.

                              Now the problem is, I want to keep an image(GIF or JPG or anykind of image) on the page but couldn't keep the images.
                              If have included an image file in the folder
                              Code:
                              /usr/local/apache2/htdocs/pwdall
                              pwdall contains my PHP files.

                              suggest...
                              See more | Go to post
                              • db2dbdba
                                replied to how to check for when a db2stop command is last issued
                                in DB2
                                Sorry it was my bad.
                                I tried using the db2diag.
                                I am checking whether there is any other option.

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

                                  Leave a comment:

                                • db2dbdba
                                  started a topic EXPORT, Change the CLOB and then IMPORT
                                  in DB2

                                  EXPORT, Change the CLOB and then IMPORT

                                  Hi All,

                                  I am working in DB2 and trying to export data from a table.
                                  DDL for my table is
                                  Code:
                                  CREATE TABLE "CMMETA  "."CMREF"  (
		  "SITECODE" SMALLINT , 
		  "CMPNTKEY" CHAR(32) , 
		  "CMPNTKIND" SMALLINT , 
		  "UPDT_TS" TIMESTAMP , 
		  "CMPNTVALUE" CLOB(32700) LOGGED NOT COMPACT )   
		 IN "USERSPACE1"
                                  ...
                                  See more | Go to post
                                  • db2dbdba
                                    started a topic how to check for when a db2stop command is last issued
                                    in DB2

                                    how to check for when a db2stop command is last issued

                                    Hi All,

                                    How can I check for when a db2stop command is last issued?

                                    Or when a db2 force applications all command is last issued?

                                    Thanks in advance

                                    R
                                    See more | Go to post
                                    • db2dbdba
                                      started a topic Problem with db2advis
                                      in DB2

                                      Problem with db2advis

                                      Hi all,

                                      I am getting the following problem when i run the db2advis.

                                      ]$ db2advis -d sample -i name3.sql -n db2inst1 -o db2advise.out

                                      0 solutions were evaluated by the advisor

                                      exiting with error code [-1013]

                                      If i execute the following stmt.
                                      db2advis -d prod1 -s "select * from users"
                                      I am getting the following error.

                                      Using user id as default...
                                      See more | Go to post
                                      • db2dbdba
                                        replied to Transport database to another system
                                        in DB2
                                        try db2look -db urdbaname -l -x -e -f -o filename.
                                        You can use this file to create database.
                                        But you first have to create a database with the same name in your home system....
                                        See more | Go to post

                                          Leave a comment:

                                        No activity results to display
                                        Show More
                                        Working...