English 中文(简体)
Error在试图与第一期TIme数据库连接时
原标题:Error While trying to connect to DB2 SAMPLE database for the First TIme
  • 时间:2014-02-23 08:40:36
  •  标签:
  • database
  • db2

我想要在我的机器中安装用于学习目的的银2 UDW,但我有很困难的时间对当地情况进行组合。 任何帮助都将受到高度赞赏。

我安装了银2号特刊——c。 我选择了所有缺省选择。 我试图利用IBM数据室4.1连接,在“第2号步骤”中,全球倡议I选择建立SAMPLE数据库。 我正在发现以下错误:

Creating database "SAMPLE" on path "C:"... Existing "SAMPLE" database found... The "-force" option was not specified... Attempt to create the database "SAMPLE" failed db2sampl processing complete.

我利用以下备选办法试图从数据室连接起来:

Database- SAMPLE Port- 50000 host - localhost

顺便说一句,我正在getting。

Explanation: An attempt was made to access a database that was not found, has not been started, or does not support transactions. User response: Ensure that the specified database name exists in the system database directory. If the database name does not exist in the system database directory, either the database does not exist or the database name has not been cataloged. If needed, issue a db2start command and then resubmit the current command. SQL4499N A fatal error occurred that resulted in a disconnect from the data source. SQLSTATE: 08004

Problem is I am having zero knowledge in DB2. If I need to run db2start command from where I should run this? Please help

问题回答

或许没有开始审理。

一旦你安装了银二号,你就需要启动试验,以便使用任何数据库。 可以在安装时设立这种检查。 您可以通过以下方式核实贵国电脑中存在的情况:

/opt/IBM/db2/V10.1/instance/db2ilist

The output should give you a set of users, where an instance has been configured. You can change to that user and start the instance. For example if the user is db2inst1

su - db2inst1
db2start

Once the instance is started, you can now create a database and then connect to it.





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签