#DateForumTypeThreadPost
611 Sep 2015 @ 08:49 PDTDatabaseReplyhow to get rows with a blank value in a column1 ques?   I have output from a SQL as below:     COL1     COL2   COL3 NULL     NULL     ABC NULL &nb...
516 Aug 2015 @ 04:37 PDTGeneralReplyStored procedure - Facing error while executing Call statement SET SqlTxt = (' CREATE TABLE'   || DATABASENAME ||'.'|| TABLENAME1_bkp || 'AS' || DATABASENAME ||'.'||TABLENAME1||  ' WITH DATA and STATS' )...
415 Jul 2015 @ 12:39 PDTViewpointReplyAbort sessions in responding phaseWhenever a db session is not responding, it is recommended to kill that session by DTG.   In which scenario the session goes to hanged state afterwards and it require DB resta...
315 Jul 2015 @ 12:34 PDTViewpointReplyTASM Exception and TASM FiltersWhenever any SQL session at database is not responding since long(1 hr), then it is recommended to kill that session at database level. In which scenario the db session is hanged and req...
226 Apr 2015 @ 12:55 PDTDatabaseReplyStats CollectionIf suppose one of my table is loading a million data on daily basis by truncate load method, then how will the stats collect play its role over here for performance improvent while loading?
119 Nov 2014 @ 04:36 PSTDatabaseReplyoptimize the querySame is the case with my query ...where i had used 3 unions....the query get timeout... Is there any way out of this to handle it