Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
I had set up with inav, some database files inside of a schema (library). Worked fine on v6r1 machine. Over weekend, migrated to new v7r1 machine, and due to incompatiable tape, etc. I ftped the save file of the "savlib" of the library/schema across.
While the file was fine, it no longer showed up in inav as a schema. So what I had to do was as follows. I deleted the library off, I ran inav and built the schema, then I did a clrlib of the schema, then I did a RSTLIB and all was fine.
Is this the "normal" thing you have to do? Odd thing was a couple of other libraries (purchased program related) showed up automatically as schemas, but all those that I did, didn't until I did this.
Did the saved library/schema have a data dictionary? Pretty sure you can't restore a data dictionary object. You could create or restore the library/schema, then restore everything else (which is more or less what you did). Possibly the 3rd party libs had the other schema items (views, ...), just not the data dictionary objects.
