Search results for query: *

Hi, we're trying to install mq5.3 on a win2003 machine but the install don't start, it asks for a fix pack 4. we've downloaded it from ibm web site but obviously we can't install it because we don't have a mq installation to patch ! How is it possible that you can't install mq because you miss...

Hi, we've got a machine with 2 disks Raid1 in the integrated controller partitioned in c: and d:. We would like to increase the size of the partition c: in order to achieve c: size equal to c+d size, in order to safely migrate that machine from WinNT to Win2003. It's possible to delete the d...

Hi, we've got a machine with 2 disks Raid1 in the integrated controller partitioned in c: and d:. We would like to increase the size of the partition c: in order to achieve c: size equal to c+d size. It's possible to delete the d partition but not the c one; the c partition is the boot...

As you can see by my profile I'm a System Administrator not a Manager, I'm not able to decide to buy the new version. What I can do is to refer to my manager that v5.2 (our actual ver) don't work with win Win2003, then if my manager ask to try to work with v5.2 against Win2003 I've to try...

Thanks for your answer. We know ibm support v5.3 on Win2003, we wuold like to try to use the v5.2, any experience about it ?

Hi, Are there any experience in installing mq v5.2 on a Win2003 machine ? that version officially support only WinNT and Win2000 ....

Hi, first of all sorry for this stupid question but, believe me, I'm going crazy to find the answer to this stupid question ! In my MS SQL Server 2K installation I'm unable to find some useful stored procedure as xp_sendmail, xp_cmdshell .... Where I can find them ? I thought they were...

I've solved. It was a bad version oci.dll in my path that I didn't know it was .... just deleted it and everything works fine ... thanks for your support

Hi, I've succesfully installalled tcl 8.4.4 on my win2000 machine and I'm tring to install oratcl 4.1 extension... I've launched install.tcl from my wish84 console and everything seems to work fine (I receive the msg: installaed succesfully...) but when I try to use this just installed...

Does anybody has experience in setting up a capacity planner/performance manager session ? Thanks for your support.

Hi, We're evaluating the possibility to use capacity planner and performance manager (either 2.0.4) to monitor and plan our system .... Does anybody has some suggest about the most important issues (on NT machine) to check? Any suggest also about check interval are welcome... Thanks for your...

Sem, Karluk thanks for your useful support; we're considering trasform this table in an index-organized one... If our performance test will be ok, we will proceed soon. Best Regards !

Sem, col5 is the first field of the pk ! Why does Oracle instead use the non-unique index to perform reads ? so your suggest is to change our optimize parameter, isn't it ?

Sem, we've just tried to follow this lineguide.... I'm trying to explain.... we 're working in RULE mode My table has 6 cols, for example col1,col2,col3,col4,col5,col6 its pk has these fields' order: col5,col6,col1,col4,col2,col1 (and isn't used for reads) its non-unique index has these...

Sem, I don't want to perform a sistematics FTS on this table (it's also a big table....) We have other indexes (unfortunatly non-unique) that help our statement to work properly....our consideration is about storage....we would like to save some disk space. This table is quite big and to have...

Sem, thanks for your answer. Our real aim is to eliminate the pk's index but not the constraint... creating an unique constraint means also Oracle create an unique index...and is what we would like to discard..... Is it correct that: creating an unique constraint Oracle create also an unique...

did02, thanks for your answer; our purpose is to replace a pk that is used only on constraint level (not used for reads....) we know that we can also solve this issue using a WHERE EXISTS clause but we want to perform a server-side check... we also know that using trigger is a complicated and...

Hi, we're trying to create a trigger to perform a check on existing rows in a table when an insert statement occurs... but we don't know how the external variables are passed to this procedure.... the code that provide that control looks like: create or replace trigger my_trigger BEFORE...

with this script you get date2=date1 - 1 day is it what you need ? If not you have to use the appropriate functions to manipulate date.....

I've tried with bcp utility but I get duplicated rows... with ms sql 6.5 I don't have the query option, so I can export or import the entire table and not a portion of it... this is my script: bcp "dbname.owner.tablename" in/out "datafile" -c -E -U"my_user&quot...