Re: iSPI Pferormance for Metrics - dbsize.ovpl FAILED (492 Views)
Reply
Valued Contributor
Ionut Mosoiu
Posts: 89
Registered: ‎02-10-2010
Message 1 of 3 (503 Views)
Accepted Solution

iSPI Pferormance for Metrics - dbsize.ovpl FAILED

Hi all ,

 

someone has met the folloging error  (prspi.log).

 

 

------------------------------------------------------------------------------------------

Feb 09, 2012 04:33:11 PM [PID:12136] INFO F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl[17] Utility.dbsize Starting dbsize.ovpl.. checking for concurrent executions...
Feb 09, 2012 04:33:11 PM [PID:12136] INFO F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl[21] Utility.dbsize Continuing...
Feb 09, 2012 04:33:11 PM [PID:7176] INFO F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/.etl-runtime.PerfSPI_Diagnostics.ovpl[290] ETL.PerfSPI_Diagnostics Still alive. Will report again in 5 minutes
Feb 09, 2012 04:33:12 PM [PID:12136] INFO F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl[75] Utility.dbsize DBSPACE USER_MAIN running low on space (760sed).. auto extending
Feb 09, 2012 04:33:12 PM [PID:12136] INFO F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl[158] Utility.dbsize DBSPACE USER_MAIN, FILE USER_MAIN_01: Adding 31334MB: ALTER DBSPACE USER_MAIN ALTER FILE USER_MAIN_01 ADD 31334
Feb 09, 2012 04:33:12 PM [PID:12136] WARN F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl[160] Utility.dbsize DBD::SQLAnywhere::db do failed: There is insufficient reserve space to add 8021504 blocks to segment f:\PROGRA~2\HP\HPBTOS~1\NNMPerformanceSPI\database\perfspi_MAIN_01.iq. Only 8018944 blocks or less may be added.
-- (s_db.cxx 2557)  (DBD: execute failed) at F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl line 160.
Feb 09, 2012 04:33:12 PM [PID:12136] FATAL F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl[160] Utility.dbsize DBD::SQLAnywhere::db do failed: There is insufficient reserve space to add 8021504 blocks to segment f:\PROGRA~2\HP\HPBTOS~1\NNMPerformanceSPI\database\perfspi_MAIN_01.iq. Only 8018944 blocks or less may be added.
-- (s_db.cxx 2557)  (DBD: execute failed) at F:/Program Files (x86)/HP/HP BTO Software/NNMPerformanceSPI/bin/dbsize.ovpl line 160.
------------------------------------------------------------------------------------------------------------

The system is NNMi 9.11 ( patch 3 ) + iSPI Performance for Metrics installed on the same machine with default DB ( Sybase) .

Any solution to fix it ?

 

 

Best Regards,

 

Daniel

Please use plain text.
Honored Contributor
AndyKemp
Posts: 729
Registered: ‎05-17-2010
Message 2 of 3 (502 Views)

Re: iSPI Pferormance for Metrics - dbsize.ovpl FAILED

I had that issue, took a support case to get it fixed as we had to go into the database and manually add the new datafiles.

Have a nice day :)

Andy Kemp,  CISSP
Please use plain text.
Valued Contributor
Ionut Mosoiu
Posts: 89
Registered: ‎02-10-2010
Message 3 of 3 (492 Views)

Re: iSPI Pferormance for Metrics - dbsize.ovpl FAILED

Hi,

 

helped by the HP support seams that was need to resize the DB file. For this it necesary to use dbsize.ovpl.

 

Help :

Usage: dbsize.ovpl [-h] [-q] [-c <ConnString>] [-x] [-t nn] [-d name] [-f name [
-r size] [-a size] [-p path] ]
        -h      Usage
        -q      Display DBspace Size & Usage
        -x      Automatically extend size of any DBSpace that is over 70 used
        -c cs   Specific database connection String - default is "DSN=PerfSPIDSN
"
        -t nn   Specify auto-extend usage threshold% - default is 70
        -d name Double the allocated space of identified dbspace, up to reserve
limit / avail disk
        -f name Increase reserve limit by adding a new DB File to the specified
DBSPACE
        -r size(M|G)    Specify reserve size of new DB File - default 2GB
        -a size(M|G)    Specify allocation size of new DB File - default 50GB
        -p path Specify directory for new DB File - default PRSPI_DATABASE folder

 

Example :

dbsize.ovpl -f USER_MAIN -r 10G 

- the file will be resized by 10 G more.

 

Best Regards,

 

Ionut Daniel Mosoiu

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation