OSDALOTS - SETTING UP LOTUS 1-2-3 IN AN OS/2 DOS SESSION 01/18/96 ======================================================================= Setting up Lotus 1-2-3 in an OS/2 DOS Session ======================================================================= Please Read Entire Document for Full Explanation of Procedures -------------------------------------------------------------- DESCRIPTION Problems running Lotus 1-2-3 under OS/2 RESOLUTION All versions of Lotus 1-2-3 running in OS/2 use expanded memory specification (EMS) and look between C000 and DFFFF to find it. EMS requires a 64 KB block of contiguous free memory in the address range of 640 KB to 1 MB for its page frame. You could have an adapter conflict. Install and set up your Lotus 1-2-3 using the following setup procedures. If Lotus does not start, see "OS/2 EMS Conflicts with DOS Applications Running in a DOS Session" later in the document. This document consists of the following sections: * Setting Up Lotus 1-2-3 * Common Problems and Solutions * OS/2 Expanded Memory (EMS) Conflicts with DOS Applications Running in a DOS Session * Reconfiguring the Memory Remapping on Various Systems Setting Up Lotus 1-2-3 ---------------------- Releases V2.0--V2.4 ------------------- 1. Open the Templates folder on the Desktop. 2. Move the mouse pointer to the Program object; then press and hold mouse button 2 and drag the Program object icon to the Desktop. Release mouse button 2. The Settings notebook appears. 3. In the Path and File Name entry field, type the location of the Lotus directory and executable file that starts the program. For example, D:\123R23\123.EXE. 4. Select the Session tab. 5. Select DOS Full Screen as Session Type. 6. Select DOS Settings... . 7. Select EMS_MEMORY_LIMIT and set it to accommodate the largest expected spreadsheet. The default is 2,048 (2 MG). Note: V2.0--V2.2 recognize up to 4 MB of EMS. V2.3 and V2.4 recognize up to 12 MB. 8. Select MEMORY_INCLUDE_REGIONS and type C0000-CFFFF. 9. Select EMS_FRAME_LOCATION and change the value to C000. 10. Select MEMORY_EXCLUDE_REGIONS and type D0000-DFFFF. 11. Select Save. 12. Select the General tab and change the Title to the name you want for the Desktop object; for example, Lotus 2.3. 13. Close the Settings notebook. 14. The Lotus 1-2-3 icon appears. Release V3.1 ------------ The Installation program checks that it is running in native DOS. Using DOS Settings for an OS/2 DOS session, you can create a session that returns a simulated DOS value to the Lotus INSTALL.EXE program. The following steps must be performed to load Lotus in a Full Screen DOS compatibility box under OS/2. 1. Using a text editor, create a 123.BAT file in the Lotus directory and include the following statements: * SET 123MEMSIZE=2048 or the desired amount of RAM (in KB) to be allocated to the spreadsheet; 2048 is 2 MB. If you have fairly large spreadsheets, set MEMSIZE to 4098 or greater. * 123 (or LOTUS). This begins the program. 2. Save and exit the file. 3. Open the Templates folder on the Desktop. 4. Move the mouse pointer to the Program object; then press and hold mouse button 2 and drag the Program object icon to the Desktop. Release mouse button 2. The Settings notebook appears. 5. In the Path and File Name entry field, type the location of the 123.BAT file to start the program. For example, D:\123R3\123.BAT. 6. Select the Session tab. 7. Select DOS Full Screen. 8. Select DOS Settings... . 9. Select DOS_FILES and set to at least 40. 10. Select DOS_VERSION. 11. Go to the Value box and scroll down to the last entry. Place the cursor at the end of this entry and press Enter to start a new line. 12. Type the following lines in this sequence: 123.EXE,3,40,255 123DOS.EXE,3,00,255 LOTUS.EXE,3,40,255 INSTALL.EXE,3,40,255 TRANS.EXE,3,40,255 Note: If you do not want to run INSTALL.EXE or TRANS.EXE, omit the last two lines. 13. Select Save to save the new settings. 14. Select EMS_MEMORY_LIMIT and set it to the same size as that in the SET 123MEMSIZE statement above. If you do not change this, Lotus sees only 2 MB of memory. 15. Select DPMI_MEMORY_LIMIT and set it to double the size set in EMS_MEMORY_LIMIT. 16. Select DPMI_DOS_API. 17. Click to the right of Auto; then select Enable. Note: Steps 1 and 14 through 16 are extremely important. If you do not make MEMSIZE large enough, you might not have enough memory to run Lotus after loading your spreadsheet. 18. Select MEMORY_INCLUDE_REGIONS and type C0000-CFFFF. 19. Select EMS_FRAME_LOCATION and change the value to C000. 20. Select MEMORY_EXCLUDE_REGIONS and type D0000-DFFFF. 21. Select Save. 22. Select the General tab and change the Title to the name you want for the Desktop object; for example, Lotus 3.1. 23. Close the Settings notebook. 24. The Lotus 1-2-3 icon appears. Release V3.4 ------------ Installation ------------ If you get the error message, "You cannot run this program in a DOS compatibility box. You must run this program with DOS 3.3 or later." try the following installation procedure: 1. Open the Settings notebook for the DOS Window or Full Screen session in which you are installing Lotus. 2. Select the Session tab. 3. Select DOS Settings... and then DOS_VERSION. 4. On a new line, type INSTALL.EXE,5,00,255. This simulates DOS 5.0. 5. Select Save to save the new settings; then close the Settings notebook. 6. Reinstall Lotus. Setup ----- Set up this version as described in "Release V3.1" above, except for the DOS_VERSION settings. Type these lines instead: 123.EXE,3,40,255 LOTUS.EXE,3,40,255 INSTALL.EXE,3,40,255 TRANS.EXE,3,40,255 FONTGEN.EXE,3,40,255 INS.EXE,3,40,255 Common Problems and Solutions ----------------------------- * Cannot read or write to drive A, and pressing Ctrl+Break at any time causes the system to exit Lotus. Both cause a General Protection Fault. For systems with the original OS/2 2.0 code (3/30/92), install Service Pak 2--XR06100. * SYS2237 Error Message. Lotus 1-2-3 V3.1 assumes that all 486 chips have a math coprocessor. Edit the 123.BAT file and add -s (lowercase s) to the 123 line (123 -s). Lotus 1-2-3 will no longer look for a math coprocessor. * Cannot install Lotus 1-2-3. You receive the error message: "You cannot run this program in a DOS compatibility box. You must run this program with DOS 3.3 or later." Try the following installation procedures: Procedure 1: ------------ 1. Open the Settings notebook for a DOS Window or Full Screen. 2. Select the Session tab. 3. Select DOS Settings... and then DOS_VERSION. 4. On a new line, type INSTALL.EXE,5,00,255. This simulates DOS 5.0. 5. Select Save to save the new settings; then close the Settings notebook. 6. Reinstall Lotus. Procedure 2: ------------ 1. Start the system in native DOS. 2. Install Lotus from drive A, following the instructions that came with the program. Procedure 3: ------------ Start the system with a DOS diskette or create a Virtual Machine Boot (VMB) from a DOS environment. IBM Technical Support has documentation for a VMB. OS/2 EMS Conflicts with DOS Applications Running in a DOS Session ----------------------------------------------------------------- Many DOS applications, Terminate-and-Stay Resident programs (TSRs), or loading device drivers high, use expanded memory specification (EMS) when loading. Some examples of DOS applications are spreadsheets, word processors, databases, desktop publishing, and computer aided design (CAD) systems. Several problems can occur if EMS is not detected: * You receive a SYS3176 error. * The DOS session locks up when starting an application. * When starting an application in a DOS session, a flash of text pertaining to an adapter conflict appears and disappears so quickly, you can barely see it. You then are returned to the OS/2 Desktop. This problem usually is related to a Terminate-and-Stay-Resident program (TSR). A DOS session closes when it detects the TSR ending, so the session cannot become resident. To load a TSR: 1. Open the Templates folder on the Desktop. 2. Move the mouse pointer to the Program object; then press and hold mouse button 2 and drag the Program object icon to the Desktop. Release mouse button 2. The Settings notebook appears. 3. Select the Program tab. 4. In the Path and File Name entry field, type an asterisk (*) if it does not already exist. 5. In the Parameters field, type /K followed by the path and name of the TSR; for example, /K C:\FT\FTTERM.BAT. For more information, see Volume 2, page 200, of the IBM Redbooks. * Very little expanded memory shows up in the application, no matter what changes were made to the DOS Settings. To configure EMS support for an OS/2 DOS session (VDM), a contiguous 64 KB block of RAM is used as the EMS Page Frame. This must be available within the upper memory block (UMB) between 640 KB and 1 MB. That address range should be between C0000 and CFFFF, which is exactly 64 KB of memory. All adapter cards whose ROM and RAM addresses are mapped within the C0000--CFFFF range, should be remapped to the D0000--DFFFF range. The most-common adapter cards are video, network, modem, and emulation. Many IBM and OEM systems have their Token-Ring cards mapped to the C0000--CFFFF region. Reconfiguring the Memory Remapping on Various Systems ----------------------------------------------------- IBM Systems ----------- Some IBM systems, such as 56 SLC, 57 SLC, 56 SLC2, 57 SLC2, 76, 77, and 90, have a built-in utility program for creating a backup Reference diskette. The diagnostic programs to reconfigure register addresses can be run from the hard disk. Most of these systems have their video adapters mapped to the C0000--CFFFF region. To start the Utility Program from the hard disk: 1. Turn on the computer and allow the self-tests to finish. 2. Press Ctrl+Alt+Del. 3. Watch the cursor closely. When it moves to the top-right corner of the screen, press Ctrl+Alt+Ins. 4. Go to "IBM Reference Diskette Instructions" below. IBM ValuePoint -------------- These systems have their video addresses mapped to the A0000--AFFFF range. They also have to start the program from the hard disk. Other IBM PS/2 Micro Channel Systems ------------------------------------ A Reference Diskette is provided with each system. Start the system with the diskette in drive A; then see the next topic. IBM Reference Diskette Instructions ----------------------------------- 1. When the IBM logo appears, press Enter. 2. Select Set Configuration. 3. Select Change Configuration. 4. Select the slot and location of the adapter that is mapped to the C0000--CFFFF range. 5. Press F6 to toggle to a free D0000--DFFFF memory range address. 6. Press F10 to save the configuration. 7. Restart the system. The goal is to free the C0000--CFFFF address by moving adapter ROM and RAM addresses to the D0000--DFFFF range. EISA and ISA Bus Architecture Systems ------------------------------------- Many of these systems have a built-in Diagnostics Setup and Configuration file. After startup, the screen displays a sequence of keys that you press to get to the setup. Some systems allow only viewing; others allow viewing and reconfiguring. Many adapters can be reconfigured only by resetting switches on the adapter. Refer to the documentation that came with the adapter, or contact your vendor for additional information. ______________________________________________________________________ IBM disclaims all warranties, whether express or implied, including without limitation, warranties of fitness and merchantability with respect to the information in this document. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright (c) 1994, 1995 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.