Hi Karel, I think you need to keep your active log size as multiples of 8 so that it can create enough 512 mb files in the active log directory.
16384/512=32 active log files In your case : 19000/512=37.10 active log files By Sarav +65-82284384 > On 11 Feb, 2014, at 10:34 pm, Karel Bos <[email protected]> wrote: > > Hi Zoltan, > > activelogsize 19000 > > And there was abt 20GB free space in the active log disk. > > Kind regards, > > Karel > > > 2014-02-11 14:52 GMT+01:00 Zoltan Forray <[email protected]>: > >> What is your ACTIVELOGSIZE set to? Maybe it is enforcing that limit, not >> the available free space? >> >> >>> On Tue, Feb 11, 2014 at 8:44 AM, Karel Bos <[email protected]> wrote: >>> >>> Hi, >>> >>> I upgraded my windows TSM Test server from V6.3.4.0 to V7.1.0.0 and it >>> didn't end well. >>> >>> Software install went ok. Both DB2 and TSM where upgraded but the upgrade >>> db part ended with >>> >>> SQL1762N Unable to connect to database because there is not enough space >>> to allocate active log files. SQLSTATE=08004 >>> >>> Bit strange because the active log drive had almost 20 GB of free space. >>> Also any other drive connected to this system had more than 5 GB of free >>> space. >>> >>> Looking in the DB2diag log I see this message: >>> >>> MESSAGE : ZRC=0x85100084=-2062548860=SQLP_NO_SPACE_FOR_LOG >>> "Not enough space to create primary logs" >>> DATA #1 : String, 59 bytes >>> Log path / Free space (bytes) / Log space required (bytes): >>> DATA #2 : String, 43 bytes >>> C:\tsm\actlog\vol12\NODE0000\LOGSTREAM0000\ >>> DATA #3 : unsigned integer, 8 bytes >>> 10466885632 >>> DATA #4 : unsigned integer, 8 bytes >>> 17180131328 >>> >>> If I calculate #3 its the amount of free space on C:, but not the amount >> on >>> c:\tsm\actlog (which is a mounted disk!). >>> >>> Trying to relocate the log to another lun just end up with the same >> error. >>> Any ideas? If its because of free space calculation going wrong because >> of >>> mounted disk, we have a "challenge". All our TSM servers running on >> windows >>> use mounted disks instead of drive letters.... >>> >>> I also have a ticket open with IBM support about this, but until now the >>> support engineer is still thinking an upgrade is the same as a fresh >>> install and running the install wizzard a 2nd time is a good idea.... >>> >>> All in all, not a great start with TSM V7.1. >>> >>> Kind regards, >>> >>> Karel >> >> >> >> -- >> *Zoltan Forray* >> TSM Software & Hardware Administrator >> Virginia Commonwealth University >> UCC/Office of Technology Services >> [email protected] - 804-828-4807 >> Don't be a phishing victim - VCU and other reputable organizations will >> never use email to request that you reply with your password, social >> security number or confidential personal information. For more details >> visit http://infosecurity.vcu.edu/phishing.html >>
