Reports making Informix to hang
Challenger212 Abderrafi reported random hangs of an Informix 11.70 database on Windows 2008 R2, reproduced by an SSRS report calling a stored procedure returning over 15000 rows; the log showed error 64 network error and checkpoints slowed. Paul Watson said error 64 means the hostname is no longer available and asked about sqlhosts and the event log. The sqlhosts registry used an IP address. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
hi, we have a problem over 2 months our Informix 11.70 Database hang at random
and in the database server dbaccess mydb is just hanging and not responding,
after 3 months of investigation, we have today suspect a report wich launch a
stored procedure retreinving many rows over 15000 rows, we have simulate the
cas and Eureka the phenomena happen after launching this report, the informix
database is just hanging and no connection is allowed and no error is
launched, only we fing in the online log "ERROR 64 , network error", we did
not why Informix do this and how to solve the problem without touching the
stored procedure.
Ps: when the phenomena is hapening also the chekpoints can take at random many
sconds and sometimes minutes to complete.
the reports is Microsoft report services and the Os is Windows 2008 R2.
Error 64 under windows is hostname is no longer available.
In your sqlhosts do you have hostname or IP
Are you connecting on IP or hostname
Cheers
Paul
> hi, we have a problem over 2 months our Informix 11.70 Database hang at
> random
> and in the database server dbaccess mydb is just hanging and not
> responding,
> after 3 months of investigation, we have today suspect a report wich
> launch a
> stored procedure retreinving many rows over 15000 rows, we have simulate
> the
> cas and Eureka the phenomena happen after launching this report, the
> informix
> database is just hanging and no connection is allowed and no error is
> launched, only we fing in the online log "ERROR 64 , network error", we
> did
> not why Informix do this and how to solve the problem without touching the
> stored procedure.
> Ps: when the phenomena is hapening also the chekpoints can take at random
> many
> sconds and sometimes minutes to complete.
>
> the reports is Microsoft report services and the Os is Windows 2008 R2.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web: www.oninit.com
Oninit® is a registered trademark of Oninit LLC
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
What this country needs are more unemployed politicians
Hi, Sqlhosts does not exist in Widnows, it's located into regedit of Windows, in the Sqlhosts of regedit, I have as follow: Sqlhosts directory and under that I have: INSTANCE_NAME and under taht I have these parameters: Host: ip_adress Protocol: onsotcp Service: Instance name regards
anything in the event log when this happens? Cheers Paul > Hi, Sqlhosts does not exist in Widnows, it's located into regedit of > Windows, > in the Sqlhosts of regedit, I have as follow: > > Sqlhosts directory and under that I have: INSTANCE_NAME and under taht I > have > these parameters: > Host: ip_adress > Protocol: onsotcp > Service: Instance name > > regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians