Configuración del plugin

Para poder conectar con la base de datos a monitorizar, se deberán rellenar los siguientes campos, en el archivo pandora_sybase.conf:

 

 

Ejemplo:

user1=sa
password1=p4assword
server1= desktop12
name_agent1=sybase_desktop12

user2=sa
password42=Fr4gile
server2=desktop7
name_agent2=sybase_desktop7

* si la base de datos solo se puede conectar por isql especificando el puerto, se deberá especificar en el conf, por ejemplo : desktop12:2083

Ejemplo:

query1=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.*4096 as data_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid and d.status != 256 and db_name^(u.dbid^^^) = 'test'
namemodule1=data used database test
typemodule1=generic_data

query2=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.*4096 as data_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid and d.status != 256 and db_name^(u.dbid^^^) = 'master'
namemodule2=data used database master
typemodule2=generic_data

Ejemplo de archivo.conf

isql=C:\SAP\OCS-16_0\bin\isql

# numero de bases de datos
numberdatabases=1

# usuario base datos
user1=sa
password1=pandorapass
server1=DESKTOPDQN7L842
name_agent1=sybase_DESKTOPDQN7L842

mode=tentacle
tentacle_ip=192.168.0.29
tentacle_port=41121

# numero de consultas
numberqueries=2

# consultas y modulos

query1=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.*4096 as data_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid  and d.status != 256 and db_name^(u.dbid^^^) = 'test'
namemodule1=data used database test
typemodule1=generic_data

query2=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.*4096 as data_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid  and d.status != 256 and db_name^(u.dbid^^^) = 'master'
namemodule2=data used database master
typemodule2=generic_data

Revision #7
Created 25 August 2022 11:56:39 by alejandro.sanchez
Updated 12 May 2023 07:45:37 by alejandro.sanchez