Hi, all.
I have an issue where a table that I've used for 5+ years to stage my Start table data no longer allows Optim to perform any actions on it. My normal procedure is to extract data from some source and load it to this table. Now during the Load process, Optim terminates abruptly and gives the error message, "can not create file." I also tried using an Insert request instead and this gives me an error message that says my user id is not valid for a database that has nothing to do with this process.
I've tried dropping and rebuilding the table, but I get the same error messages when I run the processes. If I use the table's DDL to create a copy of the table with a different name, the processes are able to run against this new table. I don't want to move forward with the new table at this time because it would require me to create/update hundreds of relationships based on the original table name.
Thank you,
Trong
------------------------------
Trong Bo
Senior Environment Administrator
HealthNow New York
------------------------------
#InfoSphereOptim#Optim