I've been tasked to develop a data dictionary for an IBM DB2 Mainframe Database with over 1000 tables. My questions are:
1. Can SqlSpec handle such a big DB? 2. Is anybody currently using SqlSpec for an IBM DB2 DB? 3. What are the requirements to use SqlSpec with a MF IBM DB2 DB? 4. How does one connect to the Mainframe?
I need these questions answered before I continue to evaluate SqlSpec because I will need to present it to management as a viable tool to develop the data dictionary.
Note that I do not have access to a mainframe so I have not tested any of these scenarios. I can do my best to help you if you have problems though. I have only tested SqlSpec for DB2 running on windows.