Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Using\s+the\s+DBI\:\:TSM\s+module\,\s+memory\s+problem\s*$/: 7 ]

Total 7 documents matching your query.

1. Using the DBI::TSM module, memory problem (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00037.html (13,592 bytes)

2. Re: Using the DBI::TSM module, memory problem (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00038.html (15,561 bytes)

3. Re: Using the DBI::TSM module, memory problem (score: 1)
Author: Richard Sims <rbs AT BU DOT EDU>
Date: Mon, 4 Dec 2006 09:46:41 -0500
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00039.html (12,241 bytes)

4. Re: Using the DBI::TSM module, memory problem (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00046.html (14,352 bytes)

5. Re: Using the DBI::TSM module, memory problem (score: 1)
Author: "Allen S. Rout" <asr AT UFL DOT EDU>
Date: Mon, 4 Dec 2006 14:05:24 -0500
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00048.html (13,068 bytes)

6. Re: Using the DBI::TSM module, memory problem (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00075.html (14,829 bytes)

7. Re: Using the DBI::TSM module, memory problem (score: 1)
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.
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-12/msg00130.html (17,857 bytes)


This search system is powered by Namazu