! Database Definition File
!
! Source Database Name: QNA.RDB
!-------------------------------------------------------------------------------
set verify
!
! Physical Database Definition
!
!!!!!!!!!!!!! YOU MAY HAVE TO ADD A DIRECTORY SPECIFICATION !!!!!!!!!
!
define database 'QNA.RDB'
    dictionary is NOT REQUIRED
    number of users 50
    buffer size is 6 blocks
    number of buffers 20
    adjustable lock granularity ENABLED
    global buffers are DISABLED (number is 250, user limit 5)
    snapshot is ENABLED IMMEDIATE
    allocation is 3000 pages
    snapshot allocation is 100 pages
. ! end define database
commit
!
! Global Field Definitions
!
define field AA_DATE
    datatype DATE.
 
define field AA_NUMBER
    datatype SIGNED LONGWORD
    edit_string for DATATRIEVE is 'ZZZ,ZZ9'.
 
commit
!
! Relation Definitions
!
define relation QNA_COUNTS.
    DATE_TIME			based on AA_DATE.
    SECONDS_SINCE_LAST_ZEROED	based on AA_NUMBER.
    DATA_BLOCKS_RECEIVED	based on AA_NUMBER.
    MULTICAST_BLOCKS_RECEIVED	based on AA_NUMBER.
    RECEIVE_FAILURE		based on AA_NUMBER.
    BYTES_RECEIVED		based on AA_NUMBER
				edit_string for DATATRIEVE is 'Z,ZZZ,ZZ9'.
    MULTICAST_BYTES_RECEIVED	based on AA_NUMBER
				edit_string for DATATRIEVE is 'z,zzz,zz9'.
    DATA_OVERRUN		based on AA_NUMBER.
    DATA_BLOCKS_SENT		based on AA_NUMBER.
    MULTICAST_BLOCKS_SENT	based on AA_NUMBER.
    BLOCKS_SENT_MULTIPLE_COLLISIONS	based on AA_NUMBER.
    BLOCKS_SENT_SINGLE_COLLISION	based on AA_NUMBER.
    BLOCKS_SENT_INITIALLY_DEFERRED	based on AA_NUMBER.
    BYTES_SENT			based on AA_NUMBER
				edit_string for DATATRIEVE is 'Z,ZZZ,ZZ9'.
    MULTICAST_BYTES_SENT	based on AA_NUMBER
				edit_string for DATATRIEVE is 'Z,ZZZ,ZZ9'.
    SEND_FAILURE		based on AA_NUMBER.
    COLLISION_DETECT_CHECK_FAILURE	based on AA_NUMBER.
    UNRECOGNIZED_FRAME_DESTINATION	based on AA_NUMBER.
    SYSTEM_BUFFER_UNAVAILABLE	based on AA_NUMBER.
    USER_BUFFER_UNAVAILABLE	based on AA_NUMBER.
end.
 
define relation DPV_COUNTS.
    DATE_TIME			based on AA_DATE.
    SECONDS_SINCE_LAST_ZEROED	based on AA_NUMBER.
    BYTES_RECEIVED		based on AA_NUMBER
				edit_string for DATATRIEVE is 'Z,ZZZ,ZZ9'.
    BYTES_SENT			based on AA_NUMBER
				edit_string for DATATRIEVE is 'Z,ZZZ,ZZ9'.
    DATA_BLOCKS_RECEIVED	based on AA_NUMBER.
    DATA_BLOCKS_SENT		based on AA_NUMBER.
    DATA_ERRORS_INBOUND		based on AA_NUMBER.
    DATA_ERRORS_OUTBOUND	based on AA_NUMBER.
    REMOTE_REPLY_TIMEOUTS	based on AA_NUMBER.
    LOCAL_REPLY_TIMEOUTS	based on AA_NUMBER.
    REMOTE_BUFFER_ERRORS	based on AA_NUMBER.
    LOCAL_BUFFER_ERRORS		based on AA_NUMBER.
    REMOTE_PROCESS_ERRORS	based on AA_NUMBER.
    LOCAL_PROCESS_ERRORS	based on AA_NUMBER.
end.
 
commit

change protection for database [*,*] access "all".

commit