Archived discussions are read-only. Learn more about SAP Q&A

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

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

Not what you were looking for? View more on this topic or Ask a question