Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hello I need to create few stor
You need to look into the DB2 Federated support. You can think of it like a Linked Server configuration. The three basic components you will need to create are the server reference, user mapping and the nickname. Once this is in place you will reference the nickname in you SP and that will... -
DB2-DB2 SERVICE STOPPING AUTOMATICALLY
Processes will rarely stop autmatically. You should look into what conditions cause it to trap/crash. You could start by looking in the Windows application event log for clues or look in the DB2diag.log file. The DB2DIAG.LOG is either in the directory specified by the DBM CFG... -
DB2 Version 2
I have actually tried DB2 Connect v5 on W2k. The install works, but client connectivity does not! You will have to upgrade no other way around it. -
Procedure creation problems
The difference is in the statement terminator. By default you are using ';' at the command line. Note that the SQL procedure languages uses ';' to terminate individual SQL statements. From a Create Procedure perspective the entire body (all SQL statements that make up the procedure) is one SQL... -
DB2 back up while it is being accessed
The key to DB2 online backups is the Database Configuration Parameter "LOGRETAIN". Set this parameter to ON, take a full off-line backup and you will be set to use Online backups. You have probably noticed on the Options tab for the backup GUI that the online option is not available... -
Export DB2 Data To Fixed Length Text File
Hi john, I'm thinking that there might be other ways to do the same thing. Specifically, you don't like the quotes. You can look into using just a select statement like "Select cast(...)||..." and you would not have to use EXPORT. You can turn off the column headers by using (from a... -
Export DB2 Data To Fixed Length Text File
The EXPORT utility is flexible enough to take SQL statements like select cast(intvalue as char(12)),cast(charval as char(12)) from mytable. In this way you can force aliegnments and left justify all fields. -
How do I run db2cmd in a silent mode?
The command reference docs show a few options that you can provide to DB2CMD none of which will do what you want. Look under ch. 1 of the command reference for "db2cmd - Open DB2 Command Window". That's the best I can offer although I believe that if the BAT file runs minimized the...
