What Is The Really Big Problem Facing The US?

Is it Big Banks or Big Government?

the_biggest_problem

Can you decide?

Can you do anything about either?

Yes you can.

You can vote for a constitutional amendment to reestablish campaign financing limits.  No one should be able to buy Congressional votes.  Then we will have our democracy back.

Then we the People, not the Rich, can control the size of Government and the size of Banks.

Don’t you want control?  Sure you do.

PS  Citigroup just moved its headquarters into the Capitol building with offices next to Congress.  Thus the drawing above is more accurate than we thought.  Oops.

How do you catch a log suspend error in Sybase?

Sybase

You have two issues.

One is the UNIX/Linux script does not detect errors correctly.

Secondly the transaction log is filling up frequently.

First the script needs to have the standard output AND the error output go to your log file. When you use the > it is using file descriptor 1. When you want to capture error output you need to use 2> for file descriptor 2. So the command would look like the following.

isql    > error.log    2> error.log

Better yet, use this.

isql    2>&1    > error.log

The previous command says to have file descriptor 2 go to file descriptor 1 which goes to a log file.

Now to detect errors, look for “Msg” which all Sybase errors have in front by using the grep command.

stackoverflow

 

 

 

 

Secondly to resolve the transaction log space, you need to grow the size of the log which should be on its own device separate from data. Then you need to set the threshold to dump aka flush the completed transactions to a disk file automatically. You need to investigate the following commands to do this.

alter database, sp_helpthreshold, sp_addthreshold, sp_thresholdaction

Good SQL, good night.