Ultimate Google Doodle Promo

Featured

Click Follow to get future email notifications of new content. You will NOT be spam’d.

NASA Wants To Change Name To LASSO

The new acronym would stand for the Lasso Asteroids Space System Organization or better yet the Lasso Asteroids Space System for Obama.  Which do you like better?

lasso_satellite

The new organization’s main purpose is to fly an Orion spacecraft with an astronaut aboard to an asteroid, perform a tethering maneuver and tow the asteroid home.

CBS News has also learned that the new organization, LASSO, is seeking permission  to use its technology to lift Louie Anderson of the Splash show out of the pool.

Scientists agree this is better than having NASA wait around for the next President named Kennedy to give them a goal.

 

 

 

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.

Death to the Death Star

Recently a White House Petition at the “We The People” website received the required 25,000 signatures.  This particular petition asked for the government to build a Death Star by 2016 to boost job creation and bolster national defense.

deathstar

Because it received the required signatures, the White House had to respond. Thus Paul Shawcross, Chief of Science and Space at the White House Office of Management and Budget, formulated the following reply.

  • Financially
    • It costs $850,000,000,000,000,000
    • We need to reduce the budget not expand it.
  • Morally
    • The Administration does not support blowing up planets.
  • Practically
    • It is a flawed concept – can be exploited by a one-man starship.

Evidently the answer is no.  Maybe the next Administration will be more lenient.