Topic
  • 5 replies
  • Latest Post - ‏2013-03-19T15:31:48Z by quchl
SystemAdmin
SystemAdmin
6056 Posts

Pinned topic SQL1611W No data was returned by Database System Monitor

‏2013-03-12T11:51:10Z |
Hello,

Can any one help me with Log Error: SQL1611W No data was returned by Database System Monitor.

DB2 Agent is running and unable to return data in TEP, When login server (DB server) given following :

db2q1041@lqil0219bpmdb02:/db2> db2 list active databases
SQL1611W No data was returned by Database System Monitor.
db2q1041@lqil0219bpmdb02:/db2> db2 connect to q1041

Database Connection Information

Database server = DB2/LINUXX8664 9.7.5
SQL authorization ID = DB2Q1041
Local database alias = Q1041

db2q1041@lqil0219bpmdb02:/db2> db2 list active databases

Active Databases

Database name = Q1041
Applications connected currently = 1
Database path = /db2/qa/db2data/Q1041/db2q1041/NODE0000/SQL00001/
while connected with "q1041" agent return Data in TEP, as soon as command "db2 terminate" given.
the agent stop returning data.

Please help me with this, i know opening connection will fix the issue. but i don't know details how to open connection in UNIX/LINUX. if any other solution please advice..
Updated on 2013-03-19T15:31:48Z at 2013-03-19T15:31:48Z by quchl
  • quchl
    quchl
    4 Posts

    Re: SQL1611W No data was returned by Database System Monitor

    ‏2013-03-12T12:59:45Z  
    Hello

    As you get the result from your command, agent could get data from active database. If there's no active database, agent will show the SQL1611W. When you run connect database command, agent gets data and display data on TEP. When you run db2 terminate command in the same command line, the back-end process - connect database is terminated. So there's no active database now and agent show the SQL1611W. You could run db2 list active database follow the db2 terminate in the same command line window, you would get the SQL1611W also.

    Regards
    Chang Liang
  • ITM61
    ITM61
    168 Posts

    Re: SQL1611W No data was returned by Database System Monitor

    ‏2013-03-12T13:54:24Z  
    sounds like a permission issue. which user is running you db2 agent? root?
    take a db2admin account
  • SystemAdmin
    SystemAdmin
    6056 Posts

    Re: SQL1611W No data was returned by Database System Monitor

    ‏2013-03-19T10:25:47Z  
    • quchl
    • ‏2013-03-12T12:59:45Z
    Hello

    As you get the result from your command, agent could get data from active database. If there's no active database, agent will show the SQL1611W. When you run connect database command, agent gets data and display data on TEP. When you run db2 terminate command in the same command line, the back-end process - connect database is terminated. So there's no active database now and agent show the SQL1611W. You could run db2 list active database follow the db2 terminate in the same command line window, you would get the SQL1611W also.

    Regards
    Chang Liang
    Hello Chang,

    I don’t have detail knowledge on DB2 database, so let me put my question in non technical terms.
    I want to DB2 Database monitoring agent to monitor a particular (DB instance) and for that I think I have to open a dedicated connection so Agent can monitor DB instance even if there is no other active connection to this DB instance.
    If I am wrong, please correct me and tell me how to get rid of Error: ‘1611w No data was returned by Database System Monitor’
  • SystemAdmin
    SystemAdmin
    6056 Posts

    Re: SQL1611W No data was returned by Database System Monitor

    ‏2013-03-19T10:29:04Z  
    • ITM61
    • ‏2013-03-12T13:54:24Z
    sounds like a permission issue. which user is running you db2 agent? root?
    take a db2admin account
    I have verified there is no permission issue, DB2Admin user is running my Agent.
  • quchl
    quchl
    4 Posts

    Re: SQL1611W No data was returned by Database System Monitor

    ‏2013-03-19T15:31:48Z  
    Hello Chang,

    I don’t have detail knowledge on DB2 database, so let me put my question in non technical terms.
    I want to DB2 Database monitoring agent to monitor a particular (DB instance) and for that I think I have to open a dedicated connection so Agent can monitor DB instance even if there is no other active connection to this DB instance.
    If I am wrong, please correct me and tell me how to get rid of Error: ‘1611w No data was returned by Database System Monitor’
    Hello

    Yes, you are right. Please make sure your DB is active(connected) and agent could monitor it.

    Regards
    Chang Liang