#DateForumTypeThreadPost
1814 May 2009 @ 08:30 PDTDatabaseReplyMLOAD / FLOADBalamurugan,I guess you are wrong. when u invoke Multiload u will have at a min 2 session ie 1 is the control session and other the child sessions . If you notice keenly The control session runs t...
1714 May 2009 @ 01:31 PDTDatabaseReplyTuningSubash,Thanks for your insights . Actually the process that we do is normal insert ..select..normally it takes 20 mins to end . sometimes it gets over by 30 to 40 mins.Stats are uptodate . so no wo...
1614 May 2009 @ 01:18 PDTDatabaseTopicMLOAD / FLOADHi Guru's,how to find which sessions is associated with particular MLOAD job.example:Suppose there are 5 Mload jobs loading on to say 25 tables ( ie 1 MLoad loading 5 tables ).So how to find which ...
1508 May 2009 @ 07:32 PDTDatabaseReplyPE and AMP setupat a min 1 PE and at a Max 10 PE's can be there.But generally Node has 2 PE's and number of Amps vary..
1408 May 2009 @ 01:14 PDTDatabaseReplyAutomating packdisk and checktable?yes thers a way in which you can automate.have u heard of CNSRUN utility.if no u can get it from the documents and then create a batch file and schedule it ...regardsTD_DBA
1308 May 2009 @ 01:12 PDTDatabaseTopicTuningHi guys ,I was asked to optimise a query and it involves multiple joins in the sel.i am attaching a small part of the query wher in which i think adding the index would help. WHERE (uact...
1220 Apr 2009 @ 01:30 PDTDatabaseReplyhow to set the HEADER OFFPerfect.I was able to run the script. Thanku very much
1117 Apr 2009 @ 08:44 PDTDatabaseTopichow to set the HEADER OFFHi Please see the part of my script as below:.set heading .export file /root/nvfiles/create_BKP_tab1.sqlselect 'create table '||trim(databasename)||'.old_'||trim(tablename)||' as '||trim(databasena...
1007 Apr 2009 @ 03:24 PDTDatabaseReplyCHECKTABLE UTILITY -- ERRORThanks for your reply . I was able to get the tablename and indeed it was not a system table.actually i remembered i created a table with Unicode definition and that table created the problem.anywa...
903 Apr 2009 @ 09:07 PDTDatabaseReplyTeradata - binary partitioning in single boxHi ,In real time no one would set up the way u are asking like
803 Apr 2009 @ 09:04 PDTDatabaseReplyLockingI always prefer access lock rather than exclusive Lock...
703 Apr 2009 @ 08:54 PDTDatabaseReplyTeradata 12.0 (demo) suddenly hung up.check if the vprocs are online from vprocmanager when the PDE state is run/started
603 Apr 2009 @ 08:43 PDTDatabaseTopicCHECKTABLE UTILITY -- ERRORTo the GURU's of TD:while iam running the check table utility i got the following error:check dbc at level three skiplocks priority=h error only;CHECKTABLE will run in Perf Group: HCheck beginning ...
501 Apr 2009 @ 04:51 PDTDatabaseTopicLARRY HIGA MACROSHi,Iam unable to find Larry Higa Macros. It would be helpful if anyone could guide me in that.regardsTD_DBA
421 Jan 2009 @ 02:12 PSTDatabaseTopicCYLINDER full conditionHi TD Gurus,when ever a Cylinder full condition happens what are the steps to be undertaken in order to avoid the problem.ThanksJr.Teradata_dba
320 Jan 2009 @ 02:41 PSTDatabaseReplySystem restart and System hangregarding system hang .. wat i infer from you is system may not be 100% but still users applications hang or as a DBA if i run a canaery query it will hang. and this may happen due to one of the Un...
219 Jan 2009 @ 07:37 PSTDatabaseReplyTeradata MonitoringHi Sam,- There are some arcmain session I see that say AMP state as Active and PE as Idle. What does this mean ?[font=Courier New]Amp state active- Amp is nothing but access module processor and it...
119 Jan 2009 @ 06:13 PSTDatabaseTopicSystem restart and System hangHi,i would like to know answers on my question:1. the difference between system saturation and system hang2. If one of this happens how to find it out3. how to see if ALL the AWT's is in use or not...

Pages