dbspace for database
Posted in 1993
Yes I know I have antique software, and yes I am sure you've answered this before...but I need to know now, and cannot find it in Walt's excellent archives... On a UNisys 5000 platform, running Turbo with 2.10.03G SQL... 2 databases were created. tbmonitor shows rootdbs, and 2 other dbspaces. I believe, probably, the creator of these databases put one database in each of the 2 other dbspaces, each of which have only 1 chunk, each chunk on separate physical disk. How can I determine where each database was created and lives? ie: did the creator use the "in dbspace" command on the command line when it was made? Scenario is: 1 disk goes down and has to be replaced/reformatted. Only one of the non-root dbspaces in my Turbo world lives on that disk. Is it probable/possible (if the creator made it so) that only 1 database lives on that disk, in that single chunk/dbspace? If so, rather than using Turbo to restore (meaning I would have to restore both databases), I would rather just drop and re-create the database on the bad disk using previously exported files. Is this a possibility? Thanks for the refresher course... Ann