(Tim Smith) We import a file once a day and after importing the file, we need it moved to an archive folder with a date stamp appended to the file name. We have had trouble in the past with this process, so we’d like this to run as its own step to help troubleshoot it if there are issues.
Other News
Accidental SysOps Maitnenance Tasks
Do you keep up with your batteries? I usually don’t even think about that. However, a recent power outage got me thinking about batteries which if they are not kept up may result in more than an inconvenience. Laptop batteries are the ones of which I am usually more aware. I use my laptop away from my desk a lot […]
SSWUGtv Security Edition: The cloud, certifications, and you.
Video Programming for IT Professionals
A SQL Trick to Eliminate Unwanted Spaces
A SQL Trick to Eliminate Unwanted Spaces by Craig Mullins Data integrity can be a vexing, but there are some data integrity issues that can be cleaned up using a touch of crafty SQL. Consider the common data entry problem of extra spaces in a name field. Not only is it annoying, sometimes it can cause the system to ignore...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Retrieving WebLogic Server Name and Port in ADF Application
(Andrejus Baranovskis) It could come handy to know how to get WebLogic server name and port in ADF application. Particularly this could be useful, when running ADF application in the cluster and there is a requirement to track WebLogic node with application session instance running.
ASM Disk Group Attributes
(Bane Radulovic) Disk group attributes were introduced in ASM version 11.1. They are bound to a disk group, rather than the ASM instance. Some attributes can be set only at the time the disk group is created, some only after the disk group is created, and some attributes can be set at any time, by a
ODI – Who Changed What and When? Search!
(David Allan) Cell phones ringing, systems with problems, what’s going on? How do you diagnose? Sound a common problem? Some ODI runtime object failed in a production run, what’s the first thing to do? Be suspicious. Be very suspicious. I have lost count of the number of times I have heard ‘I change
DB2 Basics: What is a Reorg?
(Ember Crooks) This is the first in a series of blog entries on reorgs. I was talking with a friend recently, and he pointed out that I only have a few articles on reorgs, and they’re very specific to complicated parts of reorg. I have scripted my own reorgs and made a point of educating myself on r
Backup Manager for MySQL, MariaDB and Percona Server (mysql_bman)
(Shinguz) The MySQL Backup Manager (mysql_bman) is a wrapper script for standard MySQL backup tools. The Problem with MySQL backup tools is, that they have many options and thus are overcomplicated and errors are easy made.
DBA Myths: A table with a primary key is not a heap
(Kenneth Fisher) Typically when you see a heading like this you know the answer is “No” or “False” but in this case it’s more of a “hu?” You see a primary key and a table being a heap have nothing to do with each other. Well very little anyway.