Enscribe is one of the database for HP Non Stop Tandem, it is a file system database which has. High Level Access to Database. Ensures Data Integrity. Partitioned Files. Five disk file structures. Transaction auditing through TMF. Some of the features & terminology used for Ensribe file systems: File – Collection of records. Format 1 and Format 2 – It’s a static attribute and is established when the file is created. If the size of the file is less then 2GB-1MB then its format 1 file else Format 2 file. Cache buffering. Record locking and file locking. Sector – The smallest unit of disk I/O.
The NonStop SQL/MP relational database management system combines the standard features of a relational database with additional features that provide data integrity,high availability, high performance, and excellent scalability. NonStop SQL/MP is specifically designed for large data processing environments that maintain a variety of applications performing critical business tasks. RDBS Relational Data Base Management System. Used for storage and retrieval of data. Data can be treated as 2-dimensional tables “Relations”. Data can be combined from multiple tables. Complex data access can be achieved using only a single command. SQLCI NonStop SQL/MP Conversational Interface Command. SQLCI [/ [IN <in-file>] [, OUT <list-file>] , [, NOWAIT] [, <run-option>]