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