User Profile

Collapse

Profile Sidebar

Collapse
sushanth bobby
sushanth bobby
Last Activity: May 18 '10, 09:04 PM
Joined: Oct 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sushanth bobby
    replied to db2 database pages
    in DB2
    Hi,

    Several Rows of Several Tables can be in a page. There is something called SIMPLE TABLESPACE

    Sushanth
    See more | Go to post

      Leave a comment:

    • sushanth bobby
      replied to Dynamic From Clause To Create View
      in DB2
      Ivester,



      I have tried something like this, result was a flop.
      It might work in a higher DB2 version like DB2 V9. So far i did'nt get a chance to use V9.

      Since you have hundereds of tables created & the tables can be got from DB2 catalog.

      Code:
      select 'select ??? from ',strip(tabname), 'union all'
from syscat.tables 
where tbname = ?? and create_time between current_timestamp
      ...
      See more | Go to post

        Leave a comment:

      • sushanth bobby
        replied to DB2 instances in SDLC
        in DB2
        Tekedge,

        It depends upon the project requests, i guess. If each PR accesses different(datab ases or tables), then each release will be independent of other.

        Sushanth
        See more | Go to post

          Leave a comment:

        • sushanth bobby
          replied to Diff in DB2 versions
          in DB2
          Hi,

          These are the Major Points, i think
          Compatibility Mode - Members of the compatibility mode can co-exist with the previous version. New Version Functions are not available. Can fallback to previous version.

          New-Function Mode - Members cannot co-exist with previous version. New version functions are available & Cannot Fallback to previous version.

          Sushanth
          See more | Go to post

            Leave a comment:

          • sushanth bobby
            started a topic What happens after new function mode
            in DB2

            What happens after new function mode

            Hi,

            In the process of migration of DB2 from one version to another. We have
            Compatibility Mode, Compatibility Mode*
            Enable New-Function Mode, Enable New-Function Mode*
            New Function Mode.

            I want to know, is there any modes after NEW FUNCTION MODE. Like "Normal Mode", where the migration is completely over with no-probs(FINALISED ). I know NEW FUNCTION MODE is the final mode of migration....
            See more | Go to post
            • sushanth bobby
              replied to Empty Table
              in DB2
              There is something called ROTATING PARTITIONS which will delete the data automatically.
              See more | Go to post

                Leave a comment:

              No activity results to display
              Show More
              Working...