Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Lysen
  • Content: Threads
  • Order by date
  1. Lysen

    Security in Cognos 8

    Hello all, Right now I'm busy setting up a fresh installation of Cognos 8, before we migrate from Series 7.3. But I have some questions concerning how the security works in Cognos 8. We have some PowerCubes which are secured using the LDAP which came with version 7. For 8 we want to get rid...
  2. Lysen

    fatal two-task communication protocol error

    Hi group, when running a cognos impromptu report on our oracle 8i database it returns the following error, when 4 elements from "elm1" are selected (elm1 being a prompt) : DMS-E-GENERAL, A general exception has occurred during operation 'asynchronous open'. DMS-E-GENERAL, A general exception...
  3. Lysen

    Product Join

    Hi group, I have this snippet from an explain here, how do I avoid this product join; it should NEVER be that many rows (more like a couple of 1000..)... :( 11) We do an all-AMPs JOIN step from Spool 9 (Last Use) by way of an all-rows scan, which is joined to SYS_CALENDAR.CALDATES...
  4. Lysen

    Variable passing to the Shell function.

    Hi group, I have this script which generates PDF files based upon lots of prompts. It stores these in a directory from where I read them in the script again to send them off via email. I have a table which contains the email address and which PDF to send to a particular person. The script...
  5. Lysen

    7.3 available!

    howdy! 7.3 of cognos software is available for download at http://support.cognos.com/en/support/index.html. :)
  6. Lysen

    Teradata Manager & Administrator

    Hi all, I'm trying to get teradata manager running, but when using the tool RDBMS Setup, and entering the valid credentials it starts, but the first error is: 5-8-2004 15:33:38 RDBMS Setup started. __________Setting up DBCMNGR__________ Logging on to dbc as DBC... *** Logon successfully...
  7. Lysen

    3610!

    Hi all, with this sql select * from plato.agent where datumtot is null and anvr_nummer in ( sel agentnummer from plato.reservering where reserveringsnummer in ( sel distinct(reserveringsnummer) from plato.pax where paxnaam =...
  8. Lysen

    Statistics

    Is it a bad thing to collect statistics on every index on every table? Like overhead, extra discspace etc..?
  9. Lysen

    NL-00051: internal error code

    Hi, We've got a problem with our Oracle 8.1i (I think..). The listener log grows very large in a couple of days, like 1.3 GB in about 9 days. It's filled with this message: 22-JUN-2004 09:42:11 * 51 NL-00051: internal error code, arguments: [302], [1], [], [], [], [], [] Does anyone know what...
  10. Lysen

    Technical Conference in Frankfurt anyone?

    Hi all, who's going to the technical conference in Frankfurt (somewhere in june)? And are these kind of conferences helpful? I'm considering going if it's about more than watching netherlands vs germany soccer match in a pub someplace... :-) (go holland go!) Eli
  11. Lysen

    How to drop a join index

    I have multiple join indexes on a temporary table. I want to get rid of the table, but I can't because of the JI. With this query: select IndexNumber , IndexType , UniqueFlag as Flag , ColumnName as ColName , ColumnPosition as Pos , Indexname as IdxName from dbc.indices...
  12. Lysen

    Query from ProvideX (unix) to Teradata (unix)

    Hi, I've some questions again...! :-) We have a in-house developed software suite programmed on ProvideX. This software needs to search for certain keywords very fast. We have a large database of images, and these are grouped by keywords. We want to give users the ability to search for these...
  13. Lysen

    insert data from same table 260 times...

    Hello, I need to insert data from a table into the same table with a different company_code (CMPCODE). This has to be done for about 250 tables, so I thought I might be able to do this in Dynamic SQL. But I've no idea how to do it! :-) I've seen some examples on the internet, but I'm a complete...
  14. Lysen

    Tuning: indexes, visual explain, or speed up of queries

    Hi folks, We have a table called content in our teradata db. This table is heavily accessed (+300.000 queries per day) because an internet utility uses it to search for holiday content. During the day, when our website isn't used much, the queries run very fast. But during peak hours (8 pm to...
  15. Lysen

    Begin logging

    Hi all, why doens't teradata accept the next statement???????????? begin query logging limit summary on sysdba; while begin query logging limit on sysdba; gets the response: 3706: Syntax error: Expected SQLTEXT, SUMMARY, THRESHOLD or combination. please help, i'm getting VERY frustrated...
  16. Lysen

    creating a DCM database

    Hi, I try to get the teradata dq manager and terdata winddi etc. running, and for that I 've installed CLiV2 connection, adjusted the hosts file in my windows directory, and I'm ready to roll. I start up the TD Database Managment Tool to create the TDQM database, and click on create it returns...
  17. Lysen

    Explain: 2 minutes, Execute: > 80 minutes!!

    What's going on with our database, if explain says the total estimated time is 1 minute and 38 seconds, but the execution took more than an hour before I cancelled the query???! We're running V2R5 with Teradata Sql assistant 6.1... The query is supposed to come back with about 30.000 records...
  18. Lysen

    How to read ...DataParcel...

    Hi, Can anyone tell me how to read the dataparcel field in an errortable after fastloading? It contains information why this record has had an error while loading(I think), but it needs to be decoded or something before it makes sense...? Thanks, Lysen
  19. Lysen

    Namespace

    Does anyone know what to do to kill this message? It keeps popping up in the windows log file every hour or so... W2KCOGNOS, 1800(c98), 2003/06/03 13:25:43.843; Error: 0, Generic; Process ID: 1800; Thread: 3224; Host: W2KCOGNOS; Text: Impromptu Web Reports is not using the namespace that was...
  20. Lysen

    Audit..??

    Hi people, Can anyone tell me what the steps are to audit what reports are run and by whom, and when who accessed which cube? Thanx.

Part and Inventory Search

Back
Top