Latest Btrieve Interview Questions Part – 2
If An Application Runs Twenty-four Hours A Day, How To Perform A Backup?
Once a file is opened by Btrieve, no other user / application can open it until Btrieve closes that file.
The operating system’s ‘copy’ command will not work
One can back up the Btrieve file using BUTIL operations.
BUTIL operations uses CLONE for creation of a backup file.
Followed by CLONE, COPY command is used to backup the records from one file to backup file.
Explain What Does The “total” Column In The Butil -stat Indicate?
“Total” column gives the number of UNIQUE values for every key
The column is different from “Total Records” column
How Can I Define A C Long Integer As A Key In Btrieve, When There Is No Long Data Type?
C long integer can be defined as a key in Btrieve by specifying the key as an integer. But the length need to be specified as four bytes.
Suppose When I Perform A Get Next Extended Operation, Btrieve Returns A Status 62. What Does This Mean?
The 62 Status is an error in the descriptor / extractor.
The first two bytes of the data buffer need to contain the exact length of the data buffer that are sent to Get Next Extend operation
The Data Buffer length need not be the4 exact length
If any other variable is defined, the data buffer would be overwritten
What Happens When You Use Netware Btrieve V6.x To Access An Btrieve File That Was Created In The V5.x File Format?
NetWare Btrieve v6.x can access both v5.x and v6.x format files simultaneously and the performance is proper.
Using The Netware Btrieve Nlm V6.0, Btrmon And Ndbmon Show Files As Opened By A Different User Than The One That Originally Opened The Files And I Can’t Back Up Or Close Those Files. Why Does This Happen And What Is The Solution?
When Netware time restrictions are in force and any user’s connection to NetWare is terminated, the Btrieve files are remain open to that connection.
If a new uses logs in and uses the same connection ID, the Monitor utilities will show all the files opened by new user.
All these files have opened by Btrieve
Back up can be taken when they are not in Continuous Operations Mode.
As the necessary Btrieve Position blocks are not available, the user can not access these files.
The application should perform an explicit Btrieve Reset Operation in order to avoid leaving files open or the work station should reboot before NetWare time restrictions take effect.
When I Run The Netware Btrieve V5.15 Nlm With Some Applications On Netware V3.11, Retrieved Btrieve Data Is Incorrect (but Not Corrupted). It Appears, As If The Wrong Records Are Being Accessed Intermittently. What Should I Do?
To ensure the data retrieval correctly by Btrieve:
Use the latest version of NetWare Shell – IPX v3.10, NETX v3.22 or NETX v3.26
Make sure that latest BREQUEST.EXE is running
Verify the Btrieve data file’s page size
If the pages are not evenly divisible into 4k, NetWare mishandles the pages
Use only the pages of sizes 512k, 1024k, 2048k, or 4096k.
The situation would be resolved by using NetWare Patch ASNCROFX.NLM
After Upgrading To Netware V3.11 And The Netware Btrieve Nlm V5.15, Btrieve Is Running Slower Than Expected. What Are The Factors And How To Fix Them?
The following are the factors :
The page sizes of Btrieve are set to 1024 and 512 bytes
All the workstations are configured with IPX v2.15
The disk block size was set to a size apart from default 4k block size
These factors cause a minor Btrieve performance degradation.
The following are the combination of factors to improve performance.
Rebuild the file size of Btrieve with a page size of 4096 bytes
Upgrade IPX to v3.10
Recreate all the volumes block size with 4k
Can A Supplemental Index Be Created Through Btrieve Or Netware Sql At The Time That The Btrieve File Is Created?
No. Because Btrieve always bypasses the bit 7 of the key flags at the time of creation.
The bit 7 is designated as an index supplemental
The indexes are created as permanent.
Does A User Need Create Rights In The Directory Where A Btrieve File Is Stored, In Order To Open That File In Accelerated Mode?
Yes. the right creation is necessary.
Btrieve may create a file called pre-image file, in accelerated mode.
During an insert(2), an index does not allow the duplicates and the insertion of records causes a duplicate error that is to be returned.
Any pages that have been updated already for the insertion, would need to roll back.
Why Does Btrieve Return A Status 22, If One Perform A Stat Operation, Even Though The Maximum Number Of Key Spec Buffers (24) Are Allocated?
The reasons for this are:
An alternate collating sequence might be used.
This require to allocate an additional 265 bytes in the data buffer.
Nine bytes are allocated for the name of the collating sequence and 256 bytes are allocated for actual sequence.
What Is A Status 1015?
Prior to starting the application, if the environment variable SET BTRPARMSCHK=Y is specified, the status 1015 is returned.
Isolation of errors that are caused by passing invalid pointers to Btrieve is done by using this environment variable.
Once this variable is set, Btrieve performs the validation on pointer parameters that are passed in to READ/WRITE access on certain ranges.
Btrieve validates position block pointer on the range of 128 bytes, length pointer validates on two bytes and data buffer is validated on 255 bytes for key buffer