db2 on NT unable to allocate memory to bufferpools
Posted on 2004-03-24
While Restarting the Database in order to capture the logs, The following commands are used to stop and start the database
After this Db2diag.log says, Unable to allocate memory to bufferpools. Database is starting two tiny bufferpools. At this stage i cannot even open text files. This problem will be solved once i shutdown and restart the machine.
Hardware :- UNISYS ES5000
Processor :- Intel Pentium II 450 Mhz
Memory :- 4 GB RAM
Disk Capacity :- 400 GB using Mylex RAID 0 - Fibre Channel Disk
Local Hard Disk :- 2 SCSI Harddisk of Capacity 17 GB each ( C Drive & E Drive)
Software Configuration :-
Operating System :- Windows NT 4 with NT Service pack 6 Installed
DB Version :- IBM UDB DB2 Version 7.2.3 Enterprise Edition For Windows NT ( Version 7.01 with Fixpack 3 and 5 installed)
Operating System is installed on Local SCSI harddisk ( C Drive) and DB2 is installed on E drive. Database is residing on Fibre Channel Disk. It is divided into five Logical drives Tablespaces are spanned over 5 logical drives.
Total Size of the DB is 110 GB, and is roll-forward enabled.