Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's ReferenceThe HCL OneDB™ Administrator's Reference includes comprehensive descriptions of HCL OneDB™ configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.
Configuring and monitoring HCL OneDB™
Disk Structures and Storage
Dbspace Structure and Storage
Structure and Storage of a Dbspace Page
Rows in Nonfragmented Tables
Definition of Rowid

Definition of Rowid

HCL OneDB™ uses two different types of rowids to identify data in tables:

Serial rowid
These rowids are fields in a table and are assigned to tables created with the WITH ROWID option.
Internal rowid
The database server identifies each data row in a table with a unique internal rowid. This rowid identifies the location of the row within the dbspace.

To obtain the internal rowids for a table, use the oncheck -pD option. For more information, see oncheck -cd and oncheck -cD commands: Check pages.

In a nonfragmented table, the term rowid refers to a unique 4-byte integer that defines the physical location of the row in the table. The page that contains the first byte of the data row is the page that is specified by the rowid. This page is called the data row home page.

Fragmented tables can also have rowids, but they are implemented in a different way. For more information on this topic, see Rows in Fragmented Tables.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.