DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Closed Thread
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old September 23rd, 2006, 06:25 AM
beirti's Avatar
beirti beirti is offline
Contributing? HA!
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: In the office...
Posts: 244 beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Day 17 m 2 sec
Reputation Power: 19
Question New DB2 setup can't create a DB

Morning Guys,

Trying to teach myself bout Eclipse RCP and DB2 and set up both this morning on a WinXP Pro SP2 system. Installed DB2 with all the default and standard settings. Afterwards, I set up the SAMPLE DB and then went to create a database of my own and got the following error:

SQL0902C A system error (reason code = "") occurred. Subsequent
SQL statements cannot be processed. SQLSTATE=58005



Explanation:

A system error occurred.

User Response:

Record the message number (SQLCODE) and reason code in the
message.

If trace was active, invoke the Independent Trace Facility at
the operating system command prompt. Then contact your technical
service representative with the following information:

o Problem description

o SQLCODE and embedded reason code

o SQLCA contents if possible

o Trace file if possible.



Federated system users: isolate the problem to the data source
failing the request (refer to the problem determination guide to
determine which data source is failing to process the SQL
statement) and take the necessary diagnostic steps for that data
source. The problem determination procedures for data sources
vary, so refer to the applicable data source manuals.

sqlcode : -902

sqlstate : 58005

Reply With Quote
  #2  
Old October 2nd, 2006, 05:05 AM
beirti's Avatar
beirti beirti is offline
Contributing? HA!
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: In the office...
Posts: 244 beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level)beirti User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Day 17 m 2 sec
Reputation Power: 19
I have resolved this one. I ended up re-installing DB2.

Reply With Quote
Closed Thread

Viewing: Dev Shed ForumsDatabasesDB2 Development > New DB2 setup can't create a DB


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway