Sponsored Content
Top Forums Shell Programming and Scripting how to check DB connection in unix shell script Post 302253256 by demwz on Friday 31st of October 2008 09:22:52 AM
Old 10-31-2008
I'm not a db2 expert, but the best way to test a database is to create a small test table within the database with only one filed most likely the actual date.
testing steps:
* update the date field with the current date
* select the date filed
compare the result.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

check in unix shell script so that no one is able to run the script manually

I want to create an automated script which is called by another maually executed script. The condition is that the no one should be able to manually execute the automated script. The automated script can be on the same machine or it can be on a remote machine. Can any one suggest a check in the... (1 Reply)
Discussion started by: adi_bang76
1 Replies

2. UNIX for Dummies Questions & Answers

How to check path exist or not in UNIX shell script

UNIX Shell Script I'm in /home/suneel dirctory in that directory need to check for a path for example com/src/resources If Path exists need to copy the files from one directory If path not exist need to create the folders and copy the files UNIX shell script help required (3 Replies)
Discussion started by: suneelc
3 Replies

3. Shell Programming and Scripting

Review Check list for Unix Shell Script

Hi, I need Unix Shell Script Review Check list in the format of word or excel. Can any one provide the review checklist for unix shell script. Pls. (1 Reply)
Discussion started by: praka
1 Replies

4. Shell Programming and Scripting

check the DB connection through Unix

Hi all, I have written the script to check the connectivity of the Database ,the scripts show me the correct error when i try to give the wrong credential's but it also show Connected and trigger's the child jobs which that should not happen , whenever the connection is not established properly... (2 Replies)
Discussion started by: bshivali
2 Replies

5. Shell Programming and Scripting

BatchScript/Unix shell Script to check folder in Windows server

Hi, It will be great help if any of them can provide or tell which scripting is possible to write for checking folder exists or not in Windows server from Unix/Windows machine. If folder doesn't exist then need to create the folder through script and copy the files. It is on very... (1 Reply)
Discussion started by: prakashchakra7
1 Replies

6. Shell Programming and Scripting

simple while loop script to check a connection

Hi, I am completely new to shell scripting. Basically I am wanting to create a simple while loop script to check if a network connection is available from 'netstat -a' and if its present then output a character to the serial port. I think i am nearly there.. but need some assistance.. this is... (9 Replies)
Discussion started by: zippyzip
9 Replies

7. Shell Programming and Scripting

Check the connectivity of the DB through script, exit if no connection

check the connectivity of the DBs through script, script should exit if no connection and display the output as below. connectivity for DB1 is OK connectivity for DB2 is OK connectivity for DB3 is FAILED for DB in 1 2 3 do (sqlplus -s... (5 Replies)
Discussion started by: only4satish
5 Replies

8. Shell Programming and Scripting

Check SQL through UNIX shell script

I use below command to log in to oracle database sqlplus username/passwordWhen i enter into sql prompt i press quitIf there are any errors it will show just below the output of sqlplus username/password. The errors generally start with keyword ORA can we do this by using a unix shell script.?... (4 Replies)
Discussion started by: Nakul_sh
4 Replies

9. Shell Programming and Scripting

Need Script to check the FTP connection

Hi, I need a script which check the FTP connections, if its working fine then no issue. Incase not working fine then Trigger the mail. Please help on this. Thanks (4 Replies)
Discussion started by: Keshav Kalra
4 Replies

10. Shell Programming and Scripting

How to check email with attachment received or not from UNIX shell script?

Hello Guys, Here is the requirement!! I want to check the mail with attachment received or not through unix scripting. And send an notification email when mail with attachment already received. Any thoughts on this is much appreciated!! Regards, Harry (0 Replies)
Discussion started by: dharry2017
0 Replies
DBIx::Class::TimeStamp(3pm)				User Contributed Perl Documentation			       DBIx::Class::TimeStamp(3pm)

NAME
DBIx::Class::TimeStamp - DBIx::Class extension to update and create date and time based fields DESCRIPTION
Works in conjunction with InflateColumn::DateTime to automatically set update and create date and time based fields in a table. SYNOPSIS
package My::Schema; __PACKAGE__->load_components(qw( TimeStamp ... Core )); __PACKAGE__->add_columns( id => { data_type => 'integer' }, t_created => { data_type => 'datetime', set_on_create => 1 }, t_updated => { data_type => 'datetime', set_on_create => 1, set_on_update => 1 }, ); Now, any update or create actions will update the specified columns with the current time, using the DateTime inflator. This is effectively trigger emulation to get consistent behavior across databases that either implement them poorly or not at all. METHODS
get_timestamp Returns a DateTime object pointing to now. Override this method if you have different time accounting functions, or want to do anything special. The date and time objects in the database are expected to be inflated. As such you can be pretty flexible with what you want to return here. AUTHOR
J. Shirley <jshirley@gmail.com> CONTRIBUTORS
Florian Ragwitz (Porting to DBIx::Class::DynamicDefault) LTJake/bricas COPYRIGHT &; LICENSE Copyright 2009 J. Shirley, all rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2010-09-05 DBIx::Class::TimeStamp(3pm)
All times are GMT -4. The time now is 10:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy