[EMAIL PROTECTED] wrote:
> I have used SAPDB version 7.4.03.31
> I used LEFT JOIN in SELECT statement.
> It was executed very fast because I had defined indexes on
> all column which
> taked part
> in LEFT JOIN.
> When I used EXPLAIN before SELECT in SQLStudio, it showed
> that all joins
> used
Hi,
Thanks for the detail information. It explains everything.
I've just tried on my machine, and it works perfectly as what you've described. It
seems even my old Linux 7.3. can support it (although my glibc is glibc-2.2.5-34 :)
After restart, if I do "ps -elf", i see a lot less processes (t
Hi,
while restoring a 7.5.05 backup on a different machine (both SuSE9.0) we're
running in troubles at the command "param_rmfile".
The error message is (from dbmsrv.prt):
=
ERR -24997 DBM ERR_FILE: file handling error
0x
You have to reinstall your database instance
what means that the log volume must be cleared
/ initialized with the old software version.
This is necessary because your log was written
with a new software version and this might cause compatibility problems.
- install the old software version
- rei
> my $session = new DBM ($server_node,$database_name,'XXX','XXX');
> my $state = $session->cmd("db_state");
> print "$state\n";
>
> doesent work!
Try
my $session = new DBM ($server_node,$database_name,'','XXX,XXX');
instead. The third parameter specifies a (useful if you want to
create a new d
[...]
> Summary: SQLs with LEFT JOINs on ver. 7.4.03.31 are executed
> faster than SQLs with LEFT JOINs on version 7.4.03.32.
Not necessarily.
> How can I resolve this problem. I will be grateful for all
> information and advices.
Have you updated the statistics? They are _not_ created/resto
Hi,
>
> > i am using MaxDB 7.5.00 on Linux Suse 8.1 with Perl 5.8.0.
> > I would like to manage the RDBMS via Perl and the
> > SAP::DBTech::dbm module.
> > After trying several times without success, perhaps this list
> > can help me :)
> > Why does this module use the perl malloc method and not t
Hi all.
I have used SAPDB version 7.4.03.31
I used LEFT JOIN in SELECT statement.
It was executed very fast because I had defined indexes on all column which
taked part
in LEFT JOIN.
When I used EXPLAIN before SELECT in SQLStudio, it showed that all joins
used indexes.
Total COSTVALUE IS: PAGECOUN
I'm used MaxDB version v 7.5.00.05 build 005-121-054-885
I'm try update my database 7.5.01.00 build 000-101-062-034 and I have Error
2004-03-30 21:08:10 0x8DC 51381 MIGRAT start of schema migration
2004-03-30 21:08:12 0x8DC 51381 MIGRAT migrating triggers
2004-03-30 21:08:12
Hi all,
Frédéric Demilly [mailto:[EMAIL PROTECTED] wrote:
>
> Yes, but in both case ( catalogextract and catalogload), i'm connected
> with dba. Only dba can do a catalogextract, and at the time of
> catalogloag there isn't any user created in the database ( except dba,
> of course ).
>
it's an
10 matches
Mail list logo
