[Xymon] fetch error - dbcheck.pl

[Marco Avvisano]

Try to resend ..
has anyone had similar problemsmonitoring db2 ?
My db2 client  version is 9.7  (64)
thanks for help

Marco

Il 19/10/2011 9.10, Marco Avvisano ha scritto:
>
> Hi, I'm migrating to redhat Red Hat Enterprise Linux Server release 
> 6.1 (Santiago) (64).
>
>  The query is done correctly (tablespace) but the values continues to 
> fetch until it
> finds an empty table.
>
> On the new server i get this message:
>
> fbh 6: 'maxsize' NULLable, type -5,  20, dsize 19, p0 s18965564
>    out: ftype 1, indp 0, bufl 81, rlen 81
> <- prepare= ( DBI::st=HASH(0xba2c30) ) [1 items] at Hobbit_fd_lib.pm
> line 1089 via  at dbcheck.pl line 1356
>     ->  execute for DBD::DB2::st (DBI::st=HASH(0xba2c30)~0x107fd20)
> <- execute= ( -1 ) [1 items] at Hobbit_fd_lib.pm line 1093 via  at
> Hobbit_fd_lib.pm line 1090
>     ->  fetchall_arrayref in DBD::_::st for DBD::DB2::st
> (DBI::st=HASH(0xba2c30)~0x107fd20 HASH(0x1080260))
> 2<- FETCH= ( [ 'name' 'size' 'free' 'used' 'usedpct' 'autoextend'
> 'maxsize' ] ) [1 items] at DBI.pm line 2043 via  at Hobbit_fd_lib.pm
> line 1099
>     dbd_st_fetch 7 fields
>         0: rc=0 'SYSCATSPACE'
>         1: rc=0 '745013248'
>         2: rc=0 '142999552'
>         3: rc=0 '602013696'
>         4: rc=0 '80.80'
>         5: rc=0 '1'
>         6: rc=0 '-1'
>
> (..)
>
>
> 2<>  FETCH= ( [ 'name' 'size' 'free' 'used' 'usedpct' 'autoextend'
> 'maxsize' ] ) [1 items] ('NAME' from cache) at DBI.pm li
> ne 2043 via  at Hobbit_fd_lib.pm line 1099
>     !! info: '' '[IBM][CLI Driver][DB2/AIX64] SQL0100W  No row was
> found for FETCH, UPDATE or DELETE; or the result of a quer
> y is an empty table.  SQLSTATE=02000
> ' (err#0)
>
> ---------------
> Summary of my perl5 (revision 5 version 12 subversion 4) configuration:
>
>   Platform:
>     osname=linux, osvers=2.6.32-131.6.1.el6.x86_64, archname=x86_64-linux
>     uname='linux my.server 2.6.32-131.6.1.el6.x86_64 #1 smp mon jun 20
> 14:15:38 edt 2011 x86_64 x86_64 x86_64 gnulinux '
>     config_args='-de -Dcc=gcc -Dprefix=/opt/perl5'
>     hint=recommended, useposix=true, d_sigaction=define
>     useithreads=undef, usemultiplicity=undef
>     useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
>     use64bitint=define, use64bitall=define, uselongdouble=undef
>     usemymalloc=n, bincompat5005=undef
>   Compiler:
>     cc='gcc', ccflags ='-fno-strict-aliasing -pipe -fstack-protector
> -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
>     optimize='-O2',
>     cppflags='-fno-strict-aliasing -pipe -fstack-protector
> -I/usr/local/include'
>     ccversion='', gccversion='4.4.5 20110214 (Red Hat 4.4.5-6)',
> gccosandvers=''
>     intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
>     d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
>     ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
>     alignbytes=8, prototype=define
>   Linker and Libraries:
>     ld='gcc', ldflags =' -fstack-protector -L/usr/local/lib'
>     libpth=/usr/local/lib /lib/../lib64 /usr/lib/../lib64 /lib /usr/lib
> /lib64 /usr/lib64 /usr/local/lib64
>     libs=-lnsl -ldb -ldl -lm -lcrypt -lutil -lc
>     perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
>     libc=/lib/libc-2.12.so, so=so, useshrplib=false, libperl=libperl.a
>     gnulibc_version='2.12'
>   Dynamic Linking:
>     dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
>     cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib
> -fstack-protector'
>
>
> Characteristics of this binary (from libperl):
>   Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP
> USE_64_BIT_ALL
>                         USE_64_BIT_INT USE_LARGE_FILES USE_PERLIO
>                         USE_PERL_ATOF
>   Built under linux
>   Compiled at Sep 15 2011 10:39:35
>   @INC:
>     /opt/perl5/lib/site_perl/5.12.4/x86_64-linux
>     /opt/perl5/lib/site_perl/5.12.4
>     /opt/perl5/lib/5.12.4/x86_64-linux
>     /opt/perl5/lib/5.12.4
> ----------------------
>
> Program Information
>         dbcheck.pl version 1.08
>         Hobbit_fd_lib.pm version 1.15
>
> OS Information
>         Linux my.server 2.6.32-131.6.1.el6.x86_64 #1 SMP Mon Jun 20
> 14:15:38 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
>         Perl version is v5.12.4
>
> Module Information
>         FindBin 1.50
>         POSIX 1.19
>         Text::Wrap 2009.0305
>         Sys::SigAction 0.15
>         Config::IniFiles 2.68
>         DBI 1.616
>         DBD::DB2 1.81
>         DBD::DBM 0.06
>         DBD::ExampleP 12.014310
>         DBD::File 0.40
>         DBD::Gofer 0.014282
>         DBD::SQLite 1.33
>         DBD::Sponge 12.010002
>         DBD::mysql 4.020
>
> -----------------
>
> Anyone have simular problem?
> Thanks for help
>
>
>  Marco
>
>
>
> _______________________________________________
> Xymon mailing list
> Xymon at xymon.com
> http://lists.xymon.com/mailman/listinfo/xymon
>