RE: bison/flex - vls14_parse.y not compilable

2004-11-24 Thread Döhr, Markus ICC-H
Hey Daniel, > Our code requires a rather old version of bison. That version > should be part of both the binary tool distribution and the > source tool distribution. Try $TOOL/gnu/bin/bison --version, > this should emit GNU Bison version 1.25 Yeah.. but it seems that configure will check for a

Cursor in Stored Proc

2004-11-24 Thread David Radcliffe @ Northampton
Hello, I have DECLAREd a cursor in a stored proc, but error -5015 is thrown when the compiler reaches the OPEN statement. Any idea why? There are 10 types of programmers: those who understand binary, and those who don't. === This message

Re: Your favorite sites & books on MaxDB

2004-11-24 Thread Noah J SILVA
Funny you should mention "SQL for Smarties", my boss bought this book for me... the first thing I did was go through and look at each thing where they listed the differences between MS-sql-server vs Oracle vs DB2, etc., and add another column for SAPDB (We are using SAPB 7.3). I wish the author

RE: bison/flex - vls14_parse.y not compilable

2004-11-24 Thread Dittmar, Daniel
>When doing 'imf lxlib' I get the following error message: > >vls14_parse.y fast >vls14_parse.y:201.20: warning: stray `,' treated as white space >"vls14_parse.c", line 1951: Error: The function "yylex" must >have a pro\ >totype. Our code requires a rather old version of bison. That version shou

Your favourite sites & books on MaxDB

2004-11-24 Thread Ulf Wendel
Hi, I would like to know which are your favourite web pages / sites and books on MaxDB? When it comes to books, what are you favourite books on: - SQL in general ... for beginners - Advanced SQL ... like Celko's SQL for Smarties ... like Gulutzan's SQL Performance Tuning - Background knowle

RE: jdbc connection slowed part II

2004-11-24 Thread Schroeder, Alexander
Apparantly the database server cannot resolve the name of the client - which is 127.0.0.1 (localhost), which leads to the assumption that some of your network settings might be misconfigured. I would look why 127.0.0.1 could not be resolved, and if all else fails, add an entry 127.0.0.1 localho

AW: SapDB crash with a SELECT statement

2004-11-24 Thread Zabach, Elke
clovis_wichoski wrote: > > Hi, > > I'm using SapDB version Kernel 7.3.0 > Build 040-000-091-740, running on Linux. > > Today I attempt to execute the follow SQL: > > SELECT * FROM MoveType WHERE > id_sys LIKE 'VVP1%' AND > id_sys IN > ('VVP1','VVP2','VPP1','VPP2','SC') AND > type = 'S' AND > su

RE: Urgent: Emergency Shutdown -> Please Help

2004-11-24 Thread Hahn, Uwe
>-Original Message- >From: Andre Reitz [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 24, 2004 12:52 PM >To: Maxdb >Subject: Urgent: Emergency Shutdown -> Please Help > > >DATABASE: >- > sapdb 7.4.3.32 (RPM-Installation on SuSE 7.3) > >THE PROBLEM: > >knldiag.er

jdbc connection slowed part II

2004-11-24 Thread Marco Born
Hello, i checked the xserver_.prt file and found these lines: 2004-11-24 12:48:40 0xF3C ERR 18379 CONNECT Error getting TCP/IP host by address: '127.0.0.1' 2004-11-24 12:48:44 0xF3C ERR 18379 CONNECT Error getting TCP/IP host by address: '127.0.0.1' 2004-11-24 12:48:44 0x1A4

RE: Too many processes?

2004-11-24 Thread Döhr, Markus ICC-H
> I have one instance up in MaxDB 7.5.19 with MAXUSERTASKS = > 10, but I see 25 processes under linux... Is that normal? These are only the USERTASKS, the DB has some more itself (Servertask, Utilitytask...) > > Also, the DB is just started up and each process is 68MB in > size according to cl

Too many processes?

2004-11-24 Thread Zavier Sheran
I have one instance up in MaxDB 7.5.19 with MAXUSERTASKS = 10, but I see 25 processes under linux... Is that normal? Also, the DB is just started up and each process is 68MB in size according to cli command 'top'.. Thanks for any insight into that! -Zavier -- MaxDB Discussion Mailing List

Urgent: Emergency Shutdown -> Please Help

2004-11-24 Thread Andre Reitz
DATABASE: - sapdb 7.4.3.32 (RPM-Installation on SuSE 7.3) THE PROBLEM: knldiag.err: ... 2004-11-24 11:57:18 10816 ERR 11599 BTRACE /opt/sapdb/depend74/pgm/kernel 2004-11-24 11:57:18 10816 ERR 11599 BTRACE Frameinfo [0x40b43904] (0x40b43a44,0x9,0x401e30fc,0x4

jdbc connection slowed

2004-11-24 Thread Marco Born
Hello, i have a MaxDB 7.5.0.19 running, os is winxp. I made a backup and recovery with dbm gui of my maxdb instance. After restarting the database the connection-time increased dramatically. I use MaxDB through jdbc and Tomcat 4.1. The connection with SQL-Studio seems to be as fast as before. Reg