SQL1013N The database alias name or database name "FCS" could not be found

[Former Member]

Hi All,

Solution manager is running on win2003 server with db2 database.When i m trying to connect db2 from command promt i m getting error.I m following these step.

1.Loging with db2 user

2.In command promt when i m tring to check the cfg file getting error.

DB2 get db cfg for fcs.

SQL1013N The database alias name or database name "FCS" could not be found.

SQLSTATE=42705

I m pasting the snapshot of of database manager.

C:\>db2 get snapshot for dbm

Database Manager Snapshot

Node name =

Node type = Enterprise Server Edition with

local and remote clients

Instance name = DB2

Number of database partitions in DB2 instance = 1

Database manager status = Active

Product name = DB2 v9.1.600.703

Service level = s081007 (WR21415)

Private Sort heap allocated = 0

Private Sort heap high water mark = 0

Post threshold sorts = Not Collected

Piped sorts requested = 0

Piped sorts accepted = 0

Start Database Manager timestamp = 07/29/2010 11:35:25.534766

Last reset timestamp =

Snapshot timestamp = 08/03/2010 18:43:14.492590

Remote connections to db manager = 0

Remote connections executing in db manager = 0

Local connections = 0

Local connections executing in db manager = 0

Active local databases = 0

High water mark for agents registered = 2

High water mark for agents waiting for a token = 0

Agents registered = 2

Agents waiting for a token = 0

Idle agents = 0

Committed private Memory (Bytes) = 11141120

Switch list for db partition number 0

Buffer Pool Activity Information (BUFFERPOOL) = OFF

Lock Information (LOCK) = OFF

Sorting Information (SORT) = OFF

SQL Statement Information (STATEMENT) = OFF

Table Activity Information (TABLE) = OFF

Take Timestamp Information (TIMESTAMP) = ON 07/29/2010 11:35:25.534766

Unit of Work Information (UOW) = OFF

Agents assigned from pool = 2542

Agents created from empty pool = 4

Agents stolen from another application = 0

High water mark for coordinating agents = 2

Max agents overflow = 0

Hash joins after heap threshold exceeded = 0

Total number of gateway connections = 0

Current number of gateway connections = 0

Gateway connections waiting for host reply = 0

Gateway connections waiting for client request = 0

Gateway connection pool agents stolen = 0

Memory usage for database manager:

Memory Pool Type = Database Monitor Heap

Current size (bytes) = 65536

High water mark (bytes) = 65536

Configured size (bytes) = 327680

Memory Pool Type = Other Memory

Current size (bytes) = 10092544

High water mark (bytes) = 10092544

Configured size (bytes) = 4292870144

KIndly suggest me where i m getting wrong.

REgards

[Former Member]

thanks

[Former Member]

Dear Sir,

We're also facing same problem, weve installed DB2 9.5 FP5 on Windows 2008 R2. From last three months systems running without any issue. But right now when we're trying to configure the backup with "Netvault" we're facing this issue. Kindly please guide me what all steps you performed to resolve the same.

Since we've changed the parameter in DBACOCKPIT for LOGARCHMETH1 to Logretain & after that when we've restarted the machine db could not get connected & in WP Developer trace it is showing "Backup pending"

Kindly Please help us to resolve this issue!!!!

Regards

DB2User

[Former Member]

If backup pending, then make an offline backup to DISK since your backup device is not working.

If you want to skip backup, then use following command

db2dart <dbname> /CHST /WHAT DBBP OFF

reference

[Former Member]

Dear Sir,

Thanks for quick response; is there requirement to stop the DB2 services to excute DB2DART?

Thanks

[Former Member]

Dear Sir,

Please check the DB2DART log

"

Command line output:

C:\Users\Administrator.MAXXMOBILEDLH>db2dart db2smn /CHST /WHAT DBBP OFF

DB2DART Processing completed with error!

Complete DB2DART report found in:

C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\DART0000\DB2SMN.RPT

db2smn.rpt:

Error: Failed sqledosd API on open system database directory.

SQL1057W The system database directory is empty.

Error: This phase encountered an error and did not complete.

______________________________________

DB2DART Processing completed with error!

WARNING:

The inspection phase did not complete!

______________________________________

Complete DB2DART report found in:

C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\DART0000\DB2SMN.RPT

_______ D A R T P R O C E S S I N G C O M P L E T E _______"

Please help me to sort out this issue!!

Our Solution Manager is down.

Regards!!!

[Former Member]

Hello db2user,

you will take the SID (database-name) for the db2dart command:

db2dart <SID> ...

Best regards,

Joachim

[Former Member]

Still the same output from DB2DART.

[Former Member]

Your error is not "dbatabase pending"

but > SQL1057W The system database directory is empty.

check and make sure the db is there. or drop and recreate db.

[Former Member]

Dear Sir,

db2ilist output is

DB2SMN

DB2

I'm bit confused with output

& I never tried for DB2 instance drop or cretae ever.

can you please brief me what happen after that..

"C:\Users\Administrator.----

---

>db2ilist

DB2SMN

DB2

C:\Users\Administrator.----

---

>db2 connect

SQL1024N A database connection does not exist. SQLSTATE=08003

C:\Users\Administrator.----

---

>db2 connect db2smn

SQL0104N An unexpected token "db2smn" was found following "CONNECT".

Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601

C:\Users\Administrator.----

---

>db2 connect to db2smn

SQL1013N The database alias name or database name "DB2SMN" could not be

found. SQLSTATE=42705"

Thanks!!!

[Former Member]

What is the result of "db2 list db directory" and "db2 list node directory"

Is the name of DB the same as the name of Instance??

Did you try to catalog the DB again?

Regards,

Thomas

Edited by: Thomas Albuschat on Dec 16, 2010 6:30 AM

[Former Member]

Dear Sir,

When we're trying to excute the command from Administrator: DB2 list output = SMN

But when we're trying to catalog database it is not allowing,

When we're trying to execute any command with db2<SID> user it is showing following output:

DB21015E The Command Line Processor backend process request queue or input

queue was not created within the timeout period.

Thanks!

[Former Member]

---> When we're trying to excute the command from Administrator: DB2 list output = SMN

Looks like DB name is SMN...

What is the result of db2 connect to SMN

Regards,

Thomas

[Former Member]

Dear Sir,

Output of db2 connect to SMN :

SQL1116N A connection to or activation of database "SMN" cannot be made

because of BACKUP PENDING. SQLSTATE=57019

[Frank-Martin]

Hi Ashok,

you may be looking at the wrong DB2 instance. Typically your SAP system should run on DB2 instance db2<dbsid> .

You are looking at DB2 instance "DB2" .

Please check "db2ilist" and the setting of environment variable DB2INSTANCE .

Regards

Frank

[Former Member]

Hi Frank,

Thanks for your reply,

When i check db2ilist getting o/p &DB2 and in envoirment varaible value of DB2INSTANCE is DB2.

Kidly suggest me i m unable to run any db2 command.

Regards

Ashok