cancel
Showing results for 
Search instead for 
Did you mean: 

sdbfill.exe is failing to connect MAXDB instence on Windows2k8

Former Member
0 Kudos

1. I have MaxDB 7.7.04.30 installed on Windows 2008 x64 system.

2. Successfully created database named TESDB with the help of DBMGUI tool.

3. Trying to fill the data into TESDB using sdbfill.exe tool which comes with installation

While using sdbfill.exe i am seeing some issues:

================================================

C:\sapdb\7704\bin>sdbfill TESDB create 0 1000 10 0 a dbm dbm

Could not connect to TESDB with dbm,dbm.

SQL-Error: -4008.

SQLDBC: POS(1) Unknown user name/password combination.

================================================

dbm is Database manager operator with password dbm. This is a valid user name. i could able to do operations with dbmcli using the same credentails. Not sure why sdbfill is not accepting the credentials.

Are there any open issues with sdbfill.exe on windows2k8?

Am i missing any thing here?

Are there any logs where i can see what is happening?

Any kinda help will be appriciable.

Thanks & Regards,

Sivaram

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

Hi Azimir,

> 1. I have MaxDB 7.7.04.30 installed on Windows 2008 x64 system.

> 2. Successfully created database named TESDB with the help of DBMGUI tool.

> 3. Trying to fill the data into TESDB using sdbfill.exe tool which comes with installation

SDBFILL is a undocumented test tool for backup tool developments.

How do you come to use it ?

> While using sdbfill.exe i am seeing some issues:

> ================================================

> C:\sapdb\7704\bin>sdbfill TESDB create 0 1000 10 0 a dbm dbm

> Could not connect to TESDB with dbm,dbm.

> SQL-Error: -4008.

> SQLDBC: POS(1) Unknown user name/password combination.

> ================================================

> dbm is Database manager operator with password dbm. This is a valid user name. i could able to do operations with dbmcli using the same credentails. Not sure why sdbfill is not accepting the credentials.

You already found the answer yourself: DBM is a database manager operator.

It's not a SQL user.

Since the purpose of the tool is to load data into a dummy table to create either log entries or changed data pages, a SQL connection is required.

Use MONA,RED instead (if you've installed the DEMO schema), or DBA,DBA.

> Are there any open issues with sdbfill.exe on windows2k8?

It's not officially supported - so basically no users are using it... therefore: no idea, whether there are issues. But the message you got there is not an issue at all.

> Am i missing any thing here?

Yep, see above!

> Are there any logs where i can see what is happening?

Nope, it's not a enduser tool. It's a developer tool...

> Any kinda help will be appriciable.

Hope this helps.

regards

Lars

Former Member
0 Kudos

Hi Lars,

Thanks a ton for quick reply.

About this tool i got to from earlier devoloper (not sure about the origin).

After creating a DB user i could able to run sdbfill successfully.

Once again thanks a lot for ur quick help.

Thanks & Regards,

Sivaram