| Author |
Changing IP on Solaris
|
|
| allan@magentatech.com.au 2005-05-26, 7:23 am |
|
I recently changed the IP address on a Solaris server. The interfaces
file was
edited and Sybase came up OK. However since the change I can not get a
database
dump to complete. Transaction dumps complete (we run them every 20
minutes) but
database dumps hang after a while.
The time it takes to hang varies. it could create a 700Meg file or a
1.8G file
before it hangs. I am thinking along the lines of there is some kind of
moitoring that is not working because of a connectivity problem.
Has anyone had this experience or know what the answer is.
Thanks
Allan
| |
| Anthony Mandic 2005-05-26, 7:23 am |
| "allan@magentatech.com.au" wrote:
>
> I recently changed the IP address on a Solaris server. The interfaces
> file was edited and Sybase came up OK.
How did you edit it? By hand or thru dsedit?
> However since the change I can not get a database dump to complete.
> Transaction dumps complete (we run them every 20 minutes) but
> database dumps hang after a while.
>
> The time it takes to hang varies. it could create a 700Meg file or a
> 1.8G file before it hangs. I am thinking along the lines of there is
> some kind of moitoring that is not working because of a connectivity
> problem.
Is your interfaces file in TLI format or in name/IP format?
Is the entry for Backup Server correct? Does sp_helpserver
output the correct information with respect to SYB_BACKUP?
Is there anything in the backup server's log?
-am © 2005
| |
| allan@magentatech.com.au 2005-05-26, 8:23 pm |
| Late last night I had a break through. Reconfiguring DBCC and running
checkstorage has now allowed the database dumps to run. I do not
understand this because I ran the checkstorage without the fix option.
I don't know if this still fixes some things but dumping the database
now works.
I ams still suspicious that the IP address change caused the problemm
but dbcc was not working. Maybe there was something that indicated a
dbcc needed to be done before dumping. Just guessing.
Thanks
Allan
| |
| Anthony Mandic 2005-05-26, 8:23 pm |
| "allan@magentatech.com.au" wrote:
>
> Late last night I had a break through. Reconfiguring DBCC and running
> checkstorage has now allowed the database dumps to run. I do not
> understand this because I ran the checkstorage without the fix option.
> I don't know if this still fixes some things but dumping the database
> now works.
>
> I ams still suspicious that the IP address change caused the problemm
> but dbcc was not working. Maybe there was something that indicated a
> dbcc needed to be done before dumping. Just guessing.
There was no error message in the logs? That would be
unusual but not unheard off. The last time I had a
problem anywhere close to resembling yours was with an
old 4.9.2 version where the dump process hung at the very
point where I'd extended a database.
-am © 2005
|
|
|
|