Recent content by icahn

Hi everyone, I have a HP VA7110 disk array connected to a Windows 2000 Server. At some time in the past the disks in the array have been accessible from 3 Red Hat Enterprise servers, but are now no longer available. By this I mean, booting up one of the 3 RHEL machines produces messages...

I need to migrate a production R11.5.9 instance on Solaris to a new server, and possibly, change the server hostname as well. What's the best (supported) way of doing this? All tiers on one server. I'd prefer not to use adclone as there are problems even with cloning into a test instance, let...

Hi all, When using Enterprise Manager to create a new user, I get Error 446: Cannot resolve collation conflict for equal to operation. (ODBC SQLState: 42000) and cannot continue. But I can use sp_adduser and sp_addlogin to do the job. Any ideas why EM gets this problem? tia.

Well, it's happening during office hours now! And no user can use any application running off our 40+ production databases, each time for 20 mins. Microsoft support suggest applying a hotfix 816840, which is not yet available for general distribution, just produces more diagnostics (ie...

How can I find out the collation sequence of an existing udb 7.2 database? Thx.

Recently, no users could login to our SQL Server 2000 SP3 instance. sqlserver.exe was taking 100% cpu and I was seeing these messages in the error log, The Scheduler 0 appears to be hung. SPID 75, ECID 0, UMS Context 0x398F5DB0. After 20 mins, the problem mysteriously corrected itself and...

The fault_sensor message went away after second power supply was connected (machine is dual fed).

After installing a Store Edge DDS4 external tape drive into a brand-new out of the box v280r running Solaris 8, I'm getting this in /var/adm/messages: [ID 961923 daemon.error] WARNING: Device PS1 failure detected by sensor PS1_FAULT_SENSOR Any ideas what's causing this? Also, the scsi id at...

Hi, I'm installing a 32GB disk and plan to use cplv to copy logical volumes in existing 8GB disks into the new one. The volume group built on the 8GB disks have PP Size = 16MB. The new disk will be put into a new vg with a larger PP size (not sure, perhaps 32MB). Is it possible to cplv -e lv1...

Not entirely off - topic. I use "sum" on Solaris to checksum files between production and standby instance: NAME sum - print checksum and block count for a file SYNOPSIS sum [-r] [file...] e.g. $ sum control.ctl 21182 491 control.ctl

Turkbear, What kind of problems with in-place migrations that you know of? I'm starting one from 8.1.6.3 to 8.1.7.4

Thanks for all the ideas! 1. The sample inserts I originally posted are incorrect as Terry pointed out. Should be, Insert ab values ('abdc', getdate()-10) not, Insert ab values ('abcd',datepart(wk, getdate() - 50)) Apologies for any confusion caused. 2. In the live system...

Thanks sguslan! Your suggestion works - remove the commit transaction and the batch update goes through. Would appreciate any tips on commit/rollback in sql server triggers.

In SQL Server 2000, I am trying to horizontally partition data into 2 tables using a check constraint on a datetime column as the partition key. The tables are unioned together by a view. There is no primary key in the base tables, so the view is not updatable. An instead-of-insert trigger is...

How can I stop the transaction log of our ASA 7.5 database from getting larger all the time? The timestamp in our .db file is unchaged since startup, only the .log file seems to be updated. Is this normal? The log file (123MB) is now larger than the db file (92MB). We do not shutdown for...