Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    dayton, ohio
    Posts
    24

    Question Unanswered: create database problem

    I have created a new database, created all the segments in order, onlined the database, and when i do a load database it says there is no room in the database. Could someone please tell me what i am missing..
    thanks so much for any input.

  2. #2
    Join Date
    Sep 2006
    Posts
    15
    If I load a DB and don't know the required size of the database, I usually create a dummy database of 2mb and load the dump on that dummy db. The backup server will complain and will report the required size of the dump db. Then you can create a database based on the required size.

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You don’t need an online database for the load
    just check that your target database is the same size as the one from the dump
    e.g.
    Code:
    load database tempdb from "compress::/bkp1/mydb.dgz" with headeronly
    Look for
    Database page size is 4096.
    Database contains 10240 pages
    Now calculate the required size
    Code:
    select 4096./1024/1024*10240
    
    ---------------------------------------- 
                    40.0000000000000000000000
    Ideally you need to know the original layout for log and data but this will not stop the load if incorrect
    e.g. on ASE 12.5.3 Check original layout (segmap 4 is log only, other is data)
    Code:
    select dbid,segmap,'sizeMB'=convert(int,size*(@@maxpagesize/1024./1024))
    ,'devname'=name 
    from sysusages, sysdevices 
    where dbid=db_id('mydb')
      and sysusages.vstart between sysdevices.low and sysdevices.high
    order by lstart
    
     dbid   segmap      sizeMB      devname                        
     ------ ----------- ----------- ------------------------------ 
          5           3          10 mydb_d1                        
          5           4           5 mydb_l1                        
          5           3          10 mydb_d2                        
          5           3          10 mydb_d2                        
          5           4           5 mydb_l1                        
    
    (5 rows affected)
    create your db with similar data/log groups
    Code:
    disk init name='mydb_d1',physname='/d1/mydb_d1.dat',size='30M',vdevno=15
    disk init name='mydb_l1',physname='/d2/mydb_l1.dat',size='10M',vdevno=16
    create database mydb on mydb_d1=10,mydb_l1=5,mydb_d1=20,mydb_l1=5 for load
    load and check layout using previous select

    Code:
    load database mydb from "compress::/bkp1/mydb.dgz"
    online database mydb
    
    dbid   segmap      sizeMB      devname                        
     ------ ----------- ----------- ------------------------------ 
          5           3          10 mydb_d1                        
          5           4           5 mydb_l1                        
          5           3          20 mydb_d1                        
          5           4           5 mydb_l1                        
    
    (4 rows affected)

  4. #4
    Join Date
    Jul 2002
    Location
    dayton, ohio
    Posts
    24
    I have matched the two database exactly and in order, segment and size all match. I can type in the load database command and it just sits there, nothing ever loads, i have done this several other times and it takes about 20 hours to load the DB over the network, its a 70G DB, which is all fine, the problem is that nothing is loading...
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •