RE: Again ignore trigger after update

Hi, I don't think you can conditionally by-pass firing trigger. But you should be able to achieve similar result by "conditionally" let the trigger does nothing. Here's an example. Let's say I have a CONTROL_TABLE with a single column FLAG If Flag = 0, fire trigger as normal If Flag = 1, no

RE: Script to create instance with dbmcli

Hi, This is the one I use. For your reference. # # mydb is the target instance name # dbmcli db_create mydb dbm,dbm # # Tune the configuration for your purpose # dbmcli -d mydb -u dbm,dbm

RE: dbmcli db_create executable program not accessible

Have you tried not to use -R with the db_create command? How about as plain as dbmcli db_create $SID dbm,dbm dbmcli -d $SID -u dbm,dbm -i ... Just my 2c... -Original Message- From: John L. Singleton [mailto:[EMAIL PROTECTED] Sent: 2004?4?7? 5:13 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTE

RE: Performance problem after upgrading to 7.5.0.8

a lot less processes (threads). Hope it works well. Thanks again. Andy -Original Message- From: Mensing, Joerg [mailto:[EMAIL PROTECTED] Sent: 2004?4?1? 15:39 To: Andy Chan Cc: Franki Cheung; Jason Cheng; [EMAIL PROTECTED] Subject: RE: Performance problem after upgrading to 7.5.0.8

RE: Performance problem after upgrading to 7.5.0.8

Hi, Thanks for the sharing. I've checked my Linux installation, and discovers the parameter is default to NO. The machine is running RH7.3 with kernel 2.4.18-3, and glibc version 2.2.5. My Q is: How do I know whether I can enable USE_COROUTINES ? What's the impact if I enable it where it

RE: loader (loadercli) with .sql file

Hi Niraj, ".sql" file contains SQL statements? If so, use sqlcli. After going into sqlcli, use \i to specify your input SQL file. Hope this helps. Regards, Andy -Original Message- From: Shah, Niraj [mailto:[EMAIL PROTECTED] Sent: 2004?3?24? 2:42 To: MaxDB (E-mail) Subject: loader (lo

RE: Question About Locks?

Hi Jose, >From my test on MaxDB 7.5.0.8, your desired behavior can be "partially" achieved by >using isolation level 15. I mean "partial" because when T1 attempts DML (Insert, Update, Delete) later - to the "locked" row or other rows, to the same table or other tables - there is an automatic l

RE: Loader error (-25301)

Hi Elke, You're right. I default my sqlcli session to ORACLE mode. I've tried that with INTERNAL mode, and can see it is TIMESTAMPS. Thanks for your advise. Cheers, Andy -Original Message- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: 2004?3?15? 17:17 To: Andy C

RE: Loader error (-25301)

:[EMAIL PROTECTED] Sent: 2004?3?12? 20:39 To: MaxDB digest (E-mail) Subject: Re: Loader error (-25301) Le vendredi 12 mars 2004, Andy Chan a écrit... bonjour, > date '-mm-dd' wouldn't: DATE ISO be better ? -- jm -- MaxDB Discussion Mailing List For l

Loader error (-25301)

Hi, I'm new to MaxDB loader, and stuck in importing simple data into table. I'm using MaxDB 7.5.08 on Linux. Appreciate if anyone can help me out. Table structure = Table "SCOTT.SYS_PARAM" | Column Name | Type | Length | Nullable | KEYPOS | | --

RE: removing data-volumes

i once found myself first removing the volume (definition only) and re-catalogue it. i.e. param_rmfile param_addvolume (add only those needed) not too sure this is a right approach though Cheers, Andy -Original Message- From: Steffen Fiedler [mailto:[EMAIL PROTECTED] Sent: 2004?3?2?

RE: Error when recovering logs

s told me that this is bug -Original Message- From: Brunzema, Martin [mailto:[EMAIL PROTECTED] Sent: 2004?2?23? 16:21 To: Andy Chan; [EMAIL PROTECTED] Subject: RE: Error when recovering logs Hi Andy, > -Original Message- > From: Andy Chan [mailto:[EMAIL PROTECTED] > Sent: F

Backup & Recovery Qs [RE: Error when recovering logs]

en trying for days, but I'm completely blocked in the above areas. Any pointer is highly appreciated! Many thanks Andy -Original Message----- From: Andy Chan Sent: 2004?2?20? 19:41 To: Heinrich, Tilo; [EMAIL PROTECTED] Subject: RE: Error when recovering logs Thanks a lot! I've s

RE: Error when recovering logs

ug is a 5 year old classic, that was fixed only last week. So in the next version you will get something like "ERR -24990,ERR_NOBACKUPSESSION: no backup session available", if you use recover_replace again without a previous recove_start. Best Regards, Tilo Heinrich SAP Labs Berlin

RE: Error when recovering logs

ting through is valuable to my learning. I'm more than happy to share the step-by-step guide to anyone in need. :> -Original Message- From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED] Sent: 2004?2?19? 19:05 To: [EMAIL PROTECTED] Subject: Re: Error when recovering logs Le j

RE: Error when recovering logs

hurdle to overcome in this backup-recovery stuff, please help me once more! One further question, now the log sequence comes out like log.ARC.001, what happen why I have more than 999 logs? Would that cycle back to 001 ? -Original Message- From: Andy Chan Sent: 2004?2?19? 17:00

RE: Error when recovering logs

TL -c recover_start archivelog 2 ERR -24988,ERR_SQL: sql error -71,connection broken server state 6 Oops... any thought? Thanks a lot Andy -Original Message- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: 2004?2?19? 16:23 To: Andy Chan; Jean-Michel OLTRA; [EMAIL PROTECTED] Subject: RE:

RE: Error when recovering logs

. -Original Message- From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED] Sent: 2004?2?19? 15:50 To: [EMAIL PROTECTED] Subject: Re: Error when recovering logs Le mercredi 18 février 2004, Andy Chan a écrit... bonjour, > During the process, I also wonder why the Log volume LOG_

RE: Error when recovering logs

Anyone can give me a pointer? If on the other hand, I keep updating the slave instance (sdb2) by asserting incremental data backup from master (sdb1) ? Would I need to restore log backup at all - of course expecting data loss ? -Original Message- From: Andy Chan Sent: 2004?2?18? 17:14

RE: Error when recovering logs

lace? And how should I proceed the recovery ? P.S> No further information from dbm.utl or knldiag. Thanks very much for helping. I'm determine to get this done very soon ... Andy -Original Message- From: Andy Chan Sent: 2004?2?18? 9:21 To: Hahn, Uwe Cc: [EMAIL PROTECTED] Subje

RE: Error when recovering logs

instance needs to be down for such copy? I'll try anyway, but worry in real life the integrity will be broken. Regards, Andy -Original Message- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: 2004?2?17? 23:04 To: Andy Chan Cc: '[EMAIL PROTECTED]' Subject: RE: Error when r

RE: Error when recovering logs

connection broken server state 6 --- dbmcli on sdb2>db_state OK State OFFLINE --- -Original Message- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: 2004?2?16? 20:35 To: Andy Chan; MaxDB digest (E-mail) Subject: RE: Error when recovering logs Hi Andy, in your example the number 1024 of

RE: Error when recovering logs

archivelog |24| 1| 0|| -Original Message- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: 2004?2?16? 19:15 To: Andy Chan; MaxDB digest (E-mail) Subject: RE: Error when recovering logs Hi Andy,

Error when recovering logs

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

dbmcli: hss_ commands

Hi all, Does anyone know where I can find some documentation/hint to use the hss_ commands in MaxDB 7.5 dbmcli interface? I've searched through the standard documentation, but can't anything related. Since I install the db on Linux, I don't have the easy Windows interface to build a hot stan

RE: sqlcli always fail with -4008 but websql okay ?!

Hi Marco, Magic!! Your suggestion works. Thanks a lot. Regards, Andy -Original Message- From: Paskamp, Marco [mailto:[EMAIL PROTECTED] Sent: 2004年2月12日 19:57 To: Andy Chan; MaxDB digest (E-mail) Subject: RE: sqlcli always fail with -4008 but websql okay ?! Hi, in older versions of

sqlcli always fail with -4008 but websql okay ?!

Hi all, I've create a RESOURCE sql user "scott" via websql using "create user ...". Then I can create tables and do normal select as usual logging in as "scott". Unfortunately, this only limits to using websql. Every time I use sqlcli, I get the following error: sqlcli -d mydb -u scott,tiger

Get stuck in recover_config then fail to build standby

Hi all, In following the documentation to set up a Homogenous System copy, I hit the following error and would like to get some help from the gurus. Prod instance = prod (running) Stand-by instance = stby Platform = Linux dbmcli -d prod -u dbm,dbm medium_put databasecopy /u01/prod_copy FILE DA

How to create a hot standby via dbmcli ?

Hi all, I've been using Oracle for long but a newbie to MySQL/MaxDB. I'd like to create a hot standby on Linux platform. I've been following the documentation but not getting very far before I get stuck (about mid-way through creating the homogenous copy). Would be very appreciate if someone