Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+Upgrade\s+to\s+TSM\s+5\.5\.5\s+causes\s+ANR2914E\s+from\s+SELECT\s+query\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+Upgrade\s+to\s+TSM\s+5\.5\.5\s+causes\s+ANR2914E\s+from\s+SELECT\s+query\s*$/: 7 ]

Total 7 documents matching your query.

1. [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: "Matthew G. Leis" <matthew.leis AT USBANK DOT COM>; Date: Tue, 5 Oct 2010 08:58:34 -0500; After upgrading to TSM 5.5.5, we are unable to generate reports that rely on complex select queries to the database. This error is generated: ANR2914E SQL IDENTIFIER TOKEN NAME OR COMPONENT EXCEEDS 1; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00046.html (13,387 bytes)
2. Re: [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: Danny Schmanny <schmanny AT LGCA DOT ORG>; Date: Tue, 5 Oct 2010 10:26:28 -0400; Hi Matt: We are on TSM 5.5.5 and are getting the same error so I'm glad to hear I'm not alone (I was wondering why the reports started erroring out like that). Below is the error I am seeing: Session; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00047.html (14,808 bytes)
3. Re: [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: "Matthew G. Leis" <matthew.leis AT USBANK DOT COM>; Date: Tue, 5 Oct 2010 10:25:41 -0500; I opened a case with IBM, here are the results: We are encountering the following APAR. IC71586: ANR2914E SQL IDENTIFIER TOKEN EXCEEDS 18 CHARACTERS AFTER UPDATETO TIVOLI STORAGE MANAGER SERVER V5.5.; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00049.html (16,930 bytes)
4. Re: [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: Danny Schmanny <schmanny AT LGCA DOT ORG>; Date: Thu, 7 Oct 2010 08:26:06 -0400; Greetings Matt et al: I thought I had resolved this 18 character limitation in TSM version 5.5.5 by defining the 'from' clause 'Domains' as D, 'Nodes' as N, and 'Occupancy' as O (see Revised SQL belo; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00070.html (18,636 bytes)
5. Re: [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: "Matthew G. Leis" <matthew.leis AT USBANK DOT COM>; Date: Thu, 7 Oct 2010 08:55:47 -0500; Hello Danny, Try something like this: select DISTINCT occ.node_name,SUM(occ.num_files)/2, SUM(occ.physical_mb)/2, occ.filespace_name from domains dom, nodes nod, occupancy occ where dom.domain_name=n; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00080.html (20,240 bytes)
6. Re: [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: Danny Schmanny <schmanny AT LGCA DOT ORG>; Date: Thu, 7 Oct 2010 15:50:47 -0400; Matt: Thanks. Your suggestion worked. The only difference I can see is using dom instead of D, nod instead of N, and occ instead of O. Brilliant. Must be something about single letters it didn't like; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00098.html (20,935 bytes)
7. Re: [ADSM-L] Upgrade to TSM 5.5.5 causes ANR2914E from SELECT query (score: 1): Author: robert_clark <robert_clark AT MAC DOT COM>; Date: Thu, 7 Oct 2010 23:06:40 +0000; If you're going to load the 5.2 IDL (WebGUI), do so before upgrading to 5.5.5. Once you've upgraded to 5.5.5, the 5.2 IDL load fails. [RC] On Oct 05, 2010, at 08:25 AM, "Matthew G. Leis" <matthew.lei; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2010-10/msg00103.html (17,287 bytes)

Current List: 1 - 7
Page: [1]