rootdbs database?

Posted in 2006

Topics: Storage & Space Management, Versions, Editions & End-of-Life

SQL NET — Thu, 15 Jun 2006 03:04:22 — source: IIUG Forums & Mailing Lists

Hi! I don't understand the output. select * from sysextents dbsname rootdbs tabname TBLSpace start 1048589 size 250 dbsname sysmaster tabname sysdatabases start 1055839 size 4 .... .... <administrator's reference> explain that dbsname colnum is databasename, but my database don't have this rootdbs database. sco unixware7.13+IDS 9.30.UC4 Thanks sqlnet

↪ replying to SQL NET

ART KAGEL, BLOOMBERG/ 731 LEXIN — Thu, 15 Jun 2006 14:29:05 — source: IIUG Forums & Mailing Lists

That's an internal pseudo DB known in the documentation as the database tablespace. It's not accessible directly, but corresponds to the sysmaster pseudo table sysdatabases. Art S. Kagel ----- Original Message ----- From: Sql Net <ids@iiug.org> At: 6/14 23:08:17 Hi! I don't understand the output. select * from sysextents dbsname rootdbs tabname TBLSpace start 1048589 size 250 dbsname sysmaster tabname sysdatabases start 1055839 size 4 ..... ..... <administrator's reference> explain that dbsname colnum is databasename, but my database don't have this rootdbs database. sco unixware7.13+IDS 9.30.UC4 Thanks sqlnet ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.