Each row in the SYSFILE system view describes a dbspace for a database. Every database consists of one or more dbspaces; each dbspace corresponds to an operating system file.
SQL Anywhere automatically creates dbspaces for the main database file, temporary file, transaction log file, and transaction log mirror file. Information about the transaction log, and transaction log mirror dbspaces does not appear in the SYSFILE system view. See Pre-defined dbspaces.
ALTER VIEW "SYS"."SYSFILE" as select b.dbfile_id as file_id, if b.dbspace_id = 0 and b.dbfile_id = 0 then db_property('File') else if b.dbspace_id = 15 and b.dbfile_id = 15 then db_property('TempFileName') else b.file_name endif endif as file_name, a.dbspace_name, a.store_type, b.lob_map, b.dbspace_id from SYS.ISYSDBSPACE as a join SYS.ISYSDBFILE as b on(a.dbspace_id = b.dbspace_id); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |