All Forums Tools
gneal 4 posts Joined 11/13
17 Mar 2014
“Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS” running bteq on AIX

After installing Teradata version 14.0 new on AIX v6.1 test box, I login using “bteq” command and then get the error “Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS” and then just hangs until I can only kick out.  Then receive  "*** Warning: Exiting because of three BREAKs!   *** Exiting BTEQ...      *** RC (return code) = 2".  Note: /etc/services file only lists “tdmst  1025/tcp” and “tpa” does not exist in /etc/init.d file.  Components installed successfully.   Thank you.

Fred 1096 posts Joined 08/04
18 Mar 2014

Most often, this is due to a network error of some sort which allows the initial logon handshake (very short messages) to succeed but data transmission (longer messages) fails.
You could enable CLIv2 trace (set COPANOMLOG=filename) and/or use a network trace to try to isolate the problem.

gneal 4 posts Joined 11/13
21 Mar 2014

I will try that.  Thank you.

shafiqazrul 1 post Joined 05/14
19 May 2014

Hi,
 
How to run this
 
You could enable CLIv2 trace (set COPANOMLOG=filename

-sHafiq-

You must sign in to leave a comment.