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.
I found this KB article : 1200393 that gives a solution.