RE: SAPDB 7.4.3.x on AMD64

> - the Python modules are installed to
>   /opt/sapdb/depend/misc/lib64/...
>   as defined as INSTMISC in buildtools for all 64bit platforms.
>   But the system-table load couldn't find the modules there 
> and fails to
>   import e.g. sapdb/loader.py
>   After moving all stuff out of lib64 directories the load runs fine.
>   I could change the behaviour to not use misc/lib64 for 
> AMD64 but this
>   would be only a dirty workaround.
>   What can be incomplete so that the modules couldn't be found?

If one can live with building SAP DB for 64bit only on that platform, then the followng patch would be the right thing:
==== //prodprojects/vmake/dev/src/_tools/maketools/sys/src/tt/toolvars-tml.pl.tt#3 - d:\TOOLSRC\develop\sys\src\tt\toolvars-tml.pl.tt ====
@@ -1854,7 +1854,7 @@
 $ENV{INSTLIB} = $INSTROOT."\\lib";
 $ENV{INSTMISC} = $INSTROOT."\\misc";
 &else
-if ($ENV{BIT64} eq "1" && $MACH ne "ALPHA" && $MACH ne "IA64")
+if ($ENV{BIT64} eq "1" && $MACH ne "ALPHA" && $MACH ne "IA64" && $MACH ne "X86_
64")
 {
     #all 64-bit-platforms should use lib/lib64
     $ENV{INSTLIB} = $INSTROOT."/lib/lib64";

This is at least what we do for Linux/IA64. We're using the lib64 directories only on platforms where we support both 32bit and 64bit clients.

> - if I logon via WebDBM it can't show the stats.
>   I get always
>   -24988  	   	sql error
>   -4004  	   	Message not available:INFO_STATE
> 
>   This is what I get from almost all commands in WebDBM.
>   (with other messages not available)
>   How can I debug that problem?

It looks as if the system tables are not loaded.

> - another NOT AMD64 specific problem I see in 7.4.3.17 is:
> 
> dbmcli on satie.suse.de : TST> exit
> 
> ---
> ERR -11608 COMMUNIC sql03_request: wrong connection state, state is
> 'requested'

Try:
imf -u ven03.c/-DDEBUG_RTE dbmcli
dbmcli ...

This should write a file usr/wrk/stark/appldiag which contains some traces

Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
[email protected]
http://www.sapdb.org/