User Profile

Collapse

Profile Sidebar

Collapse
pjbr34
pjbr34
Last Activity: Dec 4 '19, 04:11 PM
Joined: Feb 9 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pjbr34
    replied to Find out if index was dropped in Db2 LUW
    in DB2
    Thank you Luuk. Afaik List history command doesn't seem to provide info about deleted indexes (it does for deleted tables, but not indexes).

    And as to log records, I will drill down deeper to see what I find.
    Thanks for your help anyway.

    Best regards,
    PJBR
    See more | Go to post

      Leave a comment:

    • pjbr34
      replied to Find out if index was dropped in Db2 LUW
      in DB2
      Hi Luuk, thanks for your answer. Can you please share the link you found?
      See more | Go to post

        Leave a comment:

      • pjbr34
        started a topic Find out if index was dropped in Db2 LUW
        in DB2

        Find out if index was dropped in Db2 LUW

        Hi, when you drop a table in DB2 LUW it is at least logged in the history file so you can find out if and when was it dropped.

        But if anybody drops an index, where is it logged (if it is)? How can I keep track of dropped indexes?

        Thanks in advance,
        Raul
        See more | Go to post
        Last edited by pjbr34; Dec 19 '18, 10:57 AM. Reason: Missed thank you statement.
        • pjbr34
          started a topic Java application against Oracle to DB2 migrated Databases
          in DB2

          Java application against Oracle to DB2 migrated Databases

          Hi all,

          The problem is this: Oracle table with NUMBER datatype is migrated into DB2 as DECIMAL. No problem.

          BUT

          The Java application that processes the data using Eclipse or WebLogic is expecting an integer value and receives a decimal datatype instead. This causes the application malfunction.

          Is there a way (if any) to workaround this problem, so that the Java application receives from...
          See more | Go to post
          No activity results to display
          Show More
          Working...