![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Yesterday while working, I discovered that part of my DB2 database had been left in a quiesced state the prior day while testing the QUIESCE DATABASE command. I wasn't able to access any of my tables.
I was getting the error: SQL3015N An SQL error "-290" occurred during processing.
SQL -290 is "table space access not allowed".
I had a database backup, but didn't want to do a restore if I didn't have to.
When I tried the UNQUIESCE command, it told me that neither my database nor my instance were quiesced. Then I found out that there is also a QUIESCE TABLESPACE command. The "DB2 LIST TABLESPACES SHOW DETAIL" command showed me which tablespace was quiesced.
I think I tried the QUIESCE TABLESPACE command along with the RESET parameter, but got some error. Luckily, I found this page which explains how to remove a phantom quiesce. You have to first issue the QUIESCE TABLESPACE command for any table (apparently) in that tablespace, to gain control over the phantom quiesce. Then you can repeat the QUIESCE command with the RESET parameter to unquiesce it.
.
Today I tried to get an asp page (which worked on my old computer) to work on my new laptop. It's a relatively simple page which takes the posted XML request file, searches for certain elements in it, and based on which elements it finds, returns one of several hard-coded XML response files.
My laptop's IIS install hadn't included ASP, but it had included ASP.NET. So first I tried to convert my asp page to aspx. I was able to work through several errors, but then was confronted with some that I couldn't figure out.
Like these:
Could not find file 'c:\windows\system32\inetsrv\System.Web.HttpRequest'
and
Access to the path 'c:\windows\system32\inetsrv\System.Web.HttpResponse' is denied.
and
System.Xml.XmlException: Invalid character in the given encoding. Line 1, position 1.
The line numbers listed along with these errors weren't any help. When I commented out the referenced lines, the same error kept occurring, but on some other totally unrelated line.
So I gave in and installed the IIS ASP component, and tried using the original asp version of my page again.
I was calling the asp page from a java application running on Tomcat. But then Tomcat kept getting out of memory errors, even with an increased heap size. I'm not sure if the memory problem is due to a problem with the asp page, or with the java app.
I used to have a utility which let you intercept messages, so that you could check if they were being passed correctly. Instead of sending the message to the normal URL, you'd set up another port number, and send it to that port. Then the utility would capture it and pass it on to the normal URL.
Update: I found the utility I used to use; it was "TCPMon".
.
The laptop still has the problem were it reboots itself without warning, while using VPN over wireless. I've updated the BIOS and the wireless drivers, and tried different versions of the VPN program, but the problem is still there. Several people with the new laptops are having the same problem, but so far, my company's tech support hasn't been able to fix it.
When not using wireless, the VPN can be frustrating too. Sometimes it will crash, and I won't be able to get it to work again until after rebooting. And today my laptop was frustrating me even more by repeatedly clocking with a dark screen when logging on to it, after I had rebooted.
My wireless keyboards must be built pretty well. I've banged them in frustration many times, but they haven't broken.
[2011/07/02 - updated with more details]
I was getting the error: SQL3015N An SQL error "-290" occurred during processing.
SQL -290 is "table space access not allowed".
I had a database backup, but didn't want to do a restore if I didn't have to.
When I tried the UNQUIESCE command, it told me that neither my database nor my instance were quiesced. Then I found out that there is also a QUIESCE TABLESPACE command. The "DB2 LIST TABLESPACES SHOW DETAIL" command showed me which tablespace was quiesced.
I think I tried the QUIESCE TABLESPACE command along with the RESET parameter, but got some error. Luckily, I found this page which explains how to remove a phantom quiesce. You have to first issue the QUIESCE TABLESPACE command for any table (apparently) in that tablespace, to gain control over the phantom quiesce. Then you can repeat the QUIESCE command with the RESET parameter to unquiesce it.
.
Today I tried to get an asp page (which worked on my old computer) to work on my new laptop. It's a relatively simple page which takes the posted XML request file, searches for certain elements in it, and based on which elements it finds, returns one of several hard-coded XML response files.
My laptop's IIS install hadn't included ASP, but it had included ASP.NET. So first I tried to convert my asp page to aspx. I was able to work through several errors, but then was confronted with some that I couldn't figure out.
Like these:
Could not find file 'c:\windows\system32\inetsrv\System.Web.HttpRequest'
and
Access to the path 'c:\windows\system32\inetsrv\System.Web.HttpResponse' is denied.
and
System.Xml.XmlException: Invalid character in the given encoding. Line 1, position 1.
The line numbers listed along with these errors weren't any help. When I commented out the referenced lines, the same error kept occurring, but on some other totally unrelated line.
So I gave in and installed the IIS ASP component, and tried using the original asp version of my page again.
I was calling the asp page from a java application running on Tomcat. But then Tomcat kept getting out of memory errors, even with an increased heap size. I'm not sure if the memory problem is due to a problem with the asp page, or with the java app.
I used to have a utility which let you intercept messages, so that you could check if they were being passed correctly. Instead of sending the message to the normal URL, you'd set up another port number, and send it to that port. Then the utility would capture it and pass it on to the normal URL.
Update: I found the utility I used to use; it was "TCPMon".
.
The laptop still has the problem were it reboots itself without warning, while using VPN over wireless. I've updated the BIOS and the wireless drivers, and tried different versions of the VPN program, but the problem is still there. Several people with the new laptops are having the same problem, but so far, my company's tech support hasn't been able to fix it.
When not using wireless, the VPN can be frustrating too. Sometimes it will crash, and I won't be able to get it to work again until after rebooting. And today my laptop was frustrating me even more by repeatedly clocking with a dark screen when logging on to it, after I had rebooted.
My wireless keyboards must be built pretty well. I've banged them in frustration many times, but they haven't broken.
[2011/07/02 - updated with more details]