sp_iqfile 过程

显示有关 dbspace 中每个 dbfile 的详细信息。

语法

sp_iqfile [  ]

适用于

SAP IQ 服务器和 Multiplex。

特权

您必须具有系统过程的 EXECUTE 特权。您还必须具有 MANAGE ANY DBSPACE 系统特权。

注释

sp_iqfile 显示 dbspace 中每个 dbfile 中的数据的用法、属性和类型。可以使用这些信息确定是否必须移动数据，以及对于已移动的数据是否已释放旧版本。

sp_iqfile 过程返回：

列名说明DBSpaceName在 CREATE DBSPACE 语句中指定的 dbspace 的名称。Dbspace 始终不区分大小写，不受 CREATE DATABASE...CASE IGNORE 或 CASE RESPECT 规范的限制。 DBFileName逻辑文件名。Path物理文件或原始分区的位置。SegmentTypedbspace 的类型： MAINTEMPORARYRLVCACHERWModedbspace 的模式：始终为读写 (RW)。OnlineT – 联机；文件的关联 dbspace 的联机值和 SYS.ISYSIQDBFILE 中文件的联机值都为真。F – 脱机。Usage此文件当前使用的 dbspace 占整个 dbspace 的百分比。在 Multiplex 配置中针对辅助节点运行时，此列将显示 NA。DBFileSize文件或原始分区的当前大小。对于原始分区来说，此大小值可以小于实际大小。Reservedbspace 中可添加到此文件的保留空间。StripeSize如果磁盘条带化已开启，则始终为 1。BlkTypes用户数据和内部系统结构占用的空间。FirstBlk分配给文件的第一个 IQ 块号。LastBlk分配给文件的最后一个 IQ 块号。OkToDrop创建 DAS dbfile 的服务器。MirrorLogicalFileName主 DAS dbfile 的逻辑文件名。IsDASSharedFile"T" – DAS dbfile 是共享文件系统文件"F" – 不是共享文件系统文件  标识符和块类型为：

• A – 活动版本

• B – 备份结构

• C – 检查点日志

• D – 数据库标识

• F – 空闲列表

• G – 全局空闲列表管理器

• H – 空闲列表标头块

• I – 索引建议存储

• M – Multiplex CM。Multiplex 提交标识块（实际 128 块）存在于所有 SAP IQ 数据库中，与 SAP IQ 数据库是否使用无关。

• N – 使用列

• O – 旧版本

• R – RLV 空闲列表管理器

• T – 使用表

• U – 使用索引

• X – 在检查点处删除

  示例

  显示有关 dbspace 中文件的信息：

  sp_iqfile;

  📋✓

  sp_iqfile;
  DBSpaceName,DBFileName,Path,SegmentType,RWMode,Online,
  Usage,DBFileSize,Reserve,StripeSize,BlkTypes,FirstBlk,
  LastBlk,OkToDrop,servername,mirrorLogicalFileName,IsDASSharedFile
  
  'IQ_SYSTEM_MAIN','IQ_SYSTEM_MAIN',
  '../mpx_configdb.iq','MAIN','RW','T','24','700M','0B','1K',
  '1H,17888F,32D,2498A,151O,198X,128M,32C',1,89600,'N',,'(NULL)','F'   
  'dbsp1','dbsp1','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb1','MAIN','RW','T','1','50M','0B','1K','1H',
    1045440,1051839,'N',,'(NULL)','F'   
  'dbsp2','dbsp2','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb2','MAIN','RW','T','1','50M','0B','1K','1H',
    2090880,2097279,'N',,'(NULL)','F'   
  'dbsp3','dbsp3','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb3','MAIN','RW','T','1','50M','0B','1K','1H',
    3136320,3142719,'N',,'(NULL)','F'   
  'dbsp4','dbsp4','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb4','MAIN','RW','T','1','50M','0B','1K','1H',
    4181760,4188159,'N',,'(NULL)','F'   
  'dbsp5','dbsp5','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb5','MAIN','RW','T','1','50M','0B','1K','1H',
    5227200,5233599,'N',,'(NULL)','F'   
  'dbsp6','dbsp6','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb6','MAIN','RW','T','1','50M','0B','1K','1H',
    6272640,6279039,'N',,'(NULL)','F'   
  'dbsp7','dbsp71','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb71','MAIN','RW','T','1','200M','0B','1K','1H',
    7318080,7343679,'Y',,'(NULL)','F'   
  'dbsp7','dbsp72','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb72','MAIN','RW','T','1','200M','0B','1K','1H',
    8363520,8389119,'Y',,'(NULL)','F'   
  'dbsp7','dbsp73','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb73','MAIN','RW','T','1','200M','0B','1K','1H',
    9408960,9434559,'Y',,'(NULL)','F'   
  'dbsp8','dbsp81','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb81','MAIN','RW','T','1','20M','0B','1K','1H',
    10454400,10456959,'Y',,'(NULL)','F'   
  'dbsp8','dbsp82','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb82','MAIN','RW','T','1','20M','0B','1K','1H'
    ,11499840,11502399,'Y',,'(NULL)','F'   
  'dbsp8','dbsp83','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    mpx_configdb.iqdb83','MAIN','RW','T','1','20M','0B','1K','1H',
    12545280,12547839,'Y',,'(NULL)','F'   
  'das62H2','dasP62H2','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    das62H2_1.iq','MAIN','RW','T','1','10M','0B','1K','1H',
    13590720,13591999,'Y',
    'user4_1927_nw45780','(NULL)','F'   
  'das62H2','dasM62H2','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    das62H2_3.iq','MAIN','RW','T','1','10M','0B','1K','1H',14636160,14637439,'Y',
    'user4_1927_nw55880','dasP62H2','F'   
  'das62H2','dasM62H2_11','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    das62H2_33.iq','MAIN','RW','T','1','10M','0B','1K','1H',15681600,15682879,'Y',
    'user4_1927_nw45780','dasP62H2','F'   
  'das62H2','dasM62H2_22','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    das62H2_44.iq','MAIN','RW','T','1','10M','0B','1K','1H',16727040,16728319,'Y',
    'user4_1927_nw45780','dasP62H2','F'   
  'das62H2','dasP62H_55','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    das62H_55.iq','MAIN','RW','T','1','50M','0B','1K','1H',17772480,17778879,'Y',
    'user4_1927_nw55880','(NULL)','F'   
  'das62H2','dasM62H_55','/lint12dev7/users/user4/machine.lint12dev_local/mpxstore/
    das62M_55.iq','MAIN','RW','T','1','50M','0B','1K','1H',18817920,18824319,'Y',
    'user4_1927_nw45780','dasP62H_55','F'   
  'sfs_dbs','f1','/shared_disk1/users/user4/dasfmpx/nw35095/
    f1.iq','MAIN','RW','T','1','7.81M','0B','1K','1H',2090880,2091879,'Y',
    'nw35095_dbsrv7915','(NULL)','T'
  'sfs_dbs','f1_m','/local_disk1/users/user4/dasfmpx/nw411359/
    f1_m.iq','MAIN','RW','T','1','7.81M','0B','1K','1H',2090880,2091879,'Y',
    'nw411359_dbsrv7915','f1','F'
  'sfs_dbs','f2','/shared_disk2/users/user4/dasfmpx/nw35095/
    f2.iq','MAIN','RW','T','1','7.81M','0B','1K','1H',3136320,3137319,'Y',
    'nw35095_dbsrv7915','(NULL)','T'
  'sfs_dbs','f2_m','/local_disk2/users/user4/dasfmpx/nw411359/
    f2_m.iq','MAIN','RW','T','1','7.81M','0B','1K','1H',3136320,3137319,'Y',
    'nw411359_dbsrv7915','f2','F'
  'IQ_SYSTEM_TEMP','IQ_SYSTEM_TEMP','nc110203mpx_configdb.iqtmp','TEMPORARY',
    'RW','T','1','300M','0B','1K','1H,64F,48A',1,38400,'N',
    'tbucken_1927_nc110203','(NULL)','F'

  📋✓