Hi Stephen,
User DBA connected to database MYDB1 on local host.
DBEXTRACT CATALOG OUTSTREAM FILE 'extract-catalog'
DATA OUTSTREAM FILE 'extract-data'RECORDS UCS2
you have to specify the encoding UCS2 if you want extract a unicode database.
Hans-Georg Bumes
-Original Message
I can not get the Solaris Sparc system to import the data created with loadercli
DBEXTRACT PAGES. This is with the same version of MaxDB
(7.5.0.8) on both Windows XP and Solaris 8. I have tried it remote (using Windows XP
loadercli with node parameter) and local (using scp to
copy file to s
José Rómulo Elías Contreras wrote:
>
> How can I do an update of a table usign values from different
> tables to
> set it?
>
Use subqueries like this:
UPDATE t SET a = (SELECT col FROM base)
Elke
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxd
'Jean-Michel OLTRA' wrote:
>
...
> > And this you want to do in a dbproc or (with version 7.5.1)
> in a user defined function?
>
> yes. But why 7.5.1 ? Isn't 7.5.0.8 aware of user functions ?
>
As Thomas wrote:
http://lists.mysql.com/maxdb/19753
They are implemented, but not tested and cont
Hi,
Alex wrote:
>>A NT Service runs under an administrative account and=20
>>periodically connects to the SAP DB which is installed on
>>the same machine.
>>Sometimes ODBC::connect fails with an Application Popup (!)=20
>>with the message:
>>"sqlcreatetls [F=FCr diesen Befehl ist nicht gen=FCgend S
Thanks for the explanation which has brought me out of the mist.
However, I'm still not able to start the recovery even I specify log 2 :_(
% ls -lL /home/sdb/archive
total 3788
-rw-rw1 sdb sdba 3342336 Feb 16 17:29 log.ARC.001
-rw-rw1 sdb sdba 262144 Feb 16
I believe I already know the answer to this, consider it a feature request :)
I would like to see if there is a way to make loadercli or backup work so that data is
streamed directly from one MaxDB server into another :)
Even if the data is Endian reversed (sparc vs. i386)? In other words,
Hello,
Using these commands:
DBEXTRACT CATALOG OUTSTREAM FILE 'extract-catalog'
DATA OUTSTREAM FILE 'extract-data' PAGES
I am creating an extract from Windows 2000 / Windows XP. Intention is to import into
a Solaris 64-bit system. What concerns me is the use
of the "PAGES" pa
Hi,
We have a windows 2000 server, service pack 4. 2GB of RAM. MaxDB 7.5.0BUILD
005-121-054-885.
The MaxDB server stopped responding, even to local dbmcli commands. I did a db_cold
and db_warm and it resumed normal operation.
Reviewing the kernel error log, during the error time per
Strahl, Torsten wrote:
Hi,
the error you get from the database structure check means that
you have a corrupted secondary tree (index) which is identified
by the root page number 34659. At least one of the index records
has a corrupted key length. You should check your hardware and after
that drop
José Rómulo Elías Contreras wrote:
How can I do an update of a table usign values from different tables to
set it?
You can do a INSERT ... SELECT ... UPDATE DUPLICATES.
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http:
Filip Sergeys wrote:
Hello,
Are cursors unique to a session? I have some stored procedures that
returns a cursors, The cursor has a fixed name. If the same procedure
get executed twice (or more) times at the same time will it get mixed
up?
Cursors are unique, so you can use fixed names in stored
Joao wrote:
Using ODBC the connection time to this database is about 2 minuts some
parts of software are frequently open and close database connection because
those parts are independent EXE's.
The Connection Time in MS SQL Server is less than a minut, like Informix,
DB2 , Oracle, Firebird and
Alexio Cassani wrote:
Hi,
I've found that SapDB doesn't provide any kind of replication feature (since
1997).
Is this right?
Yes. Such a feature is currently being implemented, but a release date
hasn't been set.
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
--
MaxDB Discu
The value is string, picked with SUBSTR from a key whose format is
-seqNumber.
bad design i would say.
just put the key in 2 seperate columns, one for the "" and one for
the seqNumber.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http
Le lundi 16 février 2004, Zabach, Elke a écrit...
bonjour,
> now it depends, if the seq_Number has to have leading '0' within the new key
> or not
> substr(oldkey, 1, 4) ||
> lfill (ltrim(chr(fixed (num(substr(oldkey, 5)) + 1, n, 0))) , '0', 7)
> should result in a 11-char new-key wi
Hi,
Does anyone have experience to share about trying to get DATA_CACHE as high as
possible on Solaris 8 (SunOS 5.8)? I have a Sun Blade 1000 with
8GB of RAM (64bit Sparc). No other application is hosted on this system, only MaxDB
for a single database instance.
I have no prior Solaris ex
How can I do an update of a table usign values from different tables to
set it?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi,
i have a rather nasty problem on a Windows 2000 Advanced
Server running SAPD DB "KERNEL 7.4.3 BUILD 027-123-048-452":
A NT Service runs under an administrative account and
periodically connects to the SAP DB which is installed on
the same machine.
Sometimes ODBC::connect fails with an Applic
Hello,
Are cursors unique to a session? I have some stored procedures that
returns a cursors, The cursor has a fixed name. If the same procedure
get executed twice (or more) times at the same time will it get mixed
up?
Second question:
Is there a way to declare an empty cursor and populate it wi
> But than, after now two years of training I can even
> recommend the SAP DB Reference Manual. And I remember very
> well how much I swore on that thing the first months :))
This gives me hope :-)
Matthias
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To
Hi,
> the biggest advantage of Stefan Wichmann's book is that it is
> available. Are there other books?
>
> Personally, I do not like this book (yet). I bought it late last year.
> I find the structure unclear, chapters too long, convoluted
> sequence of items.
> What annoys me most is the large
Hmmm,
the biggest advantage of Stefan Wichmann's book is that it is available.
Are there other books?
Personally, I do not like this book (yet). I bought it late last year.
I find the structure unclear, chapters too long, convoluted sequence of
items.
What annoys me most is the large amount of ref
Ertan Kucukoglu wrote:
>
> Dear All,
>
> I am trying to convert our production Firebird database to
> SapDB. During
> the conversion, I see that there is no "computed sources" in
> SapDB. At
> least I could not find any.
>
> My firebird table is like:
> create table abc (
> snipped ...
'Jean-Michel OLTRA' wrote:
>
>
> Le lundi 16 février 2004, Zabach, Elke a écrit...
> bonjour,
>
>
> > > sqlcli TROUPEAU=> SELECT CHR(NUM('1')+1) FROM DUAL
> > NUM(number) is of no use.
> > Try CHR ( FLOAT(1, n) + 1) FROM DUAL
> > with n being a number between 1 and 38 according to your
Dear All,
I am trying to convert our production Firebird database to SapDB. During
the conversion, I see that there is no "computed sources" in SapDB. At
least I could not find any.
My firebird table is like:
create table abc (
snipped ...
piece double precision not null,
price double prec
Hello,
backups are platform dependent means that the only safe and suggested way for using
a backup is restoring it on the same OS/hardware platform.
Everything else may or may not work, although chances are 'better' if the architecture
is very similar as Linux and Windows due to the fact they
> Thanks for your document, very interesting reading.
> in restore section have noticed this :
>
> *Pitfall:* Backups are platform-dependent. You can not
> restore a backup
> from a UNIX or LINUX database instance on a Windows host.
>
> please note I restored my backup made under windows versio
Le lundi 16 février 2004, Zabach, Elke a écrit...
bonjour,
> > sqlcli TROUPEAU=> SELECT CHR(NUM('1')+1) FROM DUAL
> NUM(number) is of no use.
> Try CHR ( FLOAT(1, n) + 1) FROM DUAL
> with n being a number between 1 and 38 according to your needs.
The value is string, picked with SUBST
Hi Djebran,
thank you for your comment. My remark about the platform-dependecy
of the backup dates back to the 7.3 version. I tried than, and
failed, and was told that the backup is not portable. Since then
I didn't try anymore.
Looks like this is no longer correct, I removed the remark and
updat
Le lundi 16 février 2004, Hahn, Uwe a écrit...
bonjour,
> in your example the number 1024 of your data backup is the sequence number which
> must be found in the set of log backups. And Log Backup 2 contains it.
> So you have to start the log recovery with log backup 2.
> 0- 1021 l
Thanks for your document, very interesting reading.
in restore section have noticed this :
*Pitfall:* Backups are platform-dependent. You can not restore a backup
from a UNIX or LINUX database instance on a Windows host.
please note I restored my backup made under windows version of sapdb to
sap
Oops! Sorry, this shouldn't have been relayed to the list.
/gustav
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Kære Karoline
Det er i otte kategorier!
/gustav
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Andy,
in your example the number 1024 of your data backup is the sequence number which must
be found in the set of log backups. And Log Backup 2 contains it.
So you have to start the log recovery with log backup 2.
0- 1021 log backup 1
1022 - 1029 log backup 2 <= 1024 for data backup
Hi,
for all of you who are interested in some bedtime lecture
on our beloved database:
1) the "Book SAP DB / MaxDB" from Stefan Wichmann
If you speak german, get it. This book is very helpfull.
It gets you started as a beginner and is also pretty good
as a reference manual. Thanks, Stefa
Hi Markus,
nice to read your success story. We are also very happy
with our sapdb for two years now. About 30 installations,
ranging from 4 to 2000 users. This thing is just awesome.
We compiled a documentation dealing with Installation and
Administration under Windows and Linux. The guys from SA
Didnt get a reply so reposting.
I could reproduce the problem with odbc 7.4
Regards,
Ajit
Hi,
I just took the latest available ODBC driver for 7.3 from the sapdb.org
site. I think it said 7.3.0.35 when I updated my existing driver.
My program just runs in a loop creating connections and disconne
Hi Uwe,
Thanks helping. Are you saying I should check the recovering instance's dbm.knl ?
If so, I only see one line. Which part should I pay attention to?
% cat /home/sdb/sdb2/dbm.knl
403091320001|DAT_1|RESTORE |2004-02-16 17:26:51|2004-02-16 17:26:51|2004-02-16
17:45:28|2004-02-16 17
Hello Andy,
> -Original Message-
> From: Andy Chan [mailto:[EMAIL PROTECTED]
> Sent: Montag, 16. Februar 2004 09:32
> To: Montag, Marina
> Subject: RE: dbmcli: hss_ commands
>
> > Hi Marina,
>
Marina asked me to do her the favour to answer your questions. I hope to clarify some
things
Hi Andy,
after data recovery you have to choose the correct log backup to recover it. This can
be done with the help of the file dbm.knl. There you will find a sequence number for
the data backup which has to fit into the interval of a log backup.
If the first log backup during log recovery is
Hello,
I Have a big problem
I've installed a SAPDB Database v 7.4 in AIX system.
Using ODBC the connection time to this database is about 2 minuts some
parts of software are frequently open and close database connection because
those parts are independent EXE's.
The Connection Time in MS SQL
Good Morning List !
I'm working now with MAXDB for about 1 Month and i'm very happy about this nice
database :)
I've written an Online-Software for Transaction Processing with many Modules based on
a LAMP Environment. After installing my Software on a Dual-Xeon 2.4 GHz Machine with
2x 155MBit
Hi gurus,
On a Linux host running MaxDB 7.5.0 same machine, I've attempted to test out a typical
backup & recovery scenario.
Master instance (sdb1)
Standby instance (sdb2) - to be built from the backup of sdb1
The following steps are executed:
dbmcli -d sdb1 -u dbm,dbm
> medium_put fullbackup
Hi,
I've found that SapDB doesn't provide any kind of replication feature (since
1997).
Is this right?
TIA
Alexio
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jean-Michel OLTRA wrote:
>
> bonjour,
>
> Is there a way, with MaxDB functions, to convert string into integer:
> As un example:
>
> sqlcli=> SELECT CHR(NUM(1)+1) FROM DUAL
> | EXPRESSION1 |
> | --- |
> | 2 |
> 1 row selected (3 msec)
>
> sqlcli TROUPEAU=> SELECT CHR(NU
Hi,
> My questions are:
> - What exactly is "Oracle Mode"?
Using the "Oracle Mode" MaxDB supports "Oracle Version 7" syntax and behaviour. For
details see:
http://www.mysql.com/documentation/maxdb/81/ee4d3c596f0b26e1000a11402f/content.htm
> - How do I enter "Oracle Mode"?
> - I'm using JDBC.
On Mon, 2004-02-16 at 09:09, Yonatan Taub wrote:
> I've got two tables which have a lot of data in them (about 1,100,000).
> The deletion process takes about 15 minutes which is way too long.
> "DROP TABLE" is not an option for me so I was looking at alternatives.
> The "TRUNCATE TABLE" seems to be
Hello
I have some problems backing up to Network shares with SAPDB 7.3.0.40. The
backup to mapped drives takes 3 times longer than backing up to the local
machine. Both machines are Compaq ML 570 servers. All other file copy
operations like copy and xcopy work okay (and faster) between these 2
mac
bonjour,
Is there a way, with MaxDB functions, to convert string into integer:
As un example:
sqlcli=> SELECT CHR(NUM(1)+1) FROM DUAL
| EXPRESSION1 |
| --- |
| 2 |
1 row selected (3 msec)
sqlcli TROUPEAU=> SELECT CHR(NUM('1')+1) FROM DUAL
| EXPRESSION1
I've got two tables which have a lot of data in them (about 1,100,000).
The deletion process takes about 15 minutes which is way too long.
"DROP TABLE" is not an option for me so I was looking at alternatives.
The "TRUNCATE TABLE" seems to be faster since it doesn't do any logging.
However, I under
51 matches
Mail list logo
