15 Replies Latest reply: Dec 16, 2010 7:32 AM by Db2 User RSS

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

ashok singh
Currently Being Moderated

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

Actions