PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 4/2/2019 3:04 PM by  JimY
DBREORG failed: file already exists
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
maalimsimo
Private
Private
Veteran Member
(114 points)
Veteran Member
Posts:48


Send Message:

--
4/2/2019 12:52 PM
     

    We created a new custom table thru dbdef, followed by a blddbdict, but before the dbreorg was executed we  'CREATE'd the same table in Oracle and loaded some records. Now we know we should have waited for the dbreorg. When we attempted to run the dbreorg later, we got the error message "File already exists". We have since 'DROP'ped the file in Oracle, but a subsequent dbreorg says "Cannot open lock file /law1/lsf/law/test/dictlock". How do we get around this 'lock'?

     

    My search on this forum has not yielded any relevant articles so far. Any ideas would be appreciated.

    JimY
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    4/2/2019 3:04 PM

    I found this KB article : 1200393 that gives a solution.

    You are not authorized to post a reply.