如果您在创建数据库时使用默认值,则会创建下列系统管理的表空间。
If you use the defaults when creating a database, the following system-managed tablespaces are created.
所有DB 2表空间都可以使用这个选项,包括系统表空间和临时表空间,以及数据库管理的表空间。
This option is available for all DB2 tablespaces, including system and temporary tablespaces and database managed tablespaces.
对于数据库管理的表空间,建议拆开lob数据中的常规数据,将LOB数据放在一个很大的表空间中。
It is recommended for database managed tablespaces to split regular data from LOB data, placing LOB data in a large tablespace.
基本上,DB 2处理与表空间关联的所有存储管理任务——完全联机并且不需要人工干预。
Basically, DB2 handles all of the storage management tasks associated with the table space - completely online and without the need for manual intervention.
并根据这些例程来返回关于容器、数据库、数据库管理器或表空间的信息。
Depending on the routine, information is returned about containers, a database, the database manager, or table Spaces.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
使用多个用户表空间的最重要原因是管理缓冲区的利用率。
The most important reason to use more than one user table space is to manage buffer utilization.
为了构建这个日志框架,需要数据库管理员帮我们设置存储过程的日志目录并创建一个用户临时表空间。
In order for you to set up the logging framework, you will need help from your database administrator to set up the stored procedure logging directory and a user temporary table space.
除了增加数据库容量外,对大型RID的支持还简化了表空间的管理(通过合并),并可以提高存储和内存的利用率。
In addition to increasing database capacity, large RID support can also simplify table space management (through consolidation) and improve storage and memory utilization.
在DB 2中,可以有两种不同的方式管理表空间:,table spaces are managedin two different ways。
这种类型的表空间可以提供最佳性能,但是需要进行一些管理。
This type of table space allows for best performance, but some administration is required.
具体地说,管理员必须定义适当的数据库对象,比如分区组、表空间、缓冲区池等等。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
当向定义为数据库管理空间(DMS)的表空间添加新的容器时,或者当扩展现有的容器时,就可能发生表空间数据的重新调整。
When new containers are added to a table space that is defined as database managed space (DMS), or existing containers are extended, a rebalancing of the table space data might occur.
更少的缓冲池和表空间,以及更少的页宽种类,可以导致更简单的物理数据库设计,从而更容易管理、维护和调优。
Fewer buffer pools and table Spaces and fewer distinct page sizes lead to a simpler physical database design which is easier to manage, maintain, and tune.
这个表空间是最适合数据库管理器需求的一种特殊用途文件系统的一个实现。
This table space is an implementation of a special-purpose file system designed to best meet the needs of the database manager.
它具有一个集成的内存管理单元,通常使用与PPE类似的页表查询机制来提供对某个进程地址空间的访问。
It has an integrated memory management unit that is normally used to provide access to the address space of one process by using the same page table lookup as the PPE.
每当数据库的模式发生更改,或者进行像添加或删除数据文件、添加或删除表空间这样的更改时,建议管理员执行脱机备份。
Administrators are advised to do an offline backup whenever the schema of the database changes, or changes are made such as adding or removing data files, and adding or removing of table Spaces.
数据库管理的空间(DMS): dms表空间是由DB 2管理的。
Database managed space (DMS) : DMS table Spaces are managed by DB2.
管理员可以选择表空间的类型和组成表空间的容器的类型。
The administrator can choose the type of a table space as well as the containers that make up the table space.
因为DB 2自动地管理表空间的容器和空间分配,所以可能不需要让PerformanceExpert收集这些方面的计数器。
Because DB2 automatically manages your containers and space allocation for your tablespace, you might not want Performance Expert to collect these counters.
页面大小为32kb的数据库管理的(DMS)表空间。
Database managed (DMS) table Spaces with a page size of 32kb.
为了保证管理效率,推荐为前面所确定的每一个表提供单独的表空间。
Individual tablespaces are recommended for each table identified previously, for management efficiencies. The following tablespace identifiers are required.
下列示例利用系统管理的目录表空间以及数据库管理的临时表空间和用户表空间创建了名为tested的数据库。
The following example creates the database named tested with a system-managed catalog tablespace and database-managed temporary and user tablespaces.
这是很容易在中更改表的名称如果你有管理员访问数据库你采购为什么不更换表中的名称空间强调。
It is easy to change table names in FileMaker if you have admin access to the database you are sourcing why not just replace the Spaces in the table names with underscores.
在此四元组模型的基础上,应用面向对象设计的思想,结合跳跃表、动态空间管理、编译预处理等技术方法,构造出一个单片机软件仿真器类群。
With the theory of object-oriented design, jump table, dynamic memory management and code pre-processing, the class group of software simulators for single-chip microcomputers are designed.
它将如何影响表空间中的空间管理?
它将如何影响表空间中的空间管理?
应用推荐