User Profile

Collapse

Profile Sidebar

Collapse
ganeshmn25
ganeshmn25
Last Activity: Dec 23 '09, 08:46 AM
Joined: Aug 12 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ganeshmn25
    replied to DB2 Career
    in DB2
    Db2 Carrer

    Hi suganyasebastia n,

    I am vice versa to you , i have started working in IBM DB2 and now started my carrer as Oracle DBA , ]

    I would like to know How to take backup in oracle 10g


    Regards
    Padmanaban
    DB2 Associate
    See more | Go to post

      Leave a comment:

    • ganeshmn25
      replied to oracle 10g installation
      in Oracle
      Its Due to Processor

      Hi ,

      Its due to processor variation
      eg: instead of 32 bit u may install 64 bit
      See more | Go to post

        Leave a comment:

      • ganeshmn25
        replied to Can I select from a dual table ?
        in Oracle
        You can Create dual table and select it

        Hi,

        You can create DUAL table by your own and select sysdate from dual table , but atleast we need to insert 1 value in that dual table.




        Regards
        Padmanabhan.N
        DB2 Associate
        See more | Go to post

          Leave a comment:

        • ganeshmn25
          replied to How to recovery a dropped table?
          in DB2
          Recover Dropped Tables in DB2
          See more | Go to post

            Leave a comment:

          • ganeshmn25
            replied to Beginner help needed - error connecting DB2-9.1 with RAD7.0
            in DB2
            Hi ,

            Make sure that you had selected two licence file


            "D:\program files\ibm\sqlli b\java\db2jcc.j ar"

            "D:\program files\ibm\sqlli b\java\db2jcc_l icense_cu"


            Regards
            Padmanaban
            DB2 Associate
            See more | Go to post

              Leave a comment:

            • ganeshmn25
              replied to Can I alter (increase) a column size with the data type as blob
              in DB2
              Hi ,

              The size of the BLOB and CLOB data type cannot be increased

              Regards
              Padmanaban.N
              DB2 Associate
              See more | Go to post

                Leave a comment:

              • ganeshmn25
                replied to Clob
                in DB2
                Hi all ,

                The size of the CLOB and BLOB data type cannot be increased

                Regards
                Padmanaban.N
                DB2 Associate
                See more | Go to post

                  Leave a comment:

                • ganeshmn25
                  replied to read only database
                  in DB2
                  Hi,

                  Database can be made read-only by setting our

                  Tablespace USERSPACE state from NORMAL mode to SHARE mode


                  Regards
                  Padmanaban.N
                  DB2 Associate
                  See more | Go to post

                    Leave a comment:

                  • ganeshmn25
                    replied to What is DB2 agent ???
                    in DB2
                    Ya i got it ...Thanks a lot !!!!!!!!!!!
                    See more | Go to post

                      Leave a comment:

                    • ganeshmn25
                      started a topic DB2 Response File Installation
                      in DB2

                      DB2 Response File Installation

                      Hi Folks,

                      I have installed DB2 ESE 8.2 in my local system and created a response file called PROD_ESE ,

                      Now i need to install the response file in another system so that i can have the same configuration as my local system had,

                      1)Wheather i need to install DB2 ESE 8.2 in that system also ?

                      2)How to install this response file ?

                      Regards
                      Padmanaban.N
                      See more | Go to post
                      • ganeshmn25
                        replied to DB2 Select
                        in DB2
                        Hi ,

                        To count the number of duplicate values of a particular column in a table
                        you can make use of the following query,

                        SELECT email,
                        COUNT(email) AS NumOccurrences
                        FROM users
                        GROUP BY email
                        HAVING ( COUNT(email) > 1 )



                        Regards
                        Padmanaban.N
                        DB2 Associate
                        See more | Go to post

                          Leave a comment:

                        • ganeshmn25
                          started a topic What is DB2 agent ???
                          in DB2

                          What is DB2 agent ???

                          Hi folks,

                          Can any one tell me what is DB2 agent ????

                          Regards
                          Padmanaban.N
                          See more | Go to post
                          • ganeshmn25
                            replied to Offline backup logs
                            in DB2
                            Hi Anjali,

                            By default Offline backup excludes logs,


                            Regards
                            Padmanaban.N
                            DB2 Associate
                            See more | Go to post

                              Leave a comment:

                            • ganeshmn25
                              replied to DB2 Migrate to Oracle
                              in DB2
                              Hi spider007 ,

                              First of all Thank you for your quick reply

                              As we have Desigined a product using DB2 we are in need to move to oracle in future , so i need to know the steps for migration priorly


                              Regards
                              Padmanaban.N
                              DB2 Associate
                              See more | Go to post

                                Leave a comment:

                              • ganeshmn25
                                replied to issue for label on table
                                in DB2
                                Hi dude ,

                                I think creating Label for the Tabel is not possible in Windows but it is possible in z/os , anyway I am no sure about it !!!!!


                                Regards

                                Padmanaban.N
                                DB2 Associate
                                Vision Tech Solution
                                Trichy, India
                                See more | Go to post

                                  Leave a comment:

                                • ganeshmn25
                                  replied to DB2 Run time client
                                  in DB2
                                  Hi ,

                                  No need of installing DB2 administration client if you want to install DB2 run time client .while installing itself you can give custom instead of Typical and choose the Command Line Processor and Command Widows for Run time Client,

                                  In release after version 9.1 and all while installing Db2 itself option will be there.


                                  Regards

                                  Padmanaban.N
                                  DB2 Associate
                                  Vision...
                                  See more | Go to post

                                    Leave a comment:

                                  • ganeshmn25
                                    started a topic DB2 Migrate to Oracle
                                    in DB2

                                    DB2 Migrate to Oracle

                                    Hi folks ,

                                    I am in need to migrate DB2 V 8.2 Database to Oracle 10g Database ,
                                    Can any one tell me what are all the steps i need to follow for my migration,


                                    Regards

                                    Padmanaban.N
                                    DB2 Associate
                                    Vision Tech Solutions
                                    Trichy - 620011 , India.
                                    See more | Go to post
                                    • ganeshmn25
                                      replied to SQL30081N error while connecting to a DB2 ver. 7.2 Database
                                      in DB2
                                      HI ,


                                      I had similar problems under OS/2 some years ago...

                                      Try "db2stop force" and "db2admin stop

                                      Then db2admin start and db2start

                                      and also make sure by giving command db2set

                                      Directory entry type = LOCAL
                                      Protocol = TCPIP
                                      Hostname = $myIP
                                      Service name = 50000



                                      Regards

                                      Padmanaban.N...
                                      See more | Go to post

                                        Leave a comment:

                                      • ganeshmn25
                                        replied to Max Lehgth Of A Row In Db2
                                        in DB2
                                        Hi ,

                                        The maximum length of a row in db2 is 4,056 bytes
                                        and maximum number of rows per page for user table is 255




                                        Regards

                                        Padmanaban.N
                                        DB2 Associate
                                        See more | Go to post

                                          Leave a comment:

                                        • ganeshmn25
                                          replied to Db2
                                          in DB2
                                          Hi dude,

                                          The Task Center is a tool available in DB2 UDB V 8 for scheduling task to be done automatically at given time,

                                          Priorly in DB2 UDB V 7 it was called Script Center

                                          To run the Task Center we need ToolsDB Database which contains Tables that contains informations for scheduling and

                                          The tools database contains information about the administrative tasks that you configure...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...