Btrieve

  Home  Databases Programming  Btrieve


“Btrieve frequently Asked Questions in various Btrieve job Interviews by interviewer. The set of questions here ensures that you offer a perfect answer posed to you. So get preparation for your new job hunting”



29 Btrieve Questions And Answers

2⟩ Suppose When I am attached to a lot of NetWare v3.11 servers (24), each running the NetWare Btrieve NLM v5.15, I get a status 38 (Transaction Control File I/O) even though each Btrieve NLM is configured for transactions. What should I do?

- Verify the number of file servers, the /s parameter on Brequest whether it large enough

- If the number is higher, it may stop the status 38.

- Check the /s parameter (number of file servers) on Brequest to see if it is large enough. A higher setting may stop the status 38.

 169 views

4⟩ What is Btrieve

Btrieve is a transactional database, navigational database software product. It is based on Indexed Sequential Access Method (ISAM), which is a way of storing data for fast retrieval. There have been several versions of the product for DOS, Linux, older versions of Microsoft Windows, Windows 98, Windows NT, Windows 2000, Windows XP, Windows Server 2003, 32-bit IBM OS/2 and for Novell NetWare.

 125 views

5⟩ Suppose 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

 155 views

6⟩ Explain 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 cant 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.

 141 views

7⟩ 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

 147 views

10⟩ How to run Btrieve on SFT III server?

The following engines are required to run Btrieve on SFT III server.

- Btrieve.nlm on MSEngine

- BSPXCOM.NLM on MSEngine

- AFTER311.NLM on IOEngine

- Btrieve is unaware of running SFT III Server

- The I/O and mirroring will be taken care by OS

 138 views

11⟩ Explain DDF Editor for Btrieve?

-DDF editor allows to create the description of files

-DDF is necessary to access Btrieve files through ODBC / OLE

- Allows to

-create / view / edit dictionary DDF

-import and export data from ODBC data source

-drag and drop / copy and paste the descriptions

-rebuild files

-search filtration data

 151 views

13⟩ Explain error codes of Btrieve?

-INVALID OPERATION – The parameter of the operations of a call is invalid

-I/O ERROR – An error occurred during a disk read / write operation.

-FILE NOT OPEN – Any operation on the designated file can not be performed as the file is not open

-KEY VALUE NOT FOUND - The designated key value is not found in the index path

-INVALID POSITIONING - Each time the current position need to be established. This position is application for update / deletion of a record.

 131 views

14⟩ Tell us what you know about Btrieve?

- Btrieve is a navigational database product

- Based on Indexed Sequential Access Method(ISAM)

- ISAM is a way of fast data retrieval

- Btrieve retrieves one record at a time.

- Transaction Operation is faster as there is little overhead with Btrieve Engine

 153 views

15⟩ What is File sharing?

-Data available in a file can be shared by using Single Engine File Sharing and Multiple Engine File Sharing modes.

-SEFS is allowed only to the clients to access the engine for altering databases.

-MEFS allows multiple clients running under multiple engines for accessing the database.

 135 views

18⟩ Can you explain System and User Transactions?

-System transactions are non-transactional operations

-System transactions are used for data recovery using MKDE.

-User transactions are concurrent transactions.

-User transaction might have lost when a recent transaction was rolled back

-When a user transaction is rolled back, an option might be set which causes the MKDE to force the system transactions.

 129 views

20⟩ Explain 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.

 143 views