• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1496
  • Last Modified:

CANT Load database from server a to server B

Hi,
I have 2 Sybase servers 12.0.x
I want to reproduce a database from a to b
On ServerA:
Dump the database

sp_helpdb PROD

PROD      250

device    200
device_log 50

On ServerB:

Drop the database
create database PROD
on data=200
log on logdata=50
for load

when I load the database

load database PROD from "/tmp/PROD.dmp"

I got an error message :

Feb 21 12:19:36 2003: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Feb 21 12:18:55 2003: Backup Server: 6.28.1.1: Dumpfile name 'RSystem030510F652' section number 1 mounted on disk file '/tmp/PROD.dmp'
Feb 21 12:18:56 2003: Backup Server: 1.1.2.26: Memory allocation failed in bs_remap_runlist for a M_IO_LIST allocation.  This DUMP or LOAD session must exit.
Feb 21 12:18:56 2003: Backup Server: 6.32.2.3: /tmp/PROD.dmp: volume not valid or not requested (server: , session id: 104.)


I dont know whats wrong ?

thanks for the help
0
abidar
Asked:
abidar
1 Solution
 
abidarAuthor Commented:
I found the problem :O(((
It was because I was ftp using Binary instead of Ascii...

But I have another problem :
1> select u.uid,u.suid,u.name,l.suid,l.name from sysusers u, mast
2> where u.name=l.name                                          
3> order by u.suid                                              
4> go                                                            
 uid    suid   name                           suid              
         name                                                    
 ------ ------ ------------------------------ ------            
        ------------------------------                          
      4      5 nsa                                 5            
         nsa      



1> select u.uid,u.suid,u.name,l.suid,l.name from sysusers u, master..syslogins l
2> where u.name=l.name
3> order by u.suid
4> go
 uid    suid   name                           suid   name                          
 ------ ------ ------------------------------ ------ ------------------------------
      3    -99 Admin                            27 Admin                        
     
(2 rows affected)


How do I modify the suid

                                               
                                                                 
0
 
vka3Commented:
name column in sysusers is
"User or group name, unique in the database"
while name column in syslogins is a login name of the login.
Comparing Apples to Oranges !!
suid of -99 is probably for a group called 'Admin' withing database
while suid of 27 is suid of login Admin.
Not clear what you want to do !!
0
 
leonstrykerCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

Answered vka3

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

leonstryker
EE Cleanup Volunteer
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now