Hi ggonsalves,
Thanks for your suggestions and sorry for the late response (I am only able to access the system on Tuesdays).
I have tried to tune the memory parameters using the configuration advisor in DB2 Control Center before going about upgrading the system or DB2 instance but so far that hasn't worked out...
However, I have discovered something very interesting that I think I should mention. The query...
200dogz
Last Activity: Nov 23 '11, 07:14 AM
Joined: Oct 4 '08
Location:
-
DB2 instance hangs on query
Hi all,
We have a DB2 instance running on a virtual machine with Windows Server 2003 and 3.75GB of RAM.
Some time since 2010, we started to experience problems with DB2, which the entire instance would "hang" when certain SQL queries are run and the only way we could get it to recover is by restarting the machine. I'm not sure if any update was deployed at that time. The version we currently have is:
...Code:DB21085I
-
Thanks Frinavale for the very detailed explanation :)
One question though, if I am to use localise control is there still a way to write the text if we don't know what the text is? (say if we need to grab it from a database). From what I know if we don't "runat=serv er" something, then we can't really control it (except the style)...Leave a comment:
-
Hi ndedhia1,
Have you tried putting double quotes around the text you're extracting to the csv file? From what I remember that can allow the text to have commas in it.Leave a comment:
-
asp:Label vs asp:Placeholder
In terms of disaplying text on the server side, which one is the better choice - an asp:Label or an asp:Placeholder ?
The only difference between the two that I know is that label puts a <span> tag around it's contents. Is there any other difference between the two, particularly performance-wise?
Edit: Never mind a Placeholder cannot be used to hold text directly...I was probably thinking of something else =... -
Yes that's what I've been using for all my reports. As long as the headers are set correctly you can write any string as output....Leave a comment:
-
it's just a string variable =P
cool, thanks...Leave a comment:
-
Yea and later that day I found out that didn't apply for about 20% of the documents; so I just took off the compression feature. I've sent an email to the gzip-bug team but haven't received a response yet......Leave a comment:
-
Umm...the problem seems to be gone after...a server reboot.
That probably means it's a resource issue?
Anyway, I believe the same problem is going to pop up again in the future but as long as there's way to resolve it I guess it's all good :)
Many thanksLeave a comment:
-
Hey Frinavale I think you are probably right!
This is what's being used to output the file:
...Code:HttpContext context = HttpContext.Current; context.Response.Clear(); context.Response.AppendHeader("Content-Type", "application/msword"); context.Response.AppendHeader("Content-disposition", "attachment; filename=\"report.doc\""); context.Response.Write(this.document);Leave a comment:
-
Unfortunately I don't have administrative access to the server =(. I've been asking our admin to check if there's any problem he can identify the problem but there hasn't been any outcome. I'm trying to figure out a possible reason and resolution before I ask our admin to check again.
By the way there's indeed a pretty big chance that it is an IIS issue since IIS 6 was reinstalled and reconfigured on the server a few weeks ago....Leave a comment:
-
The reports have always been fine. It's just recently that reports that are greater than approximately 1MB are getting killed by the server. They can still be downloaded if quick enough. By the way for the same report with the same size that doesn't "always" get deleted....Leave a comment:
-
OK so It was apparently a bug with gzip/deflate compression.
http://bugs.php.net/bug.php?id=8893&edit=1
I've found a way to tackle this...
If I have </w:wordDocument >< (an extra space before < and a > after), it will remove the <.....no idea how it works but hey it works =). This is the only solution I've found so far....Leave a comment:
-
--------------------------------------------------Leave a comment:
-
gzip doesn't like XML?
I have a webpage that creates XML based Word Document for clients to download.
This works fine, however, if I apply gzip compression to a Word Document before it's sent to the user, the last character '>' in the file is always removed.
“</w:wordDocument> ” becomes “</w:wordDocument”
....if I deliberately put another '>' at the end, gzip removes both '>'. If I put any... -
Yes, I have access to the source code through the networks, but don't have the right to get into the server or IIS. It started about a week ago; not sure if there's any changes/reboot made. I assume Windows updates are disabled since the server is not connected to the Internet....Leave a comment:
-
Hi DeepBlue,
Thanks for the answer =) although I'm pretty sure it's possible to have multiple readers active at the same time with one connection as that's what I've always do.Leave a comment:
-
file "killed" a few seconds after it's generated
Hi,
I have a aspx page that generates reports with the data it gets from databases.
It used to work quick and fine until recently when a file is generated it gets killed a few seconds after that. It can still be downloaded if fast enough:
A few seconds later...
The interesting thing is that only reports that are approximately larger than 1MB would get destroyed. Small... -
closing a reader
Is it necessary to close or dispose every single reader used if closing a connection already destroys its readers? -
I've enabled anonymous access in IIS and the login screen no longer shows up :).
So you're most likely right about it being an IIS issue.
Cheers :)...Leave a comment:
No activity results to display
Leave a comment: