• Tried to go larger than storage limit for object OBJECTNM OBJECTNM

    OBJECTNM is our file name. Some of thedetails of the file are given below. Member size . . . . . . . . . . . . . . . . : SIZE       *NOMAX   Access path size  . . . . . . . . . . . . . : ACCPTHSIZ  *MAX1TB  Access path logical page size . . . . . . . : PAGESIZE   *KEYLEN  Total records  ....

    sim400305 pointsBadges:
  • DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400

    I have around 5 years of IT experience in Mainframe and Midrange operations. As I'm more intersted in database administration, recently I did IBM DB2 9 Fundamentals certification and also IBM Mainframe application development course ( JCL,VSAM,COBOL,DB2,CICS) but it was 5 years back. I want to go...

    Sarada1115 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command

    i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

    Mdshadabalam85 pointsBadges:
  • Comparing DB2 between AS/400 and mainframes

    How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for...

    Dwiningsih25 pointsBadges:
  • What are the possible situations where DB2 server FORCES to close the applications connected to it?

    Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

    Saimadhu455 pointsBadges:
  • Inserting DB2 records on iSeries to SQL Server 2005 Table

    I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks

    shizam5 pointsBadges:
  • List Active Users In IBM Content Manager?

    Is there a way to determine the number of active users in Content Manager? We have a licensing issue and want to know how many users are actually using the product. Being able to view the last login date would be nice. We are using IBM DB2 Content Manager Enterprise Edition V8

    Batman471,050 pointsBadges:
  • Data Extraction into SQL Server Database from Cache ODBC Database

    Hi.I am trying to extract data from an intersystems cache database into a sql server database for storage and reporting purposes, on behalf of my company. I have not succeeded so far for the last couple of months as it keeps bringing back far more than the expected number of rows, and is...

    SPIDDY0 pointsBadges:
  • DFSMSdss / ADRDSSU (Dump Full or Copy Full)

    I'm new to Systems Administratios on Z/OS Series MVS systems. I have one DASD volume that was one of the system default workpacks, (it was initizlized with a small VTOC). This volume (WRKSP1) has multiple types of data on it, VSAM files, flat files, PDS files, DB2 Archival log datasets. The issue...

    Liberty5 pointsBadges:
  • How to sort a db2 table column, containing date stored in char format.

    i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order.  051193 -> 5 nov 1993  140308 -> 14 march 2008  141211 -> 14 december 2011   Now how do i sort this column...

    Maverickgiant40 pointsBadges:
  • DB2 Process automatically Shutdown

    At  our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log  shown the  DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh

    Linuxroot35 pointsBadges:
  • Can Siebel run on AS/400 / iseries and connect to DB2/400?

    Can Siebel run on AS/400/iseries and connect to DB2/400? If not what are the best options to deploy it on AS/400?

    Uiiuo50 pointsBadges:
  • Excel Spreadsheets

    We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...

    Joshua55 pointsBadges:
  • Inserting and viewing of Chinese characters in DB2400

    Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file - with CCSID 1200 and still the same thing...

    Vkm5 pointsBadges:
  • Tables in DB2 z/OS

    In which dataset will I be able to find the default tables of DB2 V9 in Z OS

    KarishmaKapoor20 pointsBadges:
  • DB2 Views

    How to find the number of views for a DB2 table?

    Bharathbhaskar10 pointsBadges:
  • DB2 Tuning link or manual for AS400

    Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don't know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.

    Mariodlg2,790 pointsBadges:
  • SQL Update Set: Higlight Customers without Invoices, Update and join Tables?

    Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to "not active" in the customer table that did not receive invoices since 2008. I can "Select" the corresponding records in the customer table...

    Cavallino30 pointsBadges:
  • DYNSLT

    In what way DYNSTL keyword be usefull??? Can anyone please explain with example... Will be very Thankfull.

    Vishal2370 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following