472,780 Members | 1,794 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,780 software developers and data experts.

Data Warehouse Center Question

I am receiving this error every time I try to access the Data Warehouse
Center Tutorial database TBC_MD.

DWC01007E Logon Failed. The database specified by the user does
not match the database used by the warehouse server.
RC = 1007 RC2 = 0

I first used First Steps to create the databases. I then dropped them
and used the command line as follows...

dwcsmp.exe db2admin db2admin c /t

It created successfully. I can see in the table vwuser that there is a
row for db2admin, but still everytime I try to open Data Warehouse
Center with the credentials, it fails with the above message. I can
open Data Warehouse Center with the same credentials but opening an
empty control database of DWCTRLDB. That works perfect and it looks
like the one row in its vwuser table is exactly the same as in the
TBC_MD table...

Any thoughts would be greatly appreciated.



Nov 12 '05 #1
0 1365

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: expecthealth | last post by:
JOB DESCRIPTION Data Warehouse Architect (Permanent, Full-Time) ______________________________________________________________________ _________ Position Description: The Data Warehouse...
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
by: ScottH | last post by:
I am running DB2 7.2 FP8e with the Data Warehouse Center (using Tivoli Data Warehouse). Everything was humming along fine. I defragged all my drives without bringing DB2 down (should have known...
by: M. Krafick | last post by:
I just took over a v8.1 database that is at Fixpack 2. I know that need to apply a later fixpack, probably FP6. My question is how does this affect Data Warehouse Center? I have heard that if...
by: DB2 DBA wanted | last post by:
Maines Paper & Food Service is a $2 billion/yr food distribution company with 9 distribution centers in the US. We are currently interviewing for the position detailed below. Relocation to...
by: Peter | last post by:
We have installed DB2 Data Warehouse manager on an AIX box. I must say it has been a frustrating struggle. Our current problem is getting the Cube View Control center running from the box using...
by: tony.pahl | last post by:
We are converting a data warehouse to a Unicode database to get ready for multilingual support. If we will have 95% of our data in English as we currently do, and less than 5% in other foreign...
by: David Harris | last post by:
Ok, so I'm semi-new to .NET, having done everything manually with SQL code back in VB6. So before I program this up completely manually again, I thought I'd ask for better ways to think through...
by: avbaby | last post by:
hi, i am using data warehouse center as an ETL. I have a remote database and a local database. i have to extract data from remote and put it in local database. remote database consists of complete...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.