File management overview: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (add link)
 
(57 intermediate revisions by 6 users not shown)
Line 1: Line 1:
==Model 204 overview==
<p>Rocket <var class="product">Model&nbsp;204</var> is a database management system (DBMS) that  supports high-speed processing of complex transactions against large volumes of data by large numbers of users. </p>
<p><var class="product">Model&nbsp;204</var> applications access data from other data servers, running on disparate hardware and database platforms.</p>
<p><var class="product">Model&nbsp;204</var> builds index entries to optimize the retrieval of information. <var class="product">Model&nbsp;204</var> uses optimized indexing techniques for fast information retrieval: bit-mapping, hashing, B-tree, and record lists.</p>
==File management tasks==
==File management tasks==
<p>You might want to designate one or more persons at your site to be responsible for all tasks related to file management. File management tasks include creating, maintaining, and administering <var class="product">Model&nbsp;204</var> database files, and organizing the files for maximum efficiency in data retrieval.</p>
<p>
<p>The user performing file management tasks, acting as the "file manager," must be proficient at relational database tasks such as data allocation, storage, and retrieval, and transaction backout.</p>
You might want to designate one or more persons at your site to be responsible for all tasks related to file management.</p>  
<p>File manager privileges are established at the file level: privileges for each file are defined on the password used to open the file or the PRIVDEF (default) file privileges when no password is supplied on the file open.</p>
<p>
<p>The file manager works closely with the system manager. System manager duties include starting, stopping, and monitoring the <var class="product">Model&nbsp;204</var> system, and setting user priorities and security.</p>
File management tasks include:  
===Additional documentation===
<ul>
<ul>
<li><var>Rocket Model&nbsp;204 System Manager's Guide</var>. Many file management tasks require an understanding of system management tasks. If a file management task description refers to system manager permissions or tasks, see the system manager's guide for more information.</li>
<li>Creating, maintaining, and administering <var class="product">Model&nbsp;204</var> database files
<li><var>Rocket Model&nbsp;204 Parameter and Command Reference Guide</var>. This guide provides a quick way to look up the syntax of commands for file and system management.</li>
 
</ul>
<li>Organizing Model 204 database files for maximum efficiency in data retrieval</li>
</ul></p>
<p>
The users performing file management tasks (thus acting in the role of "file manager") must be proficient in:
<ul>
<li>Data allocation, storage, and retrieval, and transaction backout (as required for all database management systems)</li>
 
<li>Tasks unique to Model 204 (as described in the file management topics)</li>
</ul></p>
 
<p>
A good file manager should understand application design and [[:Category:SOUL|SOUL]] coding techniques to assist the application developers in their tasks.</p>
<p>
The file manager works closely with the system manager. System manager duties include starting, stopping, and monitoring the <var class="product">Model&nbsp;204</var> system and setting user priorities and security.</p>
 
===File manager privileges===
<p>
File manager privileges are established at the file level: privileges for each file are defined on the password used to open the file or the <var>[[PRIVDEF parameter|PRIVDEF]]</var> (default) file privileges when no password is supplied on the file open.</p>


==Dictionary/204 File Management Subsystem facility==
==Dictionary/204 File Management Subsystem facility==
<p>If you use the <var class="product">Model&nbsp;204</var> data administration product, Dictionary/204, you have access to the File Management Subsystem facility (FILEMGMT). You can choose to create and maintain <var class="product">Model&nbsp;204</var> files using FILEMGMT instead of entering commands in a file or on the command line.</p>
<p>
<p>FILEMGMT is a full-screen interface that prompts you for the specific file definition information it needs to automatically construct the <var class="product">Model&nbsp;204</var> commands that create and define the file. FILEMGMT provides automatic file sizing and other time-saving features.</p>
If you use the <var class="product">Model&nbsp;204</var> data administration product, Dictionary/204, you have access to the File Management Subsystem facility ([[FILEMGMT overview|FILEMGMT]]). You can choose to create and maintain <var class="product">Model&nbsp;204</var> files using FILEMGMT instead of entering commands in a file or on the command line.</p>
<p>FILEMGMT also stores the entries in your site's Dictionary for the files, fields, records, and field groups that you create. For more information on the Dictionary, refer to the <var>Rocket Model&nbsp;204 Dictionary/204 and Data Administration Guide</var>.</p>
<p>
<p>In addition to creating new files and providing automatic file sizing, FILEMGMT can be used to add fields or records to existing files, to change file parameters or file size, and to view or copy file information. FILEMGMT tasks are described throughout this manual.</p>
FILEMGMT is a full-screen interface that prompts you for the specific file definition information it needs to automatically construct the <var class="product">Model&nbsp;204</var> commands that create and define the file. FILEMGMT provides automatic file sizing and other time-saving features.</p>
<p>
FILEMGMT also stores the entries in your site's Dictionary for the files, fields, records, and field groups that you create. For more information on the Dictionary, refer to [[Dictionary/204 overview]].</p>
<p>
In addition to creating new files and providing automatic file sizing, you can use FILEMGMT to add fields or records to existing files, to change file parameters or file size, and to view or copy file information. FILEMGMT tasks are described throughout the file management topics.</p>
<p>
Even if you intend on using the FILEMGMT APSY, you should have a solid knowledge of the rules and techniques involved in the creation and maintenance of <var class="product">Model&nbsp;204</var> files.</p>
 
==Getting started==
==Getting started==
<p>You can perform most file management tasks in two ways:</p>
<p>
You can perform most file management tasks in two ways:</p>
<ul>
<ul>
<li>Manually, by entering commands into a file or on the command line</li>
<li>Manually creating procedures containing commands or directly on the command line</li>
 
<li>Using the File Management Subsystem Facility (FILEMGMT)</li>
<li>Using the File Management Subsystem Facility (FILEMGMT)</li>
</ul>
</ul>
<p>This guide describes both ways of performing the tasks.</p>
 
<p>The following tables describe where to find information about file creation and file management tasks. </p>
<p>
<p>Where applicable, the Order column indicates the order in which you should perform the tasks. </p>
There are [[:Category:Model 204 files|file management topics]] to describe each way of performing a task.</p>
<p>
The following tables describe where to find information about file creation and file management tasks. Where applicable, the Order column indicates the order in which you should perform the tasks. </p>
<table>
<table>
<caption>File creation tasks</caption>
<caption>File creation tasks</caption>
Line 35: Line 58:
<th>For information, see ...</th>
<th>For information, see ...</th>
</tr>
</tr>
<tr>
<tr>
<td align="right">1</td>
<td>1</td>
<td>Understanding file manager and <var class="product">Model&nbsp;204</var> file concepts</td>
<td>Understanding <var class="product">Model&nbsp;204</var> file architecture and file managment</td>
<td>
<td nowrap>[[File architecture overview]] <br>
<p>[[#File Management Overview|File Management Overview]] </p>
File management overview&nbsp;(this page) </td>
<p>[[ Model 204 File and Data Structure Overview#Model 204 file structure|Model 204 file structure]] </p>
</td>
</tr>
</tr>
<tr>
<tr>
<td align="right">2</td>
<td>2</td>
<td>Planning your files for most efficient storage and best performance; determining size and security requirements</td>
<td>Designing your files for most efficient storage and best performance; determining size and security requirements</td>
<td>[[ Planning Files#Planning Files|Planning Files]] </td>
<td>[[File design]] </td>
</tr>
</tr>
<tr>
<tr>
<td align="right">3</td>
<td>3</td>
<td>Designing your <var class="product">Model&nbsp;204</var> files for most efficient data processing</td>
<td>Designing your <var class="product">Model&nbsp;204</var> data structures for effective and efficient processing</td>
<td>[[ Designing Files#Designing Files|Designing Files]] </td>
<td>[[Record design]] <br>
[[Field design]] <br>
[[Field group design]]</td>
</tr>
</tr>
<tr>
<tr>
<td>
<td>4
<p>4 </p>
<p>(if you create the
<p>(if you create the file manually)</p>
file manually)</p> </td>
</td>
<td>Calculating file size:
<td>
<p>Calculating file size:</p>
<p>Calculating size for Table A, Table B, Table X, Table C, Table D, Table E</p>
<p>Allocating disk space and data sets</p>
<p>Note: These calculations are done for you if you create files using FILEMGMT, which is the recommended method. But the information is useful to know in any case.</p>
</td>
<td>[[ File Size Calculation#File Size Calculation|File Size Calculation]] </td>
</tr>
<tr>
<td align="right">5</td>
<td>
<p>Creating files:</p>
<ul>
<ul>
<li>determining the necessary parameters and their values</li>
<li>Calculating size for Table A, Table B, Table X, Table C, Table D, Table E</li>
<li>determining the necessary fields, field values, and disk space</li>
<li>Allocating disk space and data sets</li>
<li>building the File Control Table (FCT)</li>
</ul>
</ul>
</td>
<p class="note"><b>Note:</b> These calculations are done for you if you create files using FILEMGMT, which is the recommended method. But the information is useful to know in any case.</p></td>
<td>
<td>[[File sizing introduction]] </td>
<p>[[ Creating Files Manually#Creating Files Manually|Creating Files Manually]] </p>
<p>[[ Creating a File with FILEMGMT#Creating a File with FILEMGMT|Creating a File with FILEMGMT]] </p>
</td>
</tr>
</tr>
<tr>
<tr>
<td align="right">6</td>
<td>5</td>
<td>Specifying and changing field descriptions (DEFINE, REDEFINE, DELETE, RENAME commands)</td>
<td>Creating files:
<td>
<ul>
<p>[[ Defining Fields Manually#Defining Fields Manually|Defining Fields Manually]] </p>
<li>Determining the necessary parameters and their values</li>
<p>[[ Defining Fields with FILEMGMT#Defining Fields with FILEMGMT|Defining Fields with FILEMGMT]] </p>
<li>Determining the necessary fields, field values, and disk space</li>
</td>
<li>Building the File Control Table (FCT)</li>
</ul></td>
<td>[[Creating a file]]  
<p>[[Creating a file with FILEMGMT]] </p></td>
</tr>
</tr>
<tr>
<tr>
<td align="right">7</td>
<td>6</td>
<td>Initializing files</td>
<td>Initializing files</td>
<td>[[ Initializing Files Manually#Initializing Files Manually|Initializing Files Manually]] </td>
<td>[[Initializing files]] </td>
</tr>
</tr>
</table>
</table>
<p>&nbsp;</p>
 
 
<table>
<table>
<caption>File management tasks</caption>
<caption>File management tasks</caption>
Line 102: Line 119:
<th>For information, see ...</th>
<th>For information, see ...</th>
</tr>
</tr>
<tr>
<tr>
<td>
<td>Loading data into a file  
<p>Loading data into a file; </p>
<p>Loading raw data from a sequential data set into records in a <var class="product">Model&nbsp;204</var> file </p></td>
<p>Load raw data from a sequential data set into records in a <var class="product">Model&nbsp;204</var> file.</p>
<td>[[File loading techniques]]  
</td>
<p>[[File Load utility]] </p></td>
<td>
<p>[[ File Loading Techniques#File Loading Techniques|File Loading Techniques]] </p>
<p>[[ File Load Utility#File Load Utility|File Load Utility]] </p>
</td>
</tr>
</tr>
<tr>
<tr>
<td>Managing deferred updates</td>
<td>Managing deferred updates</td>
<td>[[ Deferred Update Feature#Deferred Update Feature|Deferred Update Feature]] </td>
<td>[[Deferred update feature]] </td>
</tr>
</tr>
<tr>
<tr>
<td>Managing the size of file tables; options and parameters for automatic or manual increases</td>
<td>Managing the size of file tables; options and parameters for automatic or manual increases</td>
<td>[[ Managing File and Table Size Manually#Overview|Overview]] </td>
<td>[[Managing file and table sizes|Resizing tables]] </td>
</tr>
</tr>
<tr>
<tr>
<td>Safeguarding file integrity and recovering files; backing out transactions; running media recovery</td>
<td>Safeguarding file integrity and recovering files; backing out transactions; running media recovery</td>
<td>[[ File Integrity and Recovery#File Integrity and Recovery|File Integrity and Recovery]] ; [[ Transaction Back Out#Transaction Back Out|Transaction Back Out]] ; [[ Media Recovery#Media Recovery|Media Recovery]] </td>
<td>[[File integrity and recovery]] <br>[[Transaction back out]] <br>[[Media recovery]] </td>
</tr>
</tr>
<tr>
<tr>
<td>Dumping and restoring files: creating a backup copy of your data; moving files; adjusting internal space calculation</td>
<td>Dumping and restoring files: creating a backup copy of your data; moving files; adjusting internal space calculation</td>
<td>[[ File Dumping and Restoring#File Dumping and Restoring|File Dumping and Restoring]] </td>
<td nowrap>[[File dumping and restoring]] </td>
</tr>
</tr>
<tr>
<tr>
<td>Managing <var class="product">Model&nbsp;204</var> security for logins, files, and records; defining passwords and file privileges</td>
<td>Managing <var class="product">Model&nbsp;204</var> security for logins, files, and records; defining passwords and file privileges</td>
<td>[[ Security#Security|Security]]<td>
<td>[[Model 204 security features]]</td>
</tr>
</tr>
<tr>
<tr>
<td>Monitoring file use on the system and system performance; compiling file statistics</td>
<td>Monitoring file use on the system and system performance; compiling file statistics</td>
<td>[[ File Statistics and Tuning#File Statistics and Tuning|File Statistics and Tuning]] </td>
<td>[[File statistics and tuning]] </td>
</tr>
</tr>
<tr>
<tr>
<td>Reorganizing files</td>
<td>Reorganizing files</td>
<td>[[ File Reorganization#File Reorganization|File Reorganization]] </td>
<td>[[File reorganization]] </td>
</tr>
</tr>
<tr>
<tr>
<td>Displaying a field, file, or record; Broadcasting a file message</td>
<td>Displaying a field, file, or record; broadcasting a file message</td>
<td>[[ Field Display and Message Broadcast#Overview|Overview]] </td>
<td nowrap>[[Field display and message broadcast]] </td>
</tr>
</tr>
</table>
</table>
<p>&nbsp;</p>
[[Category:File manager]]
[[Category:Model 204 files]]
[[Category:Dictionary/204]]

Latest revision as of 23:00, 22 June 2017

File management tasks

You might want to designate one or more persons at your site to be responsible for all tasks related to file management.

File management tasks include:

  • Creating, maintaining, and administering Model 204 database files
  • Organizing Model 204 database files for maximum efficiency in data retrieval

The users performing file management tasks (thus acting in the role of "file manager") must be proficient in:

  • Data allocation, storage, and retrieval, and transaction backout (as required for all database management systems)
  • Tasks unique to Model 204 (as described in the file management topics)

A good file manager should understand application design and SOUL coding techniques to assist the application developers in their tasks.

The file manager works closely with the system manager. System manager duties include starting, stopping, and monitoring the Model 204 system and setting user priorities and security.

File manager privileges

File manager privileges are established at the file level: privileges for each file are defined on the password used to open the file or the PRIVDEF (default) file privileges when no password is supplied on the file open.

Dictionary/204 File Management Subsystem facility

If you use the Model 204 data administration product, Dictionary/204, you have access to the File Management Subsystem facility (FILEMGMT). You can choose to create and maintain Model 204 files using FILEMGMT instead of entering commands in a file or on the command line.

FILEMGMT is a full-screen interface that prompts you for the specific file definition information it needs to automatically construct the Model 204 commands that create and define the file. FILEMGMT provides automatic file sizing and other time-saving features.

FILEMGMT also stores the entries in your site's Dictionary for the files, fields, records, and field groups that you create. For more information on the Dictionary, refer to Dictionary/204 overview.

In addition to creating new files and providing automatic file sizing, you can use FILEMGMT to add fields or records to existing files, to change file parameters or file size, and to view or copy file information. FILEMGMT tasks are described throughout the file management topics.

Even if you intend on using the FILEMGMT APSY, you should have a solid knowledge of the rules and techniques involved in the creation and maintenance of Model 204 files.

Getting started

You can perform most file management tasks in two ways:

  • Manually creating procedures containing commands or directly on the command line
  • Using the File Management Subsystem Facility (FILEMGMT)

There are file management topics to describe each way of performing a task.

The following tables describe where to find information about file creation and file management tasks. Where applicable, the Order column indicates the order in which you should perform the tasks.

File creation tasks
Order Task For information, see ...
1 Understanding Model 204 file architecture and file managment File architecture overview
File management overview (this page)
2 Designing your files for most efficient storage and best performance; determining size and security requirements File design
3 Designing your Model 204 data structures for effective and efficient processing Record design

Field design

Field group design
4

(if you create the file manually)

Calculating file size:
  • Calculating size for Table A, Table B, Table X, Table C, Table D, Table E
  • Allocating disk space and data sets

Note: These calculations are done for you if you create files using FILEMGMT, which is the recommended method. But the information is useful to know in any case.

File sizing introduction
5 Creating files:
  • Determining the necessary parameters and their values
  • Determining the necessary fields, field values, and disk space
  • Building the File Control Table (FCT)
Creating a file

Creating a file with FILEMGMT

6 Initializing files Initializing files


File management tasks
Task For information, see ...
Loading data into a file

Loading raw data from a sequential data set into records in a Model 204 file

File loading techniques

File Load utility

Managing deferred updates Deferred update feature
Managing the size of file tables; options and parameters for automatic or manual increases Resizing tables
Safeguarding file integrity and recovering files; backing out transactions; running media recovery File integrity and recovery
Transaction back out
Media recovery
Dumping and restoring files: creating a backup copy of your data; moving files; adjusting internal space calculation File dumping and restoring
Managing Model 204 security for logins, files, and records; defining passwords and file privileges Model 204 security features
Monitoring file use on the system and system performance; compiling file statistics File statistics and tuning
Reorganizing files File reorganization
Displaying a field, file, or record; broadcasting a file message Field display and message broadcast