Solved

Sybase ASE 12.5.4 load database unexplained output

Posted on 2011-09-28
5
887 Views
Last Modified: 2012-08-13
Hello,

I have an archive database server that contains bunch of archive databases on a single Sybase ASE 12.5.4 instance. This instance has been up & running for over a year and in production with no issues. This ASE instance doesn't run anything special such as HA/Replication and the configuration is as basic as it can get. What I'm seeing is after I dump a database and load it onto another ASE instance(same version/os/nothing special) I see the output shown below.

The database 'archivedb01' is currently not available and cannot be checked for
cross-database encryption key references for the keys existing in database
'archivedb02'.


To sum up the messages above... archivedb01 was a recently loaded database dump(never online'd yet) from the archive database server. When I go to load the next archival database(archivedb02) that message appears. If I were to continue loading the remaining archival databases the message continues to grow.

The database 'archivedb02' is currently not available and cannot be checked for
cross-database encryption key references for the keys existing in database
'archivedb06'.
The database 'archivedb03' is currently not available and cannot be checked for
cross-database encryption key references for the keys existing in database
'archivedb06'.
The database 'archivedb04' is currently not available and cannot be checked for
cross-database encryption key references for the keys existing in database
'archivedb06'.


If I online these database and continue to load these dumps the message disappears. I've tried loading them on a different ASE instance and the message still appears. I'm out of ideas and I'm beginning to think this message is just there to waste my time and make me worry over nothing. I've googled, searched sybase, and I can't turn up anything about this message. Anyone have any idea what this message is getting at and if it's a concern?

Thanks.

0
Comment
Question by:xtrusion0
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:rbride
ID: 36813470
If I online these database and continue to load these dumps the message disappears

You have said it yourself. You always need to online the database after it has been loaded to make it available. The reason you need to explicitly online the database is that you have the option of loading transaction logs before making the DB online.

[http://manuals.sybase.com/onlinebooks/group-as/asg1250e/refman/@Generic__BookTextView/63290;pt=28072/*]
0
 

Author Comment

by:xtrusion0
ID: 36813608
Rbride -- thanks for the quick response, but that doesn't explain the error though. My real concern is the integrity of that data. I've dealt with sybase for roughly 5 years and I've never seen that message. In a sense, when have you online'd a database and it referenced other databases? That's my puzzle.
0
 

Author Comment

by:xtrusion0
ID: 36813623
Sorry, didn't mean to say online, but instead reference these other databases when loading an entirely different dump.
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 36889965
If there are any cross-database references - check constraints, referential integrity, triggers, or (apparently) encrytion keys, ASE tries to follow the link during load database.

Your issue is that there are links in archivedb02 to archivedb01, and so on, and these can't be checked because the earlier databases aren't online yet (via online database command).

Basically it's just a warning. If these are copied directly from another environment where all the databases are online and regularly dbcc'ed, you can ignore this. Or, if you are just doing full database loads and no transaction loads, you can just immediately online each database after it's been loaded and you won't see these messages.
0
 
LVL 4

Expert Comment

by:rbride
ID: 36890188
Now I understand: I agree with Joe Woodhouse.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question