Author: Hans Christian Riksheim <HCR AT STERIA DOT NO>
Date: Mon, 4 Dec 2006 15:21:07 +0100
Hi, anybody else using the perl module DBI::TSM? I've recently been using it for reporting purposes and find it quite useful. However I have some problems with the perl memory consumption. This may v
Author: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Mon, 4 Dec 2006 07:41:45 -0700
I cannot remember if I ever tried using DBI, but I have been able to get Perl to work with the TSM ODBC driver by using the Roth ODBC package for Perl. Go to the URL in my sig, then do a search on: o
The problem is that I want to process the output of sql statements line by line as it is returned by the TSM-server, but it seems that DBI requires the output of the whole sql to be stored in memory
Author: Hans Christian Riksheim <HCR AT STERIA DOT NO>
Date: Mon, 4 Dec 2006 19:46:07 +0100
Hi, I use the 64-bit version of perl which can handle the amount of memory. But the memory required is so great that the server starts swapping and the execution rate goes to a standstill(together wi
And you won't. TSM::Function.pm: 138 sub tsm_execute { 139 my ($sth,$statement)=@_; 140 [...] 160 while (<$ch>) { 161 $errstr.=$_ if m/^[A-Z][A-Z][A-Z]\d\d\d\d[^I]/; 162 chomp; In Perl, that means i
Author: Laurent Bendavid <bendavid.laurent AT FREE DOT FR>
Date: Tue, 5 Dec 2006 21:35:58 +0100
Allen S. Rout a écrit : On Mon, 4 Dec 2006 19:46:07 +0100, Hans Christian Riksheim <HCR AT STERIA DOT I essentially want to "stream" the output of the sql through a filter while it is returned from t
Author: Hans Christian Riksheim <HCR AT STERIA DOT NO>
Date: Thu, 7 Dec 2006 14:04:03 +0100
Hi, I have now tried different approaches for my large TSM query: DBI: Allen Rout confirmed my suspicions in a previous post. This one loads the whole output of the sql into memory before processing.